How to request sys_audit_delete table ?

thibautdeflandr · ‎09-01-2017

Hi guys,

I would like to make a query on sys_audit_delete table but apparently it's not possible, indeed i always got a isValidRecord == false.

my code:

var myRecord = new GlideRecord('sys_audit_delete');
myRecord.addQuery('tablename', 'incident');
myRecord.addQuery('documentkey', 'myexistingdocumentkey');
myRecord.query();
gs.addInfoMessage(myRecord.isValidRecord()); //false

Also i can't access to this table through the rest API explorer.

Do you know why ? and if there is a possibility to access to the record (only read) of this table in a script include ?

Thanks a lot.

vinothkumar · ‎09-01-2017

Hi Thibaut,

Try something similar as below and it worked. just changed the table name and document key and it is returning true. Can you check it

var myRecord = new GlideRecord('sys_audit_delete');

myRecord.addQuery('tablename', 'u_vp_task_relationship');

myRecord.addQuery('documentkey', 'a2ba47bbdb304700566cfe18bf96193e');

myRecord.query();

if(myRecord.next())

{

gs.addInfoMessage(myRecord.isValidRecord()); //false

}

View solution in original post

thibautdeflandr · ‎09-04-2017

It's works, i had already try that but maybe another thing was causing an error.

Thanks,