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

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,

select
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 😉

Advertisements
Categories: T-SQL
  1. No comments yet.
  1. No trackbacks yet.

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s

%d bloggers like this: