July 10, 2017 at 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
July 12, 2017 at 7:09 am
tuand2001@yahoo.com - Monday, July 10, 2017 5:12 PMHi,
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
July 12, 2017 at 1:56 pm
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.
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply