Scripts::. Select GlideRecord sys_audit

tiagomacul · ‎11-24-2017

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://<InstanceName>.service-now.com/sys_audit_list.do?sysparm_query=documentkeySTARTSWITH14d1e2de...

XML


<xml>

<sys_audit>

<fieldname>short_description</fieldname>

<internal_checkpoint>15fea2ae3830000001</internal_checkpoint>

<newvalue>teste update 10</newvalue>

<oldvalue>teste update 9</oldvalue>

<record_checkpoint>41</record_checkpoint>

<sys_created_by>admin</sys_created_by>

<sys_created_on>2017-11-23 18:36:40</sys_created_on>

<sys_id>e3c29b2a0f2e0300975587ece1050ecd</sys_id>

<tablename>incident</tablename>

<user>TestA</user>

</sys_audit>


</xml>

Rest API Explorer

https://<InstanceName>.service-now.com/nav_to.do?uri=/$restapi.do

WSDL

https://<InstanceName>.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"
   }
   ]

ServiceNow Scripting 101: Two Methods for Code Development