That’s right, you heard it here second. Today the SSRS team announced the availability of new SSRS commands in GitHub & the PowerShell Gallery.
Community contributions to the #PowerShell scripts for #SQLServer Reporting Services: https://t.co/VjAcWOpXnn #SSRS @SQLVariant @cl
— SQL Server BI (@SQLServerBI) November 7, 2016
To get this module just run this command in PowerShell:
Invoke-Expression (Invoke-WebRequest https://aka.ms/rstools)
After you have the module downloaded and unpacked you’ll probably want to run a command like this to find the list of SSRS commands that you will now have available at your fingertips:
Get-Command -Module ReportingServicesTools
I have been testing these commands for several weeks and so far my favorite command is Write-RsFolderContent because it will allows you to write the .RDL & .RSD files from a directory on your machine to your SSRS folder. Like the whole thing. You don’t have to throw it into a loop or anything. Try it out!
Here’s the full list of PowerShell commands for SSRS that are available today.
Backup-RsEncryptionKey
Get-RsCatalogItems
Get-RsDataSource
Get-RsItemReferences
Grant-AccessOnCatalogItem
Grant-AccessToRs
New-RsConfigurationSettingObject
New-RsDataSource
New-RsWebServiceProxy
Out-RsCatalogItem
Out-RsFolderContent
Register-PowerBI
Remove-RsCatalogItem
Restore-RSEncryptionKey
Revoke-AccessOnCatalogItem
Revoke-AccessToRs
Set-RsDataSet
Set-RsDataSource
Set-RsDataSourcePassword
Set-RsEmailSettingsAsBasicAuth
Set-RsEmailSettingsAsNoAuth
Set-RsEmailSettingsAsNTLMAuth
Set-RsSharedDataSource
Write-RsCatalogItem
Write-RsFolderContent
Give them a test and let the SSRS team know what you think!
One Response