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*
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:
.
View original source
https://www.servicenow.com/community/developer-articles/scripts-gliderecord-sys-history-set-sys-history-line-sys-audit/ta-p/2307652