how to identify the reports which are not being used and correlation with other report

[er_anmolmittal]

I need to identify the reports and dashboards which are not being used, I can see 2 tables sys_report & report_stats which i am referring, In table repor_stats i can find the direct field Last Run. But both the tables have data which are not matching. Ex.(in first table i am having 10k records and in second table i am having 12K records)

[AndersBGS]

Hi @er_anmolmittal ,

The report_stats table contains last run information about the different reports. The sys_report contains all reports. So there could potential be a difference between these two. 

[JHONES]

ChatGPT said:

To identify reports that are not being used, start by analyzing usage logs or tracking metrics such as access frequency, last viewed date, and user interaction history. Reports with little to no activity over a defined period—such as six months—can be flagged for review. Once these low-usage reports are identified, examine their correlation with other reports by comparing data sources, metrics, and intended purposes.

[AndersBGS]

Hi @JHONES ,

Don't post rubbish chatGPT. Your answer doesn't do other that just fil up the community with text that doesn't provide any value.

[JC Moller]

There is a UI page called "get_unused_report", that writes data for unused system reports that are not in the report statistics table.

There are some usable columns in the table that are not on the form (last screenshot). I have used these and SNUtils lets me easily add dot-walked columns to the stats table. Now I can e.g.. sort by company for reports where the user has made an exit 3 months ago or search identical (copies / filter & table are same) of reports (hundreds).  

Columns in report_stats table: