22-25 April 2026
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.