Post reply

SSRS - Deleting user from multiple reports with sql script

  • May 17, 2011 at 1:53 pm

    #236336

    I'm looking for a SQL script that will delete a user (that no longer works here) from the 600 reports I have without having to delete from the report menu.

    I think I have something that's close...

    delete C

    --Catalog.Path, Catalog.Name, Users.UserName

    FROM

    Catalog C INNER JOIN

    PolicyUserRole P

    ON C.PolicyID = P.PolicyID INNER JOIN

    Users U

    ON P.UserID = U.UserID

    where U.username = 'pbgops\aamoros'

    AND C.NAME = 'Management'

  • May 18, 2011 at 7:09 am

    #1326415

    Are you trying to delete them from subscriptions, or just delete the user?

  • May 18, 2011 at 11:06 am

    #1326659

    just trying to delete the user

  • May 18, 2011 at 12:13 pm

    #1326699

    Personally I would not delete anything from the Catalog table. That is where your report definitions live and you may end up damaging your reports.

    Microsoft does not support any direct queries against (even SELECT queries) the Reporting Services database.

  • May 18, 2011 at 2:18 pm

    #1326775

    thanks guys...

    I'll just delete them manually

Viewing 5 posts - 1 through 4 (of 4 total)

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