How to get all SSRS Subscription Data using stored procedure?
<p>I am new to ssrs.</p>

<p>I want to get all the possible data for ssrs subscribed report, which are Available in ResportServer database.</p>

<p>I have found some queries, but that does not have proper data. It only works for single report.</p>

<p>I need list of unique subscription with it's data. If possible stored procedure is preferable.</p>

<p>My query:</p>

<pre><code>SELECT
        b.name AS JobName
        , e.name
        , e.path
        , d.description
        , a.SubscriptionID
        , laststatus
        , eventtype
        , LastRunTime
        , date_created
        , date_modified
FROM ReportServer.dbo.ReportSchedule a
JOIN msdb.dbo.sysjobs b
        ON a.ScheduleID = b.name
JOIN ReportServer.dbo.ReportSchedule c
        ON b.name = c.ScheduleID
JOIN ReportServer.dbo.Subscriptions d
        ON c.SubscriptionID = d.SubscriptionID
JOIN ReportServer.dbo.Catalog e
        ON d.report_oid = e.itemid
WHERE e.name = 'Sales_Report'
</code></pre>

<p>Thanks in advance.</p>