Reporting on report usage revisited

Nearly three years ago I wrote about how to query the ReportServer database and see who is running which reports. Since then I’ve made it a bit more focused. Which reports are being used the most? Which users are the busiest and which reports are they looking at? Here’s what I came up with.

(NB: This is for 2008 or 2008 R2 Reporting Services in standalone mode. I’ve no idea what you get in SharePoint mode.)

Report Heatmap

Which reports are being used the most?

If you click on a report you see…

Report Usage

Who has been using that report?

Report User Heatmap

Who are the busy users?

If you click on a user you see…

Report User History

Which reports has that user has been running?

Feel free to download the RDL files and stored procedures here and use them yourself.

Advertisements

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s