Video unavailable
SQLBits 2022
Running SSRS Web Services with PowerShell
How do you manage SSRS from PowerShell? I will introduce how to use built in PowerShell functions to execute SSRS Web Services
It is axiomatic that if you can script something in IT you can reduce your workload. But many things with SQL Server Reporting Services require one to click around an interface. But Microsoft has provided a set of Web Services calls that you can use to perform many of these tasks. But how do you use these Web Services without using a programming tool such as Visual Studio?
In this session I will demonstrate how to use built in PowerShell commandlets to connect to the SSRS Web Services endpoints, and run powerful scripts against your Web Service. I will get a list of all of the reports, data sources and other items in your report server. I will then show a more complicated example, demonstrating how to give a user access to all of the items in the report server.