May 11, 2012 at 11:47 am
Not sure if this is where to ask this or not,
In Report Manager, is there a way to search all report Subscriptions by creator?
May 11, 2012 at 5:59 pm
You should be able to query the ReportServer database to find what you need. I don't have access to a report server right now so I can't give you the specifics.
May 15, 2012 at 2:18 pm
Try this:
USE ReportServer
GO
SELECT u.UserName, s.*
FROM subscriptions s
INNER JOIN Users u
ON s.OwnerID = u.UserId
AND u.UserName = 'Jared'
Jared
CE - Microsoft
May 16, 2012 at 1:41 am
Following on from Jared's script, this is the script that I use as it shows me the parameter values as well as the parts of the subscription I need to determin where things are sent and when
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
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply