@Community Alums 

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! 🙏