how to deal with the delete data in servicenow？

[lei wang]

how to deal with the delete data in servicenow？

1、Logical deletion or physical deletion

2、if is ‘Logical deletion’，data store what table？

[Sagar Pagar]

Hi,

You can check the Deleted record [sys_audit_delete] table for deleted data.

Thanks!

Sagar Pagar

[Anurag Tripathi]

Hi,

Usually most companies will have some rule for data retention so deleting the data is not ideal, unless it is transitional data.

For the ticket data(where retention policy fo the company would apply) we usually recommend using System Archiving

For data that can be deleted I would suggest you can choose to  use Table Rotation or Table Extension

-Anurag

[Jaspal Singh · Accepted solution]

In a way ServiceNow has both

1、Logical deletion or physical deletion

Both. For Physical deletion it 28 days until it is deleted. Check table Deleted records & also check HI article.

Logical deletion always exists in respective table that uses Active field.

2、if is ‘Logical deletion’，data store what table？

Active field on tables. For instance, User table has Active field if set to False it is not visibile to non-admin users but still exsits in Database.