Check the deleted record log

shiva_gupta · ‎09-26-2017

Hi,

In service now imp_user[import set table] contain some entry(record) whenever we load data inside this table, I want to know where I can check the log details and which user or scheduler is responsible for deleting the record in this table.

Also please help me to identify how to identify which cleanup scheduler is responsible for deleting the record in the import set table.

gtalreja · ‎09-26-2017

Hello Shiva,

To answer your first question, you can go to table "sys_audit_delete" by typing the tablename.list <sys_audit_delete.list> in the application navigator, and check all the records that were deleted.

In your case you would be searching it with the Table name <imp_user> To identify who deleted the record make "updated by" and "created by" field available on the form.

And the Schedule Job name is "Import Set Deleter", you can see it in the following table "sysauto.list", which is a schedule jobs Table.

View solution in original post

Pradeep Sharma · ‎09-26-2017

Isn't this the same response I have given 😉

gtalreja · ‎09-26-2017

Partially, yes..!

shiva_gupta · ‎09-27-2017

thanks for the help, really helpful.

just a quick question I can see the history of deleted record of imp_user in the sys_audit_delete table,

but I have an import set table manually created by the user in which I remember on last Friday the no of record present was around ~50 lakh but today I can see no record is present and also no cleanup schedule is defined for this table also I am not able to see any history of record deleted in the table sys_audit_delete, is there any way to know what happens to those record.