Is there a best practice for report cleanup or purging

GeauxSteve
Kilo Contributor

We have been using ServiceNow for almost five years and we have thousands of reports created by users that have not been run in months or years.  Does anyone have a best practice for purging the unused reports?  What is the best method to remove all report related elements when deleting them like scheduled export jobs, report statistics, etc.?

5 REPLIES 5

Harshinya1
Mega Guru

You can analyze Report Views(report_view) table for unused reports and can purge them if they haven't been used in past couple months or years

 

Hope this helps

Thanks for your feedback. What do you use for usage timeframes?  Do you verify with the report creator?

Do you know if dashboard views is included in this?

It does not. The table you want to look at is sys_ui_navigator_history. Admin only though.

 

Here is more info on where SNow's report manager created a table and other items to track that in a better way: https://community.servicenow.com/community?id=community_blog&sys_id=19bdcd95dbb5ef001089e15b8a961937