We're reclaiming inactive PDIs to keep them available for active builders. Learn what's changing, who's affected, and how to protect your work. Read More

tiagomacul
Giga Sage

Sample code related to auditing

  • task
  • sys_history_set
  • sys_history_line
  • sys_audit

find_real_file.png

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:

find_real_file.png

.

image

Script Summary

Summary

 

Version history
Last update:
‎12-23-2020 08:11 AM
Updated by: