How to identify reports that have not been used in a year?

[twinkledomadia]

Hi, We have around 2500   reports in our servicenow portal and we would like to identify reports that have not been run   or used in last one year. How can I find that?   We are using Geneva   the version. I have tried using last run date in the views/run tab but not able to find where the field is stored, all it doesn't consider all the reports.

[Chuck Tomasi]

Hi Twinkle (love the name BTW)

Go to Reports> Report Statistics. You'll see all the info you desire.

[twinkledomadia]

Hi chuck,

Thank you for your quick reply.   Do you mean query the report stats table coz in my version I can't see a build in option of Report Statistics. Thanks aain.

[Chuck Tomasi]

What version of ServiceNow are you running? I thought it has been there for a while...

[twinkledomadia]

I am using the Geneva version patch 4, this is how the reports are structured