asked on

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

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?

Faiga Diegel

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 Diegel

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

BostonMA

ASKER

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...

ASKER CERTIFIED SOLUTION

Faiga Diegel

membership

This solution is only available to members.

To access this solution, you must be a member of Experts Exchange.

Start Free Trial

BostonMA

ASKER

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.

BostonMA

ASKER

Good enough for now, thanks.

alchemy9

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