SELECT     dbo.Subscriptions.Description, dbo.[Catalog].Name, dbo.Users.UserName
FROM         dbo.Subscriptions INNER JOIN
                      dbo.[Catalog] ON dbo.Subscriptions.Report_OID = dbo.[Catalog].ItemID INNER JOIN
                      dbo.Users ON dbo.Subscriptions.OwnerID = dbo.Users.UserID

quote:

---

Originally posted by jhermiz

All information is stored in the RS database itself. Remember RS uses sql server so look at the ReportServer database.

There is a table called Subscriptions.

I recommend you read my post on the power of the report server:

http://jhermiz.googlepages.com/powerofreportserver

This will show you how to learn to use the report server database to do jobs that otherwise would be difficult or impossible to do with their clunky interface.

After you read the above post, which you should do so you understand how the RS database works. Then try running the following:

SELECT     dbo.Subscriptions.Description, dbo.[Catalog].Name, dbo.Users.UserName
FROM         dbo.Subscriptions INNER JOIN
                      dbo.[Catalog] ON dbo.Subscriptions.Report_OID = dbo.[Catalog].ItemID INNER JOIN
                      dbo.Users ON dbo.Subscriptions.OwnerID = dbo.Users.UserID

This will list to you all reports being used by RS users.
To delete subscriptions simply use a DELETE statement against the records you dont want from the subscriptions table. However, please note these DELETE the subscription it will be GONE.

If however, just want to inactivate them then set the activity level flag in the subscriptions table to 1.

Jon

Programmers HowTo's -- [url]http://jhermiz.googlepages.com[/url]

---

quote:

---

Is the schema of the Reporting Services database documented?

Do you have a link to it?


CODO ERGO SUM

---