Tip for Subscriptions - SQL Server Forums

Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

All Forums

Development Tools

Reporting Services Development

Tip for Subscriptions

Author

Topic

jhermiz

3564 Posts

Posted - 2005-12-05 : 08:54:24

A while back I posted how to get a listing of all the users that are actually running reports. This helps the VP's and Presidents of a company see if people are actually running reports.

This next tip helps if you want to find out how many subscriptions are going out of your RS server. You do have your own RS server right


SELECT     Users.UserName AS TheUser, 
           Subscriptions.*,   --you don't have to return all the rows here
           [Catalog].Name AS ResportName
FROM       [Catalog] INNER JOIN
           Subscriptions ON [Catalog].ItemID =     Subscriptions.Report_OID INNER JOIN
                      Users ON Subscriptions.OwnerID = Users.UserID

This helps since you don't have to pay a visit to the report server just to inspect this. In fact you can create a report of this in RS :).

Jon

Keeping the web experience alive -- [url]http://www.web-impulse.com[/url]

thezo
Starting Member

4 Posts

Posted - 2005-12-08 : 18:43:35

Can you post a link to the original thread you are talking about? I'd love to implement what you're talking about.