Report Server Report Usage

  • Comments posted to this topic are about the item Report Server Report Usage

    For better, quicker answers on T-SQL questions, read Jeff Moden's suggestions.[/url]

    "Million-to-one chances crop up nine times out of ten." ― Terry Pratchett, Mort

  • Thanks, Dennis! I have been meaning to do something similar for a while, so it was nice to have something already done to use. It's very interesting to see the information on the various reports.

    For those who are still working in 2005 like we are at my work, I modified the code to use the ExecutionLog and Catalog tables. I replaced all the listings for ReportPath with c.[Name] and added the join to Catalog with ExecutionLog e JOIN Catalog c ON c.ItemID = e.ReportID.

    Thanks again!

  • The code had just one simple error, a missing semi-colon but got the report usage not only for Native Mode but also for SharePoint Integrated mode report server.

  • Thanks for the script.

Viewing 4 posts - 1 through 3 (of 3 total)

You must be logged in to reply to this topic. Login to reply