Scripts::. Select GlideRecord sys_audit
Como testar / debugar o seu script?
System Definition > Scripts - Background
Exemplo para Update
//
var ObjAudit = new GlideRecord("sys_audit");
ObjAudit.addQuery("documentkey", "14d1e2de0fe20300975587ece1050e65");
ObjAudit.orderByDesc('sys_created_on');
ObjAudit.query();
ObjAudit.next();
gs.print("documentkey=" + ObjAudit.documentkey);
gs.print("fieldname=" + ObjAudit.fieldname);
gs.print("internal_checkpoint=" + ObjAudit.internal_checkpoint);
gs.print("internal_checkpoint=" + ObjAudit.internal_checkpoint);
gs.print("newvalue=" + ObjAudit.newvalue);
gs.print("oldvalue=" + ObjAudit.oldvalue);
gs.print("reason=" + ObjAudit.reason);
gs.print("sys_created_by=" + ObjAudit.sys_created_by);
gs.print("sys_created_on=" + ObjAudit.sys_created_on);
gs.print("sys_created_on=" + ObjAudit.sys_created_on);
gs.print("sys_id=" + ObjAudit.sys_id);
gs.print("tablename=" + ObjAudit.tablename);
gs.print("user=" + ObjAudit.user);
ObjAudit.user.setValue("TestA");
ObjAudit.update();
//
Exemplo para Insert
var ObjAudit = new GlideRecord("sys_audit");
ObjAudit.initialize();
ObjAudit.documentkey ="14d1e2de0fe20300975587ece1050e65";
ObjAudit.fieldname = "Attachment";
ObjAudit.sys_created_on = "2017-11-27 10:41:39";
ObjAudit.newvalue = "new attach";
ObjAudit.sys_created_by = "Tiago Macul";
ObjAudit.user = "Tiago Macul";
ObjAudit.insert();
Onde verificar:
https://.service-now.com/sys_audit_list.do?sysparm_query=documentkeySTARTSWITH14d1e2de...
XML
14d1e2de0fe20300975587ece1050e65
short_description
15fea2ae3830000001
teste update 10
teste update 9
41
admin
2017-11-23 18:36:40
e3c29b2a0f2e0300975587ece1050ecd
incident
TestA
Rest API Explorer
https://.service-now.com/nav_to.do?uri=/$restapi.do
WSDL
https://.service-now.com/api/now/table/sys_audit?sysparm_limit=1
WSDL Response Body
{ "result": [ { "fieldname": "version", "reason": "", "sys_id": "21737a1337210200f212cc028e41f1ae", "newvalue": "1.0", "sys_created_on": "2015-04-22 22:27:44", "documentkey": "27d3f35cc0a8000b001df42d019a418f", "internal_checkpoint": "14ef5ad7c3b0000001", "record_checkpoint": "10", "tablename": "cmdb_ci_service", "user": "admin", "oldvalue": "", "sys_created_by": "admin" }
]

https://www.servicenow.com/community/brazil-snug/scripts-select-gliderecord-sys-audit/ba-p/2278700