Scripts: GlideRecord sys_history_set / sys_history_line / sys_audit

[tiagomacul]

Sample code related to auditing

• task
• sys_history_set
• sys_history_line
• sys_audit

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:

.

Script Summary

Summary