Post reply

URGENT, delete reports from report server programmatically

  • July 25, 2011 at 9:52 am

    #1357906

    Well, it does do what the OP requested...:Whistling:

    But you are right, it will leave orphan subscriptions and schedules etc. littering the reportserver db so doesn't provide a very complete solution :blush:

  • July 25, 2011 at 10:33 am

    #1357951

    Looks like the DeleteItem method would be the one to use inside an RS script file to remove all the related objects, but you would still need to iterate through all the folders and pass the path of every report to the method

    The DeleteItem method not only deletes the specified item from the report server database, it also deletes additional items, such as the subscriptions, schedules, and snapshots that are associated with the item.

    http://msdn.microsoft.com/en-us/library/aa225810(v=SQL.80).aspx

    Probably still quicker to take the manual point and click route through ReportManager if you haven't worked with RS script before

  • July 26, 2011 at 10:01 am

    #1358643

    We are thinking to use available tool to help us to do the administration part

    any tool you guys recommend?

    Thanks

  • July 26, 2011 at 10:15 am

    #1358650

    daniarchitect (7/26/2011)

    We are thinking to use available tool to help us to do the administration part

    any tool you guys recommend?

    Thanks

    Nope. First time I see such a requirement. The only thing I've ever read was the delete 1 single report just before deploying (parameter not getting updated correctly). But that's the only thing I've ever seen anywhere close to what you need to do, and it's NOT close at all.

  • July 26, 2011 at 10:31 am

    #1358655

    Me neither, we just used ReportManager to administer reports but we never needed to do a bulk removal so it didn't matter too much having to do things one report at a time

Viewing 5 posts - 16 through 19 (of 19 total)

You must be logged in to reply to this topic. Login to reply