Disabling old reports

[Paul H2]

Is there a way to make it so that reports that have not been run in over a year cannot be executed? In addition, on the page of a report that has been disabled this way, would it be possible to display a message saying "this report has been disabled due to lack of recent use, please contact [insert number here] to have it re-enabled"?

Apologies if this is not the right forum for this question.

[Arav · Accepted solution]

Hi,

You can run a scheduled job to query Report Statistics with a focus on "Last Run" column and get those reports that have not been executed in the last year (please see below link for more details).

https://docs.servicenow.com/en-US/bundle/tokyo-now-intelligence/page/use/reporting/reference/report-statistics.html

There isn't a way to deactivate reports and so you may want to restrict the visibility to either admin user or another specific user.

Thanks,

Arav

[Paul H2]

Thank you Arav! This gave me a good gauge of how many reports this would affect. 

I suppose I should have asked this in my initial post, but how would outright deleting these reports impact ServiceNow's performance, if at all (given how old these reports are)?

[Arav]

Hi Paul,

You can certainly consider deleting these reports but please check usage of these in dashboards or scheduled reports before taking that action.

Thanks,

Arav