$reporting = New -WebServiceProxy -uri $uri -UseDefaultCredential -namespace "ReportingWebService" (I told you the result is deceptively simple.) If you have multiple data sources then you will want to add code to handle that. With that information the script walks through the folder and adjusts the first data source on each report. I have the script hard-coded to use Windows Credentials because that is all I have tested with. It takes a target server, target folder, user name to change to and password to assign. The script below is pretty simple and could easily be turned into a function. Having to do the whole thing a second time meant a script was in order. I had done this before, manually, but I broke a few reports and it took hours to complete. Ever had to change the login information for all reports in a particular folder? In my case I was going from SQL authentication to Windows authentication for 4 folders with 15-20 reports each.
Now that I am done whining about how difficult it was, let’s talk about the script.
In fact, it actually led me to go out and download PowerGUI and start using it again just to get intellisense. The concepts are fairly simple and the resulting script is quite trivial but the lack of easy to find documentation on Reporting Services administration via scripts meant I got to spend a lot of time with my good friend intellisense. Today’s script took a long time to write.
0 kommentar(er)
