How to identify which Report/Dashboard is not used

er_anmolmittal
Tera Contributor

How to identify the reports which are not being used from past one year.

I have used the Last run from table [report_stats] is that correct ?

5 REPLIES 5

AndersBGS
Tera Patron
Tera Patron

Hi @er_anmolmittal ,

 

Yes, that would be the correct approach.

 

If my answer has helped with your question, please mark my answer as the accepted solution and give a thumbs up.

Best regards
Anders

Rising star 2024
MVP 2025
linkedIn: https://www.linkedin.com/in/andersskovbjerg/

KrushnakumaT
Tera Guru

Hi @er_anmolmittal , 

Yes, you are correct, the report_stats table is the right one to use.

It stores the last run history of reports.
To find reports not used in the past 1 year, check if they have no entries in report_stats in the last 12 months.

This helps you identify reports that haven't been run recently and may no longer be needed.

If this response helped, please mark it as the correct answer so it can help others as well.
Thank you!!

OlaN
Giga Sage
Giga Sage

Hi,

You should also check which reports are sent out through the scheduled reports [sysauto_report]

Reports that are sent out from this is not counted towards the report stats, since it's not viewed in a regular manner.

Bhuvan
Kilo Patron