How can I get a list of reports and the last time they were run?

[michaeljohn]

In an effort to perform some report cleanup, I need to know how I can get a list of all of the reports and the last time they were run and by whom. This will aid me in my conversations with users and the eventual cleanup of old, unused reports. We are currently on the Eureka version. Thank you.

[zica]

Mike,

Report >> view / run will give you the list of all reports (click on all on the header to get all reports). you have a column called last run that will help you to know which report were run for the last time.

http://wiki.servicenow.com/index.php?title=Generating_Reports#Viewing_the_Reports_List

[gyedwab]

Not only that, but there's a tabled called Report View that tracks every time you run a report.

For example, here's a report built on that table that shows you how many views each report had by quarter:

Reports by views

Another way of looking at it, shows the time since the last report view:

Reports by views  

[michaeljohn]

I do not see that table when I go to create a new report. Could this data be under another table name? Is it named something different in Eureka? Do I need admin access to see this table?

Thanks,

Mike Ryba

Mike Ryba Manager, Governance and Configuration Management

111 N Canal St | Chicago, IL 60606 | USA | +1 312 517 6091

[gyedwab]

My instance is a Eureka instance.

There is a system property called glide.ui.permitted_tables which your admin may need to add the table to in order report against.

[gyedwab]

Actually, sorry -- I just double-checked and I didn't have that table added to that property. However, there is an ACL that requires the role report_admin out-of-the-box.