Skip to content

Instantly share code, notes, and snippets.

@jinweijie

jinweijie/RS_Subscription.sql

Created July 18, 2012 01:55
Show Gist options
  • Save jinweijie/3133592 to your computer and use it in GitHub Desktop.
Save jinweijie/3133592 to your computer and use it in GitHub Desktop.
Download ZIP
Reporting Service Subscription Query
Raw
RS_Subscription.sql
SELECT usr.UserName,
cat.name,
sub.*
FROM [Subscriptions] sub
INNER JOIN [Users] usr ON sub.OwnerID = usr.UserID
INNER JOIN [Catalog] cat ON sub.report_oid = cat.itemid
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment