I’ve covered a lot of SSRS security tasks using PowerShell over on SQL Shack where I connect directly using the New-WebServiceProxy command. For T-SQL Tuesday I wanted to do a quick comparison between my original method and the official Reporting Services module and see what else the module offers.
The first thing you’ll want to do is to get the SSRS module using the following command. (You’ll need PowerShellGet if you aren’t using PowerShell 5.0+)
Install-Module -Name ReportingServicesTools
Looking at some basic tasks like retrieving a folder’s contents or a specific item’s security (assuming you have the required access), involves a single line of code. It’s easy to use & provides tool-tips for commands. I’ve installed the module, added my ReportServer URI to a variable and I’m ready to start returning data. Read More →