Is there a best practice for report cleanup or purging

- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
04-08-2019 09:43 AM
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.?
- Labels:
-
Reporting
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
04-08-2019 10:18 AM
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

- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
04-08-2019 12:10 PM
Thanks for your feedback. What do you use for usage timeframes? Do you verify with the report creator?
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
01-15-2020 06:51 AM
Do you know if dashboard views is included in this?

- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
01-15-2020 09:56 AM
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