February 9, 2009 at 10:29 am
Hi, I am trying to find all the active subscriptions we have in our reportserver database. I want to know the reportname, and what time it's scheduled to run. I am using InactiveFlags = 0 to pull all the active subscriptions.
So far, I am able to write the following query, please let me know what I should do to get the desired info.
SELECT Report_OID, LastRunTime, SubscriptionID, *
FROM Subscriptions
WHERE InactiveFlags = 0 --to pull active subscriptions
ORDER BY LastRunTime desc
Please advice.
Thanks!
February 9, 2009 at 11:48 am
Are you getting an error?
February 9, 2009 at 11:51 am
Bob (2/9/2009)
Are you getting an error?
No it's running fine, I need to know how I can find the report name? Thanks!
February 9, 2009 at 2:56 pm
Looks like, match subscription report_oid with catalog.itemid? I'm off to a meeting....let me know if you get...I'll play around with it also
February 9, 2009 at 3:02 pm
That's it....
SELECT
[Catalog].Name,
Report_OID, LastRunTime, SubscriptionID
FROM Subscriptions inner join [Catalog] on
Report_OID = ItemID
WHERE InactiveFlags = 0
Viewing 5 posts - 1 through 4 (of 4 total)
You must be logged in to reply to this topic. Login to reply