Archival of Unused Reports

[baig]

Hello All,

Has anyone implemented archival of Unused Reports, within our platform number of reports created are growing day by day and have reached 100,000, so we are planning to archive the reports which have run 0-1 time and last run is more than a year. 

Can someone please advise the best practice here?

Also, I don't see Reports table in archival.

[Mohith Devatte]

Hello @baig 

You cannot create an archive rule for a table for which update_synch is set to true in the dictionary entry for the table.

In the below screenshot i have open dictionary of sys_report table and i opened collection type field and i saw that update_synch is set to true .So it wont be visible in the drop down of archive rules until you remove this update_synch

Refer this link for explanation on table field 

https://docs.servicenow.com/bundle/rome-platform-administration/page/administer/database-rotation/ta...

Hope this helps 

Mark the answer correct if this helps you 

Thanks

[baig]

Any advice of best practices?