Post reply

Report Server Report Usage

  • December 11, 2012 at 8:17 pm

    #267918

    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

  • December 12, 2012 at 7:29 am

    #1567889

    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!

  • June 11, 2013 at 6:59 pm

    #1623189

    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.

  • May 3, 2016 at 6:59 am

    #1876206

    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