reportusage_sample_thumbSSRS is an amazing tool.  And it’s easy, over time, to add dozens (and even hundreds) of reports.  Some of these reports may be used daily, some weekly or quarterly, some once a year or so, and some only once ever.

How can we tell which reports are used and how frequently?  SSRS to the rescue!  Both Native Mode and SharePoint Integrated mode support a method of querying reporting services to find the usage history of all executed reports.  I performed these queries and created this sample SSRS report to visualize the usage over time.

Reporting Services usage sample report

Reporting Services usage sample report