…now that I have your attention…
there aren’t any yet.
We (along with Aaron Nelson, Data Platform MVP & Chrissy LeMaire, PowerShell MVP) are working with the SQL Server product teams to recommend the first set of CmdLets that we would like to see added to the PowerShell libraries. Please help us by posting comments with your suggestions. What are the most important SSRS-related tasks that you would like to automate using PS? Give us your top five or so.
When asked to work on this recommendation, my first thought was to just duplicate the commands that are current exposed by the RE.exe utility. That might be a good starting point but this effort should be more deliberate than just copying what was evolved through the past product versions.
Hera are a few suggestions to get us started:
Add-RsDataSource
Add-RsReport
Export-RsEncryptionKey
Get-RsAuthentication
Import-RsEncryptionKey
Import-RsServerSettings
New-RsFolder
Remove-RsReport
Set-RsAuthentication
Set-RsDataSource
Set-RsReportDataSource
Maybe Export-RSReport with rendering options?
List-RSReports as a collection of reports
This is a very interesting web page and I have enjoyed reading many of the articles and posts contained on the website, keep up the good work and hope to read some more interesting content in the future.
I have developed some script which saves subscription information and restores them
Link?
So, it turns out that there has been effort underway to create a set of PoSh libraries and scripts for SSRS 2016. Take a look at this GitHub project from Parth Shah at Microsoft, and provide any feedback…
https://github.com/Microsoft/Reporting-Services
In addition to the Trello board and Slack channel that I mentioned above, I have gone ahead and filed a Connect item as a starting point:
https://connect.microsoft.com/SQLServer/feedback/details/2999931
Hi, Dean. There is a fairly comprehensive library of SSAS CmdLets. Partition processing commands are here: https://technet.microsoft.com/en-us/library/hh510164.aspx. Our current effort is limited to recommending CmdLets for Reporting Services.
It has been a bit since I looked but how about something to help with SSAS Tabular processing, especially partitions.
For anyone who would like to help us come up with ideas for these SSRS PowerShell cmdlet suggestions, in addition to comment here on Paul’s blog, you can also join on the Trello board we have setup ( http://sqlps.io/vote ) or on the SQL Community Slack channel ( http://sqlps.io/slack ).
I can’t wait to hear what y’all come up with! 🙂