logo

NJP

Scripts: GlideRecord sys_history_set / sys_history_line / sys_audit

Import · Dec 23, 2020 · article

Sample code related to auditing

  • task
  • sys_history_set
  • ***sys_history_line*
  • ***sys_audit*

image

varTarget = "";

var grRecord = new GlideRecord("task");
grRecord.addQuery("sys_id", "1cf6094d1b99201070f10f60f54bcb2f");
grRecord.query();
if (grRecord.next()) 
{
  varTarget = grRecord.getValue("sys_id");
   gs.log("number = " + grRecord.number.getDisplayValue());
}


var LineID = "";
var grSet = new GlideRecord("sys_history_set");
grSet.addQuery("id", varTarget);
grSet.query();
if (grSet.next()) 
{
   gs.log("ID = " + grSet.id.getDisplayValue());
   LineID = grSet.getValue("sys_id");
}


var grLine =new GlideRecord("sys_history_line");
grLine.addQuery("set", LineID);
grLine.query();
if (grLine.next()) 
{
   gs.log("Line ID = " + grLine.set.getDisplayValue());
}


var grAudit = new GlideRecord("sys_audit");
grAudit.addQuery("documentkey", varTarget);
grAudit.query();
if (grAudit.next()) 
{
   gs.log("audit = " + grAudit.sys_id.getDisplayValue())
}

Results:

image

.

image

Script Summary

Summary

View original source

https://www.servicenow.com/community/developer-articles/scripts-gliderecord-sys-history-set-sys-history-line-sys-audit/ta-p/2307652