What third party tools exist to manage subscriptions in sql server reporting services 2005

BostonMA
BostonMA used Ask the Experts™
on
We have lots of reports and I want a way to see more information about the reports that are currently scheduled, without having to open each subscription one by one in the report manager.  I know all the subscription info is stored in the report server database, however it is all in the form of GUIDs /encrypted and it is not straightforward to query on.  

Does anyone know if there are any prebuilt tools out there which provide a management layer on top of RS specifically for managing subscriptions?
Comment
Watch Question

Do more with

Expert Office
EXPERT OFFICE® is a registered trademark of EXPERTS EXCHANGE®
Faiga DiegelSr Database Engineer

Commented:
Try connecting to the Reporting Services Engine of your Report Server.
On Management Studio, File >> Connect Object Explorer >> Choose Reporting Services on Server Type and choose the Server Name.

Check it out and see if it would help you.
Faiga DiegelSr Database Engineer

Commented:
You were asking for a third party tool, I am suggesting to use the SQL Management Studio.  

Author

Commented:
Huh?  Since when is a tool bundled with SQL server consideed a third party tool?  

Besides, management studio does not offer any tools to manage subscriptions, all it will let you do is query directly against the database.  As my post said, im looking for a layer on top of reporting services which will manage the subscriptions.  Management studio does not do such.

Sorry faiga16 but your comment does not warrant any points, and im a reasonable person...
Acronis in Gartner 2019 MQ for datacenter backup

It is an honor to be featured in Gartner 2019 Magic Quadrant for Datacenter Backup and Recovery Solutions. Gartner’s MQ sets a high standard and earning a place on their grid is a great affirmation that Acronis is delivering on our mission to protect all data, apps, and systems.

Sr Database Engineer
Commented:
I'm not asking for points, I'm suggesting try the Management Studio (you might not need a third party tool for this) connecting to Report Services Engine, NOT the database engine.

On Management Studio, File >> Connect Object Explorer >> Choose Reporting Services on Server Type and choose the Server Name.

You can manage subscription there NOT by querying. It's a UI tool. You can add, delete subscriptions. You might have overlooked at this MS SQL tool.  Try it. If you don't like it, then you don't have to give points.

My goal to answer question here is not only to acquire points but to share some knowledge. I get  good answers and suggestions from this sites, it is just but right to "pay it forward". Again, if you think you don't like the suggestion, you don't have to give points.

Author

Commented:
Okay.  Using Management studio isnt exactly the path that i was looking for, however it looks like there are scripting options through this, so for now it seems this is the only reasonable option.

Author

Commented:
Good enough for now, thanks.

Commented:
There is a 3rd party tool that allows you to manage SSRS subscriptions. It exports subscriptions to Excel, where it is easy to manipulate subscriptions, parameters etc.


SSRS Subscription Manager

Backup report subscriptions to Excel
Restore Subscriptions from Excel
Supports Null, default and multi value parameters
Validate parameter values before restore
Easily identify parameter errors
Works with custom delivery extensions
Change subscription execution times
Incremental execution times for subscriptions.
Rerun subscriptions- reports not run or need to rerun.
Change subscription description
Amended reports having parameter name changes-  This can be a big issue.  Deploy a new report and with different parameter names or an additional parameter and all your subscriptions will stop working.
Works with custom and shared schedules
Migrate subscriptions across different SSRS Servers

Do more with

Expert Office
Submit tech questions to Ask the Experts™ at any time to receive solutions, advice, and new ideas from leading industry professionals.

Start 7-Day Free Trial