1) Find reports which are owned by inactive users
-> sys_report add this filter conditions
Created by user.active=false^Active=true
also check these links
Housekeeping tips: How to make your dashboards shine
Tracking and Reporting on Dashboard Usage in ServiceNow
💡 If my response helped, please mark it as correct ✅ and close the thread 🔒— this helps future readers find the solution faster! 🙏
1.Criteria would be a report that has not run in more than four months can be flagged for deletion
-> report_stats table holds report and it's last run or when was it last viewed, use that table to determine 4 months and then delete report
2.we need to identify the owners and if there's no owner if these are attached to any dashboards as well. that will give us potential dashboard for deletion
-> check this on tracking dashboard views, those which are not viewed you can delete
Tracking and Reporting on Dashboard Usage in ServiceNow -> detailed blog
I believe I answered your question
💡 If my response helped, please mark it as correct ✅ and close the thread 🔒— this helps future readers find the solution faster! 🙏
