Post reply

Reporting on Reporting Services

  • May 8, 2008 at 2:42 pm

    #187447

    Do you know if there is a way in reporting services to pull information from to tell us all of the reports that are deployed, which folder, the owner, security, date last run(?), etc

    Thanks

  • May 8, 2008 at 3:31 pm

    #812723

    Yes, you'll need to query the tables in the ReportServer database on your report server box.

    In particular look to these tables:

    catalog - contains data for deployed reports

    users - contains data for users with access to deployed reports

    executionlog - contains report execution data like last run date, etc.

    subscriptions - contains data related to subscriptions

    SecData - security data

    Be careful NOT to do anything other than SELECT statements as this is your production data. heaven only knows the damage you could do with an inadvertent INSERT or DELETE.

    HTH

    [font="Comic Sans MS"]toolman[/font]
    [font="Arial Narrow"]Numbers 6:24-26[/font]

  • May 9, 2008 at 9:00 am

    #813122

    Thanks, It helps

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

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