Quick Post – WMI For SQL Server Reporting Services


Do you Knew that you can query SQL Server Reporting Services Configuration by WMI ?

Instance Data from  WMI  for SSRS 2008 R2

NameSpace : root\Microsoft\SqlServer\ReportServer\RS_MSSQLSERVER\v10

Class : MSReportServer_Instance

Get-WmiObject -Namespace  root\Microsoft\SqlServer\ReportServer\RS_MSSQLSERVER\v10 -Class MSReportServer_Instance

 

__GENUS                : 2

__CLASS                : MSReportServer_Instance

__SUPERCLASS           : 

__DYNASTY              : MSReportServer_Instance

__RELPATH              : MSReportServer_Instance.InstanceName="MSSQLSERVER"

__PROPERTY_COUNT       : 6

__DERIVATION           : {}

__SERVER               : VADER

__NAMESPACE            : root\Microsoft\SqlServer\ReportServer\RS_MSSQLSERVER\v10

__PATH                 : \\VADER\root\Microsoft\SqlServer\ReportServer\RS_MSSQLSERVER\v10:MSReportServer_Instance.InstanceName="MSSQLSERVER"

EditionID              : 610778273

EditionName            : ENTERPRISE EVALUATION EDITION

InstanceID             : MSRS10_50.MSSQLSERVER

InstanceName           : MSSQLSERVER

IsSharePointIntegrated : False

Version                : 10.50.1617.0

Members :

Get-WmiObject -Namespace  root\Microsoft\SqlServer\ReportServer\RS_MSSQLSERVER\v10 -Class MSReportServer_Instance | GM

   

TypeName: System.Management.ManagementObject#root\Microsoft\SqlServer\ReportServer\RS_MSSQLSERVER\v10\MSReportServer_Instance

 

Name                   MemberType   Definition                                                  

----                   ----------   ----------                                                  

GetReportServerUrls    Method       System.Management.ManagementBaseObject GetReportServerUrls()

EditionID              Property     System.UInt32 EditionID {get;set;}                          

EditionName            Property     System.String EditionName {get;set;}                        

InstanceID             Property     System.String InstanceID {get;set;}                         

InstanceName           Property     System.String InstanceName {get;set;}                       

IsSharePointIntegrated Property     System.Boolean IsSharePointIntegrated {get;set;}            

Version                Property     System.String Version {get;set;}                            

__CLASS                Property     System.String __CLASS {get;set;}                            

__DERIVATION           Property     System.String[] __DERIVATION {get;set;}                     

__DYNASTY              Property     System.String __DYNASTY {get;set;}                          

__GENUS                Property     System.Int32 __GENUS {get;set;}                             

__NAMESPACE            Property     System.String __NAMESPACE {get;set;}                        

__PATH                 Property     System.String __PATH {get;set;}                             

__PROPERTY_COUNT       Property     System.Int32 __PROPERTY_COUNT {get;set;}                    

__RELPATH              Property     System.String __RELPATH {get;set;}                          

__SERVER               Property     System.String __SERVER {get;set;}                           

__SUPERCLASS           Property     System.String __SUPERCLASS {get;set;}                       

ConvertFromDateTime    ScriptMethod System.Object ConvertFromDateTime();                        

ConvertToDateTime      ScriptMethod System.Object ConvertToDateTime();                          

 

Configuation Settings from WMI for SSRS 2008 R2

NameSpace : root\Microsoft\SqlServer\ReportServer\RS_MSSQLSERVER\v10\Admin

Class : MSReportServer_ConfigurationSetting 

Get-WmiObject -Namespace   root\Microsoft\SqlServer\ReportServer\RS_MSSQLSERVER\v10\Admin -Class MSReportServer_ConfigurationSetting 

 

__GENUS                          : 2

__CLASS                          : MSReportServer_ConfigurationSetting

__SUPERCLASS                     : 

__DYNASTY                        : MSReportServer_ConfigurationSetting

__RELPATH                        : MSReportServer_ConfigurationSetting.InstanceName="MSSQLSERVER"

__PROPERTY_COUNT                 : 29

__DERIVATION                     : {}

__SERVER                         : VADER

__NAMESPACE                      : root\Microsoft\SqlServer\ReportServer\RS_MSSQLSERVER\v10\Admin

__PATH                           : \\VADER\root\Microsoft\SqlServer\ReportServer\RS_MSSQLSERVER\v10\Admin:MSReportServer_ConfigurationSetting.InstanceName="MSSQLSERVER

                                   "

ConnectionPoolSize               : 768

DatabaseLogonAccount             : 

DatabaseLogonTimeout             : -1

DatabaseLogonType                : 2

DatabaseName                     : ReportServer

DatabaseQueryTimeout             : 120

DatabaseServerName               : VADER

ExtendedProtectionLevel          : Off

ExtendedProtectionScenario       : Proxy

InstallationID                   : {48bd6369-a7f7-4c25-96e0-a59fd92ce7d2}

InstanceName                     : MSSQLSERVER

IsInitialized                    : True

IsReportManagerEnabled           : True

IsSharePointIntegrated           : False

IsWebServiceEnabled              : True

IsWindowsServiceEnabled          : True

MachineAccountIdentity           : 

PathName                         : c:\Program Files\Microsoft SQL Server\MSRS10_50.MSSQLSERVER\Reporting Services\ReportServer\RSReportServer.config

SecureConnectionLevel            : 0

SenderEmailAddress               : 

SendUsingSMTPServer              : True

ServiceName                      : ReportServer

SMTPServer                       : 

UnattendedExecutionAccount       : 

Version                          : 10.50.1617.0

VirtualDirectoryReportManager    : Reports

VirtualDirectoryReportServer     : ReportServer

WindowsServiceIdentityActual     : NT AUTHORITY\NETWORKSERVICE

WindowsServiceIdentityConfigured : NT AUTHORITY\NETWORKSERVICE

Members :

Get-WmiObject -Namespace   root\Microsoft\SqlServer\ReportServer\RS_MSSQLSERVER\v10\Admin -Class MSReportServer_ConfigurationSetting | GM

 

 

   TypeName: System.Management.ManagementObject#root\Microsoft\SqlServer\ReportServer\RS_MSSQLSERVER\v10\Admin\MSReportServer_ConfigurationSetting

 

Name                             MemberType   Definition                                                                                                               

----                             ----------   ----------                                                                                                               

BackupEncryptionKey              Method       System.Management.ManagementBaseObject BackupEncryptionKey(System.String Password)                                       

CreateSSLCertificateBinding      Method       System.Management.ManagementBaseObject CreateSSLCertificateBinding(System.String Application, System.String Certificat...

DeleteEncryptedInformation       Method       System.Management.ManagementBaseObject DeleteEncryptedInformation()                                                      

DeleteEncryptionKey              Method       System.Management.ManagementBaseObject DeleteEncryptionKey(System.String InstallationID)                                 

GenerateDatabaseCreationScript   Method       System.Management.ManagementBaseObject GenerateDatabaseCreationScript(System.String DatabaseName, System.Int32 Lcid, S...

GenerateDatabaseRightsScript     Method       System.Management.ManagementBaseObject GenerateDatabaseRightsScript(System.String UserName, System.String DatabaseName...

GenerateDatabaseUpgradeScript    Method       System.Management.ManagementBaseObject GenerateDatabaseUpgradeScript(System.String DatabaseName, System.String ServerV...

GetAdminSiteUrl                  Method       System.Management.ManagementBaseObject GetAdminSiteUrl()                                                                 

GetDatabaseVersionDisplayName    Method       System.Management.ManagementBaseObject GetDatabaseVersionDisplayName(System.String Version)                              

InitializeReportServer           Method       System.Management.ManagementBaseObject InitializeReportServer(System.String InstallationID)                              

ListInstalledSharePointVersions  Method       System.Management.ManagementBaseObject ListInstalledSharePointVersions()                                                 

ListIPAddresses                  Method       System.Management.ManagementBaseObject ListIPAddresses()                                                                 

ListReportServersInDatabase      Method       System.Management.ManagementBaseObject ListReportServersInDatabase()                                                     

ListReservedUrls                 Method       System.Management.ManagementBaseObject ListReservedUrls()                                                                

ListSSLCertificateBindings       Method       System.Management.ManagementBaseObject ListSSLCertificateBindings(System.Int32 Lcid)                                     

ListSSLCertificates              Method       System.Management.ManagementBaseObject ListSSLCertificates()                                                             

ReencryptSecureInformation       Method       System.Management.ManagementBaseObject ReencryptSecureInformation()                                                      

RemoveSSLCertificateBindings     Method       System.Management.ManagementBaseObject RemoveSSLCertificateBindings(System.String Application, System.String Certifica...

RemoveUnattendedExecutionAccount Method       System.Management.ManagementBaseObject RemoveUnattendedExecutionAccount()                                                

RemoveURL                        Method       System.Management.ManagementBaseObject RemoveURL(System.String Application, System.String UrlString, System.Int32 Lcid)  

ReserveURL                       Method       System.Management.ManagementBaseObject ReserveURL(System.String Application, System.String UrlString, System.Int32 Lcid) 

RestoreEncryptionKey             Method       System.Management.ManagementBaseObject RestoreEncryptionKey(System.Byte[] KeyFile, System.Int32 Length, System.String ...

SetDatabaseConnection            Method       System.Management.ManagementBaseObject SetDatabaseConnection(System.String Server, System.String DatabaseName, System....

SetDatabaseLogonTimeout          Method       System.Management.ManagementBaseObject SetDatabaseLogonTimeout(System.Int32 LogonTimeout)                                

SetDatabaseQueryTimeout          Method       System.Management.ManagementBaseObject SetDatabaseQueryTimeout(System.Int32 QueryTimeout)                                

SetEmailConfiguration            Method       System.Management.ManagementBaseObject SetEmailConfiguration(System.Boolean SendUsingSmtpServer, System.String SmtpSer...

SetExtendedProtectionSettings    Method       System.Management.ManagementBaseObject SetExtendedProtectionSettings(System.String ExtendedProtectionLevel, System.Str...

SetSecureConnectionLevel         Method       System.Management.ManagementBaseObject SetSecureConnectionLevel(System.Int32 Level)                                      

SetServiceState                  Method       System.Management.ManagementBaseObject SetServiceState(System.Boolean EnableWindowsService, System.Boolean EnableWebSe...

SetUnattendedExecutionAccount    Method       System.Management.ManagementBaseObject SetUnattendedExecutionAccount(System.String UserName, System.String Password)     

SetVirtualDirectory              Method       System.Management.ManagementBaseObject SetVirtualDirectory(System.String Application, System.String VirtualDirectory, ...

SetWindowsServiceIdentity        Method       System.Management.ManagementBaseObject SetWindowsServiceIdentity(System.Boolean UseBuiltInAccount, System.String Accou...

ConnectionPoolSize               Property     System.Int32 ConnectionPoolSize {get;set;}                                                                               

DatabaseLogonAccount             Property     System.String DatabaseLogonAccount {get;set;}                                                                            

DatabaseLogonTimeout             Property     System.Int32 DatabaseLogonTimeout {get;set;}                                                                             

DatabaseLogonType                Property     System.Int32 DatabaseLogonType {get;set;}                                                                                

DatabaseName                     Property     System.String DatabaseName {get;set;}                                                                                    

DatabaseQueryTimeout             Property     System.Int32 DatabaseQueryTimeout {get;set;}                                                                             

DatabaseServerName               Property     System.String DatabaseServerName {get;set;}                                                                              

ExtendedProtectionLevel          Property     System.String ExtendedProtectionLevel {get;set;}                                                                         

ExtendedProtectionScenario       Property     System.String ExtendedProtectionScenario {get;set;}                                                                      

InstallationID                   Property     System.String InstallationID {get;set;}                                                                                  

InstanceName                     Property     System.String InstanceName {get;set;}                                                                                    

IsInitialized                    Property     System.Boolean IsInitialized {get;set;}                                                                                  

IsReportManagerEnabled           Property     System.Boolean IsReportManagerEnabled {get;set;}                                                                         

IsSharePointIntegrated           Property     System.Boolean IsSharePointIntegrated {get;set;}                                                                         

IsWebServiceEnabled              Property     System.Boolean IsWebServiceEnabled {get;set;}                                                                            

IsWindowsServiceEnabled          Property     System.Boolean IsWindowsServiceEnabled {get;set;}                                                                        

MachineAccountIdentity           Property     System.String MachineAccountIdentity {get;set;}                                                                          

PathName                         Property     System.String PathName {get;set;}                                                                                        

SecureConnectionLevel            Property     System.Int32 SecureConnectionLevel {get;set;}                                                                            

SenderEmailAddress               Property     System.String SenderEmailAddress {get;set;}                                                                              

SendUsingSMTPServer              Property     System.Boolean SendUsingSMTPServer {get;set;}                                                                            

ServiceName                      Property     System.String ServiceName {get;set;}                                                                                     

SMTPServer                       Property     System.String SMTPServer {get;set;}                                                                                      

UnattendedExecutionAccount       Property     System.String UnattendedExecutionAccount {get;set;}                                                                      

Version                          Property     System.String Version {get;set;}                                                                                         

VirtualDirectoryReportManager    Property     System.String VirtualDirectoryReportManager {get;set;}                                                                   

VirtualDirectoryReportServer     Property     System.String VirtualDirectoryReportServer {get;set;}                                                                    

WindowsServiceIdentityActual     Property     System.String WindowsServiceIdentityActual {get;set;}                                                                    

WindowsServiceIdentityConfigured Property     System.String WindowsServiceIdentityConfigured {get;set;}                                                                

__CLASS                          Property     System.String __CLASS {get;set;}                                                                                         

__DERIVATION                     Property     System.String[] __DERIVATION {get;set;}                                                                                  

__DYNASTY                        Property     System.String __DYNASTY {get;set;}                                                                                       

__GENUS                          Property     System.Int32 __GENUS {get;set;}                                                                                          

__NAMESPACE                      Property     System.String __NAMESPACE {get;set;}                                                                                     

__PATH                           Property     System.String __PATH {get;set;}                                                                                          

__PROPERTY_COUNT                 Property     System.Int32 __PROPERTY_COUNT {get;set;}                                                                                 

__RELPATH                        Property     System.String __RELPATH {get;set;}                                                                                       

__SERVER                         Property     System.String __SERVER {get;set;}                                                                                        

__SUPERCLASS                     Property     System.String __SUPERCLASS {get;set;}                                                                                    

ConvertFromDateTime              ScriptMethod System.Object ConvertFromDateTime();                                                                                     

ConvertToDateTime                ScriptMethod System.Object ConvertToDateTime();                                                                                       

 

 

As you can see, a lot of stuffs to play around…and be notified Alegre

BTW Get-Member, I just …love you !!!!!

Enjoy !!!!

#PowerShellLifeStyle

About Laerte Junior

Laerte Junior Laerte Junior is a SQL Server specialist and an active member of WW SQL Server and the Windows PowerShell community. He also is a huge Star Wars fan (yes, he has the Darth Vader´s Helmet with the voice changer). He has a passion for DC comics and living the simple life. "May The Force be with all of us"
This entry was posted in Algo que Esqueci de Categorizar. Bookmark the permalink.

1 Response to Quick Post – WMI For SQL Server Reporting Services

  1. Pingback: Backing up SSRS Encryption Key with Powershell | SQL Servings

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out /  Change )

Google photo

You are commenting using your Google account. Log Out /  Change )

Twitter picture

You are commenting using your Twitter account. Log Out /  Change )

Facebook photo

You are commenting using your Facebook account. Log Out /  Change )

Connecting to %s