March 16, 2012 at 5:29 pm
I just started to use reporting server R2, is there a way in report manager that I can see all the subscriptions, I know I can only see my own subscriptions, but as a dba, if I want to see all the subscriptions no matter created by me or others , how can I do that?
March 19, 2012 at 3:30 am
Go to "Properties" tab. Click on "Securities". Add your login to "Content Manager" Role.
March 19, 2012 at 3:40 am
run this in the reportserver database
SELECT
U.UserName AS SubscriptionOwner,
C.Path AS ReportPath,
CONVERT(XML,S.ExtensionSettings) AS SubscriptionSettings,
S.EventType AS SubscriptionType,
CONVERT(XML,S.Parameters) AS ReportParameters,
S.DeliveryExtension AS DeliveryMethod,
Sc.Name AS ScheduleName,
Rs.ScheduleID
FROM
Subscriptions S
INNER JOIN
Users U
ON
S.OwnerID = U.UserID
INNER JOIN
Catalog C
ON
S.Report_OID = C.ItemID
INNER JOIN
ReportSchedule RS
ON
S.SubscriptionID = RS.SubscriptionID
INNER JOIN
Schedule Sc
ON
RS.ScheduleID = Sc.ScheduleID
ORDER BY
1,2
March 19, 2012 at 2:09 pm
Suresh B. (3/19/2012)
Go to "Properties" tab. Click on "Securities". Add your login to "Content Manager" Role.
I don't think this will work, I am a system administrator, also I have content management role, but still I can only see my subscriptions.
March 20, 2012 at 3:37 am
Are you clicking on "My Subscriptions" or viewing them from the report itself?
March 20, 2012 at 3:57 pm
I got it, thanks, I can go to report and see the subscriptions of others created.
March 21, 2012 at 1:55 am
the script i provided will also give you the information but for all reports which have subscriptions so your not having to load each report to view its individual subscriptions
March 21, 2012 at 10:01 am
Thanks for the scripts, I saved it to my DBA scripts
Viewing 8 posts - 1 through 7 (of 7 total)
You must be logged in to reply to this topic. Login to reply