Delete multiple SSRS reports from report portal using Powershell

• tuand2001@yahoo.com

  SSC Veteran

  Points: 218

  More actions

  July 10, 2017 at 5:12 pm

  #322475

  Hi,
  Is there a way to delete multiple SSRS reports using powershell. I have  a request to delete about 100 reports from different folders from report portal. All I have a report path and I hope there is a way to handle this programmingly.

  Thanks,
  Tony

• Sue_H

  SSC Guru

  Points: 90860

  More actions

  July 12, 2017 at 7:09 am

  #1950514

  tuand2001@yahoo.com - Monday, July 10, 2017 5:12 PM

  Hi,
  Is there a way to delete multiple SSRS reports using powershell. I have  a request to delete about 100 reports from different folders from report portal. All I have a report path and I hope there is a way to handle this programmingly.

  Thanks,
  Tony

  In addition to what I posted in your other thread, if you are using Microsoft's Reporting Services Tools module for Powershell, you can use their example they have posted to delete a report using Remove-RsCatalogItem. Just ignore the comments they have - it's from a different script:
  Functions/CatalogItems/Remove-RsCatalogItem.ps1

  This article has more information on the module for reporting services, examples, install, etc:
  PowerShell Commands for SQL Server Reporting Services

  Sue

• Mr. Brian Gale

  SSC-Insane

  Points: 24799

  More actions

  July 12, 2017 at 1:56 pm

  #1950633

  The other thing you can do is go into the SSRS web portal, navigate to the folder that has the reports to remove, change the view type to "list" instead of "tiles" and check off all of the ones to remove.  Then click the delete button and they will all go away.

  The above is all just my opinion on what you should do. 
  As with all advice you find on a random internet forum - you shouldn't blindly follow it.  Always test on a test server to see if there is negative side effects before making changes to live!
  I recommend you NEVER run "random code" you found online on any system you care about UNLESS you understand and can verify the code OR you don't care if the code trashes your system.