InstantForum.NET v2.9.0SQLServerCentralhttp://www.sqlservercentral.com/Forums/notifications@sqlservercentral.comWed, 19 Jun 2013 04:24:28 GMT20http://www.sqlservercentral.com/Forums/Topic1358274-150-1.aspxThis should get you to a pretty good starting point[code="sql"]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.ScheduleIDFROM Subscriptions SINNER JOIN Users UON S.OwnerID = U.UserIDINNER JOIN Catalog CON S.Report_OID = C.ItemIDINNER JOIN ReportSchedule RSON S.SubscriptionID = RS.SubscriptionIDINNER JOIN Schedule ScON RS.ScheduleID = Sc.ScheduleIDORDER BY 1,2[/code]Thu, 13 Sep 2012 01:56:23 GMTanthony.greenhttp://www.sqlservercentral.com/Forums/Topic1358274-150-1.aspxI've be searching and trying for hours to get a query that gives me all current subscriptions from and SSRS serv with parameters and their values, so that they can be recreated on a new server (after pruning) For example a simple report might be HoursByDepartment that takes three params: @From =Today - 7 days (Default) @To = Today (Default) @Dept = 2 (part of subscription) What I want to get is something along these lines (or something that will let me create a report) Report ParamName ParamValue Default HoursByDepartment From Today-7days True HoursByDepartment To Today True HoursByDepartment Dept 2 False OR Report Param1Name Param1Value Param1Def Param2Name Param2Value Param2Def HoursByDepartment From Today-7days True To Today True I'm pretty good with XSl, so if i could get something like, I could work with it <subid> <report> <ParameterValues> <ParameterValue> <Name>MinAvailable</Name> <Value>10000</Value> </ParameterValue> <ParameterValue> <Name>OwnerIDs</Name> <Value>0</Value> </ParameterValue> <ParameterValue> <Name>ShowCosts</Name> <Value>False</Value> </ParameterValue> <ParameterValue> <Name>MinValue</Name> <Value>0</Value> </ParameterValue> </ParameterValues> </report> </subid> Regards MarkWed, 12 Sep 2012 18:03:31 GMTmark 4643