Archive for 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,

reps.Name as ReportName
,usr.UserName createdby
from Subscriptions subs
join Catalog reps on subs.Report_OID = reps.ItemID
join Users usr on subs.OwnerID = usr.UserID​

This is will help in finding who has created the subscriptions in report server DB, rather trying by each users in report manager. When it would be useful ? take for instance, if your customer wants some of the email IDs to be removed in the existing subscriptions. Unless we have the information that who has created the existing subscriptions, the email ids cannot be edited.

Happy Querying 😉

Categories: T-SQL
%d bloggers like this: