Do we need both Audit checkbox and audit_deleted_tables property for delete tracking?

RajeshEdaguttu · 2 weeks ago

Hi Guys,

If I want to track delete records do I need to follow both steps:
1)Enable Audit check box in table dictionary
2)As well as in "audit_deleted_tables" property in UI properties
If not how can I track deleted records and rollback those records as well? Please provide any resolution?

Regards,
Rajesh Edaguttu.

Rafael Batistot · 2 weeks ago

Hi @RajeshEdaguttu

Got you point

Navigate to All > System Properties > UI Properties.
Locate the List of system tables (beginning with "sys_", comma separated) that will have the delete audited property.
Add or remove table names. Table names should be separated by commas, without any spaces.
Click Save.

Check the reference.

https://www.servicenow.com/docs/r/platforsecurity/t_ConSysTablDelAud.html

If this response was helpful, please mark it as Helpful and, if applicable, as Correct, this helps other users find accurate and useful information more easily.

View solution in original post

Rafael Batistot · 2 weeks ago

Hi @RajeshEdaguttu

May this post help you

https://www.servicenow.com/community/developer-forum/how-to-audit-records-deleted-from-quot-deleted-...

If this response was helpful, please mark it as Helpful and, if applicable, as Correct, this helps other users find accurate and useful information more easily.

RajeshEdaguttu · 2 weeks ago

Hi @Rafael Batistot ,

Thank you for the post. But my question is if I want to track the deleted records for a table do I need to follow below steps or not? if not what will be the next approach to track the deleted records?

1)Enable Audit check box in table dictionary
2)As well as in "audit_deleted_tables" property in UI properties

Rafael Batistot · 2 weeks ago

Hi @RajeshEdaguttu

Got you point

Navigate to All > System Properties > UI Properties.
Locate the List of system tables (beginning with "sys_", comma separated) that will have the delete audited property.
Add or remove table names. Table names should be separated by commas, without any spaces.
Click Save.

Check the reference.

https://www.servicenow.com/docs/r/platforsecurity/t_ConSysTablDelAud.html

If this response was helpful, please mark it as Helpful and, if applicable, as Correct, this helps other users find accurate and useful information more easily.