Post reply

Query of ReportServer database to list reports and associated subscriptions, execution settings

  • June 10, 2011 at 7:54 pm

    #237719

    Does anyone have a query of the ReportServer database that lists all reports, along with their associated subscriptions and execution settings?

    __________________________________________________________________________________
    SQL Server 2016 Columnstore Index Enhancements - System Views for Disk-Based Tables[/url]
    Persisting SQL Server Index-Usage Statistics with MERGE[/url]
    Turbocharge Your Database Maintenance With Service Broker: Part 2[/url]

  • June 14, 2011 at 8:19 am

    #1338409

    Everything you need is in the Subscriptions table:

    SELECT

    C.Name

    ,C.Path

    ,S.LastRunTime

    ,U.UserName AS UserCreated

    ,CONVERT(NVARCHAR(MAX), CONVERT(XML, S.[Parameters]).query('data(/ParameterValues)'))AS [Parameters]

    FROM ReportServer.dbo.Catalog C

    INNER JOIN ReportServer.dbo.Subscriptions S

    ON C.ItemID = S.Report_OID

    INNER JOIN ReportServer.dbo.Users U

    ON S.OwnerID = U.UserID

  • June 14, 2011 at 8:27 am

    #1338421

    Thank you, much appreciated!

    __________________________________________________________________________________
    SQL Server 2016 Columnstore Index Enhancements - System Views for Disk-Based Tables[/url]
    Persisting SQL Server Index-Usage Statistics with MERGE[/url]
    Turbocharge Your Database Maintenance With Service Broker: Part 2[/url]

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

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