Add SSRS to the SQLServer PowerShell Provider - by Aaron Nelson

Status : 

 


31
0
Sign in
to vote
ID 3122809 Comments
Status Active Workarounds
Type Bug Repros 0
Opened 2/14/2017 4:55:48 PM
Access Restriction Public

Description

SSRS is the largest major component of SQL Server not represented in the SQLServer PowerShell Provider.  This vital component increases complexity of deployment tasks and reduces productivity of SSRS Developers.

PS SQLSERVER:\> 
Dir

Name            Root                           Description                             
----            ----                           -----------                             
DAC                 SQLSERVER:\DAC                    SQL Server Data-Tier Application Component                               
DataCollection  SQLSERVER:\DataCollection   SQL Server Data Collection              
SQLPolicy         SQLSERVER:\SQLPolicy           SQL Server Policy Management            
Utility                SQLSERVER:\Utility                 SQL Server Utility                      
SQLRegistration SQLSERVER:\SQLRegistration   SQL Server Registrations                
SQL                  SQLSERVER:\SQL                     SQL Server Database Engine              
SSIS                 SQLSERVER:\SSIS                     SQL Server Integration Services         
XEvent             SQLSERVER:\XEvent                 SQL Server Extended Events              
DatabaseXEvent  SQLSERVER:\DatabaseXEvent     SQL Server Extended Events              
SQLAS              SQLSERVER:\SQLAS                 SQL Server Analysis Services            


PS SQLSERVER:\> 
Sign in to post a comment.
Posted by MatticusAu on 2/28/2017 at 8:57 PM
I wrote a PowerShell Module for managing SSRS (https://www.powershellgallery.com/packages/SqlReportingServicesPS/1.1), largely as a result of RSScripter not being maintained. Would be useful for this type of functionality to be merged into the SQLServer module, would then open up the ability to do more things like DSC resources for deployment and management.

Posted by BobDavis463 on 2/21/2017 at 1:27 PM
Ditto. Please?
Posted by DouglasKemp on 2/14/2017 at 7:05 PM
Our organization has 480 SQL instances with 2 SQL Server DBA's. A significant number of those instances also have SSRS and adding this provider to Powershell would be very helpful.