SqlServiceAdvancedProperty, ROOT\Microsoft\SqlServer\ComputerManagement12 - Instances

Class | Methods (3) | Properties (8) | Qualifiers (3) | Instances (40) | Namespaces (2)
Samples: VB Script | C# | VB.Net | Search on:Microsoft

Instances of SqlServiceAdvancedProperty

This section contains sample wmi instances of SqlServiceAdvancedProperty class with their properties from Microsoft Windows Server 2012 R2 Datacenter Evaluation.

Instance \\W2012SDC\ROOT\Microsoft\SqlServer\ComputerManagement12:SqlServiceAdvancedProperty.PropertyIndex=0,PropertyName="SQLSTATES",ServiceName="MSSQLSERVER",SqlServiceType=1

Properties={
   'IsReadOnly' : True //Boolean, 0xFFFFFFFF
   'PropertyIndex' : 0 //Long, 0x0
   'PropertyName' : 'SQLSTATES' //String
   'PropertyNumValue' : 2099205 //Long, 0x200805
   'PropertyStrValue' : null
   'PropertyValueType' : 2 //Long, 0x2
   'ServiceName' : 'MSSQLSERVER' //String
   'SqlServiceType' : 1 //Long, 0x1
}

Instance \\W2012SDC\ROOT\Microsoft\SqlServer\ComputerManagement12:SqlServiceAdvancedProperty.PropertyIndex=1,PropertyName="VERSION",ServiceName="MSSQLSERVER",SqlServiceType=1

Properties={
   'IsReadOnly' : True //Boolean, 0xFFFFFFFF
   'PropertyIndex' : 1 //Long, 0x1
   'PropertyName' : 'VERSION' //String
   'PropertyNumValue' : null
   'PropertyStrValue' : '12.0.2000.8' //String
   'PropertyValueType' : 0 //Long, 0x0
   'ServiceName' : 'MSSQLSERVER' //String
   'SqlServiceType' : 1 //Long, 0x1
}

Instance \\W2012SDC\ROOT\Microsoft\SqlServer\ComputerManagement12:SqlServiceAdvancedProperty.PropertyIndex=2,PropertyName="SPLEVEL",ServiceName="MSSQLSERVER",SqlServiceType=1

Properties={
   'IsReadOnly' : True //Boolean, 0xFFFFFFFF
   'PropertyIndex' : 2 //Long, 0x2
   'PropertyName' : 'SPLEVEL' //String
   'PropertyNumValue' : 0 //Long, 0x0
   'PropertyStrValue' : null
   'PropertyValueType' : 2 //Long, 0x2
   'ServiceName' : 'MSSQLSERVER' //String
   'SqlServiceType' : 1 //Long, 0x1
}

Instance \\W2012SDC\ROOT\Microsoft\SqlServer\ComputerManagement12:SqlServiceAdvancedProperty.PropertyIndex=3,PropertyName="CLUSTERED",ServiceName="MSSQLSERVER",SqlServiceType=1

Properties={
   'IsReadOnly' : True //Boolean, 0xFFFFFFFF
   'PropertyIndex' : 3 //Long, 0x3
   'PropertyName' : 'CLUSTERED' //String
   'PropertyNumValue' : 0 //Long, 0x0
   'PropertyStrValue' : null
   'PropertyValueType' : 1 //Long, 0x1
   'ServiceName' : 'MSSQLSERVER' //String
   'SqlServiceType' : 1 //Long, 0x1
}

Instance \\W2012SDC\ROOT\Microsoft\SqlServer\ComputerManagement12:SqlServiceAdvancedProperty.PropertyIndex=4,PropertyName="INSTALLPATH",ServiceName="MSSQLSERVER",SqlServiceType=1

Properties={
   'IsReadOnly' : True //Boolean, 0xFFFFFFFF
   'PropertyIndex' : 4 //Long, 0x4
   'PropertyName' : 'INSTALLPATH' //String
   'PropertyNumValue' : null
   'PropertyStrValue' : 'C:\Program Files\Microsoft SQL Server\MSSQL12.MSSQLSERVER\MSSQL' //String
   'PropertyValueType' : 0 //Long, 0x0
   'ServiceName' : 'MSSQLSERVER' //String
   'SqlServiceType' : 1 //Long, 0x1
}

Instance \\W2012SDC\ROOT\Microsoft\SqlServer\ComputerManagement12:SqlServiceAdvancedProperty.PropertyIndex=5,PropertyName="DATAPATH",ServiceName="MSSQLSERVER",SqlServiceType=1

Properties={
   'IsReadOnly' : True //Boolean, 0xFFFFFFFF
   'PropertyIndex' : 5 //Long, 0x5
   'PropertyName' : 'DATAPATH' //String
   'PropertyNumValue' : null
   'PropertyStrValue' : 'C:\Program Files\Microsoft SQL Server\MSSQL12.MSSQLSERVER\MSSQL' //String
   'PropertyValueType' : 0 //Long, 0x0
   'ServiceName' : 'MSSQLSERVER' //String
   'SqlServiceType' : 1 //Long, 0x1
}

Instance \\W2012SDC\ROOT\Microsoft\SqlServer\ComputerManagement12:SqlServiceAdvancedProperty.PropertyIndex=6,PropertyName="LANGUAGE",ServiceName="MSSQLSERVER",SqlServiceType=1

Properties={
   'IsReadOnly' : True //Boolean, 0xFFFFFFFF
   'PropertyIndex' : 6 //Long, 0x6
   'PropertyName' : 'LANGUAGE' //String
   'PropertyNumValue' : 1033 //Long, 0x409
   'PropertyStrValue' : null
   'PropertyValueType' : 2 //Long, 0x2
   'ServiceName' : 'MSSQLSERVER' //String
   'SqlServiceType' : 1 //Long, 0x1
}

Instance \\W2012SDC\ROOT\Microsoft\SqlServer\ComputerManagement12:SqlServiceAdvancedProperty.PropertyIndex=7,PropertyName="FILEVERSION",ServiceName="MSSQLSERVER",SqlServiceType=1

Properties={
   'IsReadOnly' : True //Boolean, 0xFFFFFFFF
   'PropertyIndex' : 7 //Long, 0x7
   'PropertyName' : 'FILEVERSION' //String
   'PropertyNumValue' : null
   'PropertyStrValue' : '2014.120.2000.8' //String
   'PropertyValueType' : 0 //Long, 0x0
   'ServiceName' : 'MSSQLSERVER' //String
   'SqlServiceType' : 1 //Long, 0x1
}

Instance \\W2012SDC\ROOT\Microsoft\SqlServer\ComputerManagement12:SqlServiceAdvancedProperty.PropertyIndex=8,PropertyName="VSNAME",ServiceName="MSSQLSERVER",SqlServiceType=1

Properties={
   'IsReadOnly' : True //Boolean, 0xFFFFFFFF
   'PropertyIndex' : 8 //Long, 0x8
   'PropertyName' : 'VSNAME' //String
   'PropertyNumValue' : null
   'PropertyStrValue' : '' //String
   'PropertyValueType' : 0 //Long, 0x0
   'ServiceName' : 'MSSQLSERVER' //String
   'SqlServiceType' : 1 //Long, 0x1
}

Instance \\W2012SDC\ROOT\Microsoft\SqlServer\ComputerManagement12:SqlServiceAdvancedProperty.PropertyIndex=11,PropertyName="REGROOT",ServiceName="MSSQLSERVER",SqlServiceType=1

Properties={
   'IsReadOnly' : True //Boolean, 0xFFFFFFFF
   'PropertyIndex' : 11 //Long, 0xB
   'PropertyName' : 'REGROOT' //String
   'PropertyNumValue' : null
   'PropertyStrValue' : 'Software\Microsoft\Microsoft SQL Server\MSSQL12.MSSQLSERVER' //String
   'PropertyValueType' : 0 //Long, 0x0
   'ServiceName' : 'MSSQLSERVER' //String
   'SqlServiceType' : 1 //Long, 0x1
}

Instance \\W2012SDC\ROOT\Microsoft\SqlServer\ComputerManagement12:SqlServiceAdvancedProperty.PropertyIndex=9,PropertyName="SKU",ServiceName="MSSQLSERVER",SqlServiceType=1

Properties={
   'IsReadOnly' : True //Boolean, 0xFFFFFFFF
   'PropertyIndex' : 9 //Long, 0x9
   'PropertyName' : 'SKU' //String
   'PropertyNumValue' : -1592396055 //Long, 0xA115F6E9
   'PropertyStrValue' : null
   'PropertyValueType' : 2 //Long, 0x2
   'ServiceName' : 'MSSQLSERVER' //String
   'SqlServiceType' : 1 //Long, 0x1
}

Instance \\W2012SDC\ROOT\Microsoft\SqlServer\ComputerManagement12:SqlServiceAdvancedProperty.PropertyIndex=10,PropertyName="SKUNAME",ServiceName="MSSQLSERVER",SqlServiceType=1

Properties={
   'IsReadOnly' : True //Boolean, 0xFFFFFFFF
   'PropertyIndex' : 10 //Long, 0xA
   'PropertyName' : 'SKUNAME' //String
   'PropertyNumValue' : null
   'PropertyStrValue' : 'Express Edition' //String
   'PropertyValueType' : 0 //Long, 0x0
   'ServiceName' : 'MSSQLSERVER' //String
   'SqlServiceType' : 1 //Long, 0x1
}

Instance \\W2012SDC\ROOT\Microsoft\SqlServer\ComputerManagement12:SqlServiceAdvancedProperty.PropertyIndex=12,PropertyName="INSTANCEID",ServiceName="MSSQLSERVER",SqlServiceType=1

Properties={
   'IsReadOnly' : True //Boolean, 0xFFFFFFFF
   'PropertyIndex' : 12 //Long, 0xC
   'PropertyName' : 'INSTANCEID' //String
   'PropertyNumValue' : null
   'PropertyStrValue' : 'MSSQL12.MSSQLSERVER' //String
   'PropertyValueType' : 0 //Long, 0x0
   'ServiceName' : 'MSSQLSERVER' //String
   'SqlServiceType' : 1 //Long, 0x1
}

Instance \\W2012SDC\ROOT\Microsoft\SqlServer\ComputerManagement12:SqlServiceAdvancedProperty.PropertyIndex=13,PropertyName="STARTUPPARAMETERS",ServiceName="MSSQLSERVER",SqlServiceType=1

Properties={
   'IsReadOnly' : False //Boolean, 0x0
   'PropertyIndex' : 13 //Long, 0xD
   'PropertyName' : 'STARTUPPARAMETERS' //String
   'PropertyNumValue' : null
   'PropertyStrValue' : '-dC:\Program Files\Microsoft SQL Server\MSSQL12.MSSQLSERVER\MSSQL\DATA\master.mdf;-eC:\Program Files\Microsoft SQL Server\MSSQL12.MSSQLSERVER\MSSQL\Log\ERRORLOG;-lC:\Program Files\Microsoft SQL Server\MSSQL12.MSSQLSERVER\MSSQL\DATA\mastlog.ldf' //String
   'PropertyValueType' : 0 //Long, 0x0
   'ServiceName' : 'MSSQLSERVER' //String
   'SqlServiceType' : 1 //Long, 0x1
}

Instance \\W2012SDC\ROOT\Microsoft\SqlServer\ComputerManagement12:SqlServiceAdvancedProperty.PropertyIndex=14,PropertyName="ERRORREPORTING",ServiceName="MSSQLSERVER",SqlServiceType=1

Properties={
   'IsReadOnly' : False //Boolean, 0x0
   'PropertyIndex' : 14 //Long, 0xE
   'PropertyName' : 'ERRORREPORTING' //String
   'PropertyNumValue' : 0 //Long, 0x0
   'PropertyStrValue' : null
   'PropertyValueType' : 1 //Long, 0x1
   'ServiceName' : 'MSSQLSERVER' //String
   'SqlServiceType' : 1 //Long, 0x1
}

Instance \\W2012SDC\ROOT\Microsoft\SqlServer\ComputerManagement12:SqlServiceAdvancedProperty.PropertyIndex=15,PropertyName="DUMPDIR",ServiceName="MSSQLSERVER",SqlServiceType=1

Properties={
   'IsReadOnly' : False //Boolean, 0x0
   'PropertyIndex' : 15 //Long, 0xF
   'PropertyName' : 'DUMPDIR' //String
   'PropertyNumValue' : null
   'PropertyStrValue' : 'C:\Program Files\Microsoft SQL Server\MSSQL12.MSSQLSERVER\MSSQL\LOG\' //String
   'PropertyValueType' : 0 //Long, 0x0
   'ServiceName' : 'MSSQLSERVER' //String
   'SqlServiceType' : 1 //Long, 0x1
}

Instance \\W2012SDC\ROOT\Microsoft\SqlServer\ComputerManagement12:SqlServiceAdvancedProperty.PropertyIndex=16,PropertyName="SQMREPORTING",ServiceName="MSSQLSERVER",SqlServiceType=1

Properties={
   'IsReadOnly' : False //Boolean, 0x0
   'PropertyIndex' : 16 //Long, 0x10
   'PropertyName' : 'SQMREPORTING' //String
   'PropertyNumValue' : 0 //Long, 0x0
   'PropertyStrValue' : null
   'PropertyValueType' : 1 //Long, 0x1
   'ServiceName' : 'MSSQLSERVER' //String
   'SqlServiceType' : 1 //Long, 0x1
}

Instance \\W2012SDC\ROOT\Microsoft\SqlServer\ComputerManagement12:SqlServiceAdvancedProperty.PropertyIndex=17,PropertyName="ISWOW64",ServiceName="MSSQLSERVER",SqlServiceType=1

Properties={
   'IsReadOnly' : True //Boolean, 0xFFFFFFFF
   'PropertyIndex' : 17 //Long, 0x11
   'PropertyName' : 'ISWOW64' //String
   'PropertyNumValue' : 0 //Long, 0x0
   'PropertyStrValue' : null
   'PropertyValueType' : 1 //Long, 0x1
   'ServiceName' : 'MSSQLSERVER' //String
   'SqlServiceType' : 1 //Long, 0x1
}

Instance \\W2012SDC\ROOT\Microsoft\SqlServer\ComputerManagement12:SqlServiceAdvancedProperty.PropertyIndex=0,PropertyName="INSTANCEID",ServiceName="ReportServer",SqlServiceType=6

Properties={
   'IsReadOnly' : True //Boolean, 0xFFFFFFFF
   'PropertyIndex' : 0 //Long, 0x0
   'PropertyName' : 'INSTANCEID' //String
   'PropertyNumValue' : null
   'PropertyStrValue' : 'MSRS12.MSSQLSERVER' //String
   'PropertyValueType' : 0 //Long, 0x0
   'ServiceName' : 'ReportServer' //String
   'SqlServiceType' : 6 //Long, 0x6
}

Instance \\W2012SDC\ROOT\Microsoft\SqlServer\ComputerManagement12:SqlServiceAdvancedProperty.PropertyIndex=1,PropertyName="ERRORREPORTING",ServiceName="ReportServer",SqlServiceType=6

Properties={
   'IsReadOnly' : False //Boolean, 0x0
   'PropertyIndex' : 1 //Long, 0x1
   'PropertyName' : 'ERRORREPORTING' //String
   'PropertyNumValue' : 0 //Long, 0x0
   'PropertyStrValue' : null
   'PropertyValueType' : 1 //Long, 0x1
   'ServiceName' : 'ReportServer' //String
   'SqlServiceType' : 6 //Long, 0x6
}

Instance \\W2012SDC\ROOT\Microsoft\SqlServer\ComputerManagement12:SqlServiceAdvancedProperty.PropertyIndex=2,PropertyName="DUMPDIR",ServiceName="ReportServer",SqlServiceType=6

Properties={
   'IsReadOnly' : False //Boolean, 0x0
   'PropertyIndex' : 2 //Long, 0x2
   'PropertyName' : 'DUMPDIR' //String
   'PropertyNumValue' : null
   'PropertyStrValue' : 'C:\Program Files\Microsoft SQL Server\MSRS12.MSSQLSERVER\Reporting Services\LogFiles\' //String
   'PropertyValueType' : 0 //Long, 0x0
   'ServiceName' : 'ReportServer' //String
   'SqlServiceType' : 6 //Long, 0x6
}

Instance \\W2012SDC\ROOT\Microsoft\SqlServer\ComputerManagement12:SqlServiceAdvancedProperty.PropertyIndex=3,PropertyName="SQMREPORTING",ServiceName="ReportServer",SqlServiceType=6

Properties={
   'IsReadOnly' : False //Boolean, 0x0
   'PropertyIndex' : 3 //Long, 0x3
   'PropertyName' : 'SQMREPORTING' //String
   'PropertyNumValue' : 0 //Long, 0x0
   'PropertyStrValue' : null
   'PropertyValueType' : 1 //Long, 0x1
   'ServiceName' : 'ReportServer' //String
   'SqlServiceType' : 6 //Long, 0x6
}

Instance \\W2012SDC\ROOT\Microsoft\SqlServer\ComputerManagement12:SqlServiceAdvancedProperty.PropertyIndex=4,PropertyName="ISWOW64",ServiceName="ReportServer",SqlServiceType=6

Properties={
   'IsReadOnly' : True //Boolean, 0xFFFFFFFF
   'PropertyIndex' : 4 //Long, 0x4
   'PropertyName' : 'ISWOW64' //String
   'PropertyNumValue' : 0 //Long, 0x0
   'PropertyStrValue' : null
   'PropertyValueType' : 1 //Long, 0x1
   'ServiceName' : 'ReportServer' //String
   'SqlServiceType' : 6 //Long, 0x6
}

Instance \\W2012SDC\ROOT\Microsoft\SqlServer\ComputerManagement12:SqlServiceAdvancedProperty.PropertyIndex=5,PropertyName="VERSION",ServiceName="ReportServer",SqlServiceType=6

Properties={
   'IsReadOnly' : True //Boolean, 0xFFFFFFFF
   'PropertyIndex' : 5 //Long, 0x5
   'PropertyName' : 'VERSION' //String
   'PropertyNumValue' : null
   'PropertyStrValue' : '12.0.2000.8' //String
   'PropertyValueType' : 0 //Long, 0x0
   'ServiceName' : 'ReportServer' //String
   'SqlServiceType' : 6 //Long, 0x6
}

Instance \\W2012SDC\ROOT\Microsoft\SqlServer\ComputerManagement12:SqlServiceAdvancedProperty.PropertyIndex=6,PropertyName="SPLEVEL",ServiceName="ReportServer",SqlServiceType=6

Properties={
   'IsReadOnly' : True //Boolean, 0xFFFFFFFF
   'PropertyIndex' : 6 //Long, 0x6
   'PropertyName' : 'SPLEVEL' //String
   'PropertyNumValue' : 0 //Long, 0x0
   'PropertyStrValue' : null
   'PropertyValueType' : 2 //Long, 0x2
   'ServiceName' : 'ReportServer' //String
   'SqlServiceType' : 6 //Long, 0x6
}

Instance \\W2012SDC\ROOT\Microsoft\SqlServer\ComputerManagement12:SqlServiceAdvancedProperty.PropertyIndex=7,PropertyName="FILEVERSION",ServiceName="ReportServer",SqlServiceType=6

Properties={
   'IsReadOnly' : True //Boolean, 0xFFFFFFFF
   'PropertyIndex' : 7 //Long, 0x7
   'PropertyName' : 'FILEVERSION' //String
   'PropertyNumValue' : null
   'PropertyStrValue' : '12.0.2000.8' //String
   'PropertyValueType' : 0 //Long, 0x0
   'ServiceName' : 'ReportServer' //String
   'SqlServiceType' : 6 //Long, 0x6
}

Instance \\W2012SDC\ROOT\Microsoft\SqlServer\ComputerManagement12:SqlServiceAdvancedProperty.PropertyIndex=8,PropertyName="LANGUAGE",ServiceName="ReportServer",SqlServiceType=6

Properties={
   'IsReadOnly' : True //Boolean, 0xFFFFFFFF
   'PropertyIndex' : 8 //Long, 0x8
   'PropertyName' : 'LANGUAGE' //String
   'PropertyNumValue' : 1033 //Long, 0x409
   'PropertyStrValue' : null
   'PropertyValueType' : 2 //Long, 0x2
   'ServiceName' : 'ReportServer' //String
   'SqlServiceType' : 6 //Long, 0x6
}

Instance \\W2012SDC\ROOT\Microsoft\SqlServer\ComputerManagement12:SqlServiceAdvancedProperty.PropertyIndex=9,PropertyName="SKU",ServiceName="ReportServer",SqlServiceType=6

Properties={
   'IsReadOnly' : True //Boolean, 0xFFFFFFFF
   'PropertyIndex' : 9 //Long, 0x9
   'PropertyName' : 'SKU' //String
   'PropertyNumValue' : -1592396055 //Long, 0xA115F6E9
   'PropertyStrValue' : null
   'PropertyValueType' : 2 //Long, 0x2
   'ServiceName' : 'ReportServer' //String
   'SqlServiceType' : 6 //Long, 0x6
}

Instance \\W2012SDC\ROOT\Microsoft\SqlServer\ComputerManagement12:SqlServiceAdvancedProperty.PropertyIndex=10,PropertyName="SKUNAME",ServiceName="ReportServer",SqlServiceType=6

Properties={
   'IsReadOnly' : True //Boolean, 0xFFFFFFFF
   'PropertyIndex' : 10 //Long, 0xA
   'PropertyName' : 'SKUNAME' //String
   'PropertyNumValue' : null
   'PropertyStrValue' : 'Express Edition' //String
   'PropertyValueType' : 0 //Long, 0x0
   'ServiceName' : 'ReportServer' //String
   'SqlServiceType' : 6 //Long, 0x6
}

Instance \\W2012SDC\ROOT\Microsoft\SqlServer\ComputerManagement12:SqlServiceAdvancedProperty.PropertyIndex=1,PropertyName="INSTANCEID",ServiceName="SQLBrowser",SqlServiceType=7

Properties={
   'IsReadOnly' : True //Boolean, 0xFFFFFFFF
   'PropertyIndex' : 1 //Long, 0x1
   'PropertyName' : 'INSTANCEID' //String
   'PropertyNumValue' : null
   'PropertyStrValue' : 'MSSQL12.MSSQLSERVER' //String
   'PropertyValueType' : 0 //Long, 0x0
   'ServiceName' : 'SQLBrowser' //String
   'SqlServiceType' : 7 //Long, 0x7
}

Instance \\W2012SDC\ROOT\Microsoft\SqlServer\ComputerManagement12:SqlServiceAdvancedProperty.PropertyIndex=0,PropertyName="CLUSTERED",ServiceName="SQLBrowser",SqlServiceType=7

Properties={
   'IsReadOnly' : True //Boolean, 0xFFFFFFFF
   'PropertyIndex' : 0 //Long, 0x0
   'PropertyName' : 'CLUSTERED' //String
   'PropertyNumValue' : 0 //Long, 0x0
   'PropertyStrValue' : null
   'PropertyValueType' : 1 //Long, 0x1
   'ServiceName' : 'SQLBrowser' //String
   'SqlServiceType' : 7 //Long, 0x7
}

Instance \\W2012SDC\ROOT\Microsoft\SqlServer\ComputerManagement12:SqlServiceAdvancedProperty.PropertyIndex=2,PropertyName="ERRORREPORTING",ServiceName="SQLBrowser",SqlServiceType=7

Properties={
   'IsReadOnly' : False //Boolean, 0x0
   'PropertyIndex' : 2 //Long, 0x2
   'PropertyName' : 'ERRORREPORTING' //String
   'PropertyNumValue' : 0 //Long, 0x0
   'PropertyStrValue' : null
   'PropertyValueType' : 1 //Long, 0x1
   'ServiceName' : 'SQLBrowser' //String
   'SqlServiceType' : 7 //Long, 0x7
}

Instance \\W2012SDC\ROOT\Microsoft\SqlServer\ComputerManagement12:SqlServiceAdvancedProperty.PropertyIndex=3,PropertyName="DUMPDIR",ServiceName="SQLBrowser",SqlServiceType=7

Properties={
   'IsReadOnly' : False //Boolean, 0x0
   'PropertyIndex' : 3 //Long, 0x3
   'PropertyName' : 'DUMPDIR' //String
   'PropertyNumValue' : null
   'PropertyStrValue' : 'C:\Program Files\Microsoft SQL Server\MSSQL12.MSSQLSERVER\MSSQL\LOG\' //String
   'PropertyValueType' : 0 //Long, 0x0
   'ServiceName' : 'SQLBrowser' //String
   'SqlServiceType' : 7 //Long, 0x7
}

Instance \\W2012SDC\ROOT\Microsoft\SqlServer\ComputerManagement12:SqlServiceAdvancedProperty.PropertyIndex=4,PropertyName="SQMREPORTING",ServiceName="SQLBrowser",SqlServiceType=7

Properties={
   'IsReadOnly' : False //Boolean, 0x0
   'PropertyIndex' : 4 //Long, 0x4
   'PropertyName' : 'SQMREPORTING' //String
   'PropertyNumValue' : 0 //Long, 0x0
   'PropertyStrValue' : null
   'PropertyValueType' : 1 //Long, 0x1
   'ServiceName' : 'SQLBrowser' //String
   'SqlServiceType' : 7 //Long, 0x7
}

Instance \\W2012SDC\ROOT\Microsoft\SqlServer\ComputerManagement12:SqlServiceAdvancedProperty.PropertyIndex=5,PropertyName="BROWSER",ServiceName="SQLBrowser",SqlServiceType=7

Properties={
   'IsReadOnly' : False //Boolean, 0x0
   'PropertyIndex' : 5 //Long, 0x5
   'PropertyName' : 'BROWSER' //String
   'PropertyNumValue' : 1 //Long, 0x1
   'PropertyStrValue' : null
   'PropertyValueType' : 1 //Long, 0x1
   'ServiceName' : 'SQLBrowser' //String
   'SqlServiceType' : 7 //Long, 0x7
}

Instance \\W2012SDC\ROOT\Microsoft\SqlServer\ComputerManagement12:SqlServiceAdvancedProperty.PropertyIndex=6,PropertyName="ISWOW64",ServiceName="SQLBrowser",SqlServiceType=7

Properties={
   'IsReadOnly' : True //Boolean, 0xFFFFFFFF
   'PropertyIndex' : 6 //Long, 0x6
   'PropertyName' : 'ISWOW64' //String
   'PropertyNumValue' : 0 //Long, 0x0
   'PropertyStrValue' : null
   'PropertyValueType' : 1 //Long, 0x1
   'ServiceName' : 'SQLBrowser' //String
   'SqlServiceType' : 7 //Long, 0x7
}

Instance \\W2012SDC\ROOT\Microsoft\SqlServer\ComputerManagement12:SqlServiceAdvancedProperty.PropertyIndex=3,PropertyName="ERRORREPORTING",ServiceName="SQLSERVERAGENT",SqlServiceType=2

Properties={
   'IsReadOnly' : False //Boolean, 0x0
   'PropertyIndex' : 3 //Long, 0x3
   'PropertyName' : 'ERRORREPORTING' //String
   'PropertyNumValue' : 0 //Long, 0x0
   'PropertyStrValue' : null
   'PropertyValueType' : 1 //Long, 0x1
   'ServiceName' : 'SQLSERVERAGENT' //String
   'SqlServiceType' : 2 //Long, 0x2
}

Instance \\W2012SDC\ROOT\Microsoft\SqlServer\ComputerManagement12:SqlServiceAdvancedProperty.PropertyIndex=4,PropertyName="DUMPDIR",ServiceName="SQLSERVERAGENT",SqlServiceType=2

Properties={
   'IsReadOnly' : False //Boolean, 0x0
   'PropertyIndex' : 4 //Long, 0x4
   'PropertyName' : 'DUMPDIR' //String
   'PropertyNumValue' : null
   'PropertyStrValue' : 'C:\Program Files\Microsoft SQL Server\MSSQL12.MSSQLSERVER\MSSQL\LOG\' //String
   'PropertyValueType' : 0 //Long, 0x0
   'ServiceName' : 'SQLSERVERAGENT' //String
   'SqlServiceType' : 2 //Long, 0x2
}

Instance \\W2012SDC\ROOT\Microsoft\SqlServer\ComputerManagement12:SqlServiceAdvancedProperty.PropertyIndex=5,PropertyName="SQMREPORTING",ServiceName="SQLSERVERAGENT",SqlServiceType=2

Properties={
   'IsReadOnly' : False //Boolean, 0x0
   'PropertyIndex' : 5 //Long, 0x5
   'PropertyName' : 'SQMREPORTING' //String
   'PropertyNumValue' : 0 //Long, 0x0
   'PropertyStrValue' : null
   'PropertyValueType' : 1 //Long, 0x1
   'ServiceName' : 'SQLSERVERAGENT' //String
   'SqlServiceType' : 2 //Long, 0x2
}

Instance \\W2012SDC\ROOT\Microsoft\SqlServer\ComputerManagement12:SqlServiceAdvancedProperty.PropertyIndex=1,PropertyName="INSTANCEID",ServiceName="SQLSERVERAGENT",SqlServiceType=2

Properties={
   'IsReadOnly' : True //Boolean, 0xFFFFFFFF
   'PropertyIndex' : 1 //Long, 0x1
   'PropertyName' : 'INSTANCEID' //String
   'PropertyNumValue' : null
   'PropertyStrValue' : 'MSSQL12.MSSQLSERVER' //String
   'PropertyValueType' : 0 //Long, 0x0
   'ServiceName' : 'SQLSERVERAGENT' //String
   'SqlServiceType' : 2 //Long, 0x2
}
comments powered by Disqus
online utility - toplist
WUtils.com