Archived data deletion policy

[vandna]

Hello Everyone,

We wanted to delete the Archived records of Request, RITM and related records on basis of some configurations, which are stored in different table. For example: we have one table where we have different delete duration for different item.

Now the problem is we cannot use OOTB destroy rule because it doesn't have any condition fields and also, we cannot use table cleaner, because even if we delete the archived Request, RITM we could not delete the references like archived variables, audit, etc because archived table doesn't have references.

We have some custom solutions to achieve this requirement but I have following questions.

1. Has anyone implemented something like this before?

2. Is there any best possible way to achieve this requirement?

@Chuck Tomasi 

Thank you in advance!!

[Rupesh11]

Hi Vandna,

I wanted to clarify my understanding of your request to ensure we are on the same page. If I understand correctly, you have not used ServiceNow Archive Rules for your RITM requests, RITM, and related records. Instead, you have archived data to a different table and now wish to purge this custom table data. Is that correct?

Please confirm or provide additional details if necessary.

[vandna]

Hi Rupesh,

We are using OOTB Archival rules to archive the data and I am talking about OOTB archival tables.

[Rupesh11]

Perfect Vandna,

So Archive data is stored in AR_<TableName> as you said and now you what to purge the data with different delete duration for different item. 

Based on your requirements, I will conduct further checks. Could you please let me know if you have any specific conditions or if you are looking for a different duration for data retention?

If yes, please share the use case so I can review it and provide you with the appropriate information.

[vandna]

Hi Rupesh,

I have only one requirement that on basis of catalog items archived data should destroy. For example A catalog item's archived RITM should be destroy in 2 year and B catalog item's archived RITM should be destroy in 1 year.