Skip to content

Instantly share code, notes, and snippets.

@taddison

taddison/moveSSRSReportOwners.ps1

Created January 9, 2018 16:37
Show Gist options
  • Star 0 You must be signed in to star a gist
  • Fork 0 You must be signed in to fork a gist
  • Save taddison/e9e5f6250d976fc9f1bc917ba5a3d563 to your computer and use it in GitHub Desktop.
Save taddison/e9e5f6250d976fc9f1bc917ba5a3d563 to your computer and use it in GitHub Desktop.
Download ZIP
Move SSRS owners
Raw
moveSSRSReportOwners.ps1
$leaver = "foo\tim.isleaving"
$newOwner = "foo\tim.isreplaced"
$rs2010 = New-WebServiceProxy -Uri "http://gogoreports/ReportServer/ReportService2010.asmx" -Namespace SSRS.ReportingService2010 -UseDefaultCredential ;
$allSubscriptions = $rs2010.ListSubscriptions("/")
$subsToMove = ($allSubscriptions | Where-Object { $_.Owner -like $leaver })
$subsToMove | Select-Object Path, Owner, Report | Format-Table
$subsToMove | ForEach-Object { $rs2010.ChangeSubscriptionOwner($_.SubscriptionID, $newOwner) }
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment