Monthly Archives: June 2013

T-SQL : Query to fetch report subscription details from SSRS

In SSRS, to find who has created/modified the report subscription without using the management site, the following query can be used, [sourcecode language=”sql” wraplines=”false”] select reps.Name as ReportName ,usr.UserName createdby from Subscriptions subs join Catalog reps on subs.Report_OID = reps.ItemID … Continue reading

Posted in T-SQL | Leave a comment