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,

Sorry for the confusion. I was looking at Helsinki. It looks like it is there. You can get to it by typing report_stats.list in the navigation filter.

I took a look around and it appears Helsinki (where I was testing) made some nice enhancements to Geneva's table. While Geneva doesn't have the last run time, it does have "recent" counts. Don't ask me what "recent" means.

Hope that helps.

[Chuck Tomasi]

Let me know if that answered your question. If so, please mark it as correct so that others with the same question in the future can find it quickly and that it gets removed from the Unanswered list.

If you are viewing this discussion from your "inbox", use the "mark as correct" option under actions. If you are viewing it directly from the thread use the Correct Answer link (red with a star).

Thank you

[twinkledomadia]

Though this helps, but I was looking for something that would give me dates based stats, like when was it last run or has it even been used in last one year. The total number execution could also mean that it was run yesterday or maybe 3 years back.

[Chuck Tomasi]

Agreed. I think the final answer is "It's in Helsinki." I know it's not the answer you wanted today, but... it's there. No enhancement request this time.

[Robert Campbell]

Almost 10yrs later and I was looking for the same thing and this helped me come to the final answer. I had to create a report on the report stats table. The reason I needed to create a report is because the created by and updated by on the reports stats table is the created and updated by of that report stats record which is admin or system. I needed to see the person that actually created the report so I had to create a report so I could dotwalk and get the user's info.