logo

NJP

Scripts::. Select GlideRecord sys_audit

Import · Nov 25, 2017 · article

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"   }

  ]

Image result for knowmore

ServiceNow Scripting 101: Two Methods for Code Development

View original source

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