Microsoft SQL - Windows
Log In or Register to download the BES file, and more.

0 Votes

Versioning - This is the latest version.

1Microsoft SQL - Windows10/24/2016 8:43:08 PM
2Microsoft SQL - Windows10/24/2016 9:57:04 PM
3Microsoft SQL - Windows10/24/2016 10:09:26 PM
4Microsoft SQL - Windows10/25/2016 3:52:31 PM

Description

Provides information about the SQL Server and Databases on the system.

For general information or to report issues with C3 Inventory content please visit GitHub here: https://github.com/strawgate/C3-Inventory


Property Details

ID2998470
TitleMicrosoft SQL - Windows
DomainBESC
Added by on 10/25/2016 3:52:31 PM
Last Modified by on 10/25/2016 3:52:31 PM
Counters 2505 Views / 88 Downloads
User Rating 1 star 2 star 3 star 4 star 5 star * Average over 1 rating. ** Log In or Register to add your rating.

Properties

SQL - Instances - Windows
Period 1 day
 
  * Results in a true/false
Show indented relevance
unique values of (it as string) of values of keys "HKEY_LOCAL_MACHINE\Software\Microsoft\Microsoft SQL Server\Instance Names\SQL" of (x32 registries;x64 registries)
SQL - Clustered Instances - Windows
Period 1 day
 
  * Results in a true/false
Show indented relevance
unique values of (it as string) of (string values of properties "ServiceName" of it) of SELECT OBJECTS "* FROM SqlServiceAdvancedProperty WHERE PropertyIndex=3 AND PropertyName='CLUSTERED' AND ServiceName='MSSQLSERVER' AND SqlServiceType=1 and PropertyNumValue=1" of (wmis ("ROOT\Microsoft\SqlServer\ComputerManagement12";"ROOT\Microsoft\SqlServer\ComputerManagement11";"ROOT\Microsoft\SqlServer\ComputerManagement10";"ROOT\Microsoft\SqlServer\ComputerManagement")) whose (exists select objects "* FROM SqlServiceAdvancedProperty WHERE PropertyIndex=3 AND PropertyName='CLUSTERED' AND ServiceName='MSSQLSERVER' AND SqlServiceType=1" of it | false)
SQL - Databases - Windows
Period 2 days
 
  * Results in a true/false
Show indented relevance
unique values of (string value of property "name" of it) of select objects (("* from " & it & " where NAME != '_Total' and NAME != 'mssqlsystemresource'") of (string values of properties "__class" of SELECT objects "* from meta_class where __CLASS like '%25Win32_PerfFormattedData_%25SQLServerDatabases'" of wmi)) of wmi
SQL - Mirrored Databases - Windows
Period 2 days
 
  * Results in a true/false
Show indented relevance
unique values of (string value of property "name" of it) of select objects (("* from " & it & " where NAME != '_Total' and NAME != 'mssqlsystemresource'") of (string values of properties "__class" of SELECT objects "* from meta_class where __CLASS like '%25Win32_PerfFormattedData_%25SQLServerDatabaseMirroring'" of wmi)) of wmi
SQL - Replicated Databases - Windows
Period 2 days
 
  * Results in a true/false
Show indented relevance
unique values of (string value of property "name" of it) of select objects (("* from " & it & " where NAME != '_Total' and NAME != 'mssqlsystemresource'") of (string values of properties "__class" of SELECT objects "* from meta_class where __CLASS like '%25Win32_PerfFormattedData_%25SQLServerDatabaseReplica'" of wmi)) of wmi
SQL - Database Disk Usage - Windows
Period 1 day
 
  * Results in a true/false
Show indented relevance
unique values of (it as string) of (string value of property "name" of it, (integer value of property "DataFilesSizeKB" of it / 1024) as string & " MB" ) of select objects (("* from " & it & " where NAME != '_Total' and NAME != 'mssqlsystemresource'") of (string values of properties "__class" of SELECT objects "* from meta_class where __CLASS like '%25Win32_PerfFormattedData_%25SQLServerDatabases'" of wmi)) of wmi
SQL - Default Port - Windows
Period 1 day
 
  * Results in a true/false
Show indented relevance
unique values of integer values of properties "PropertyNumVal" of select objects "* from ClientNetworkProtocolProperty where PropertyName='Default Port'" of (wmis ("ROOT\Microsoft\SqlServer\ComputerManagement12";"ROOT\Microsoft\SqlServer\ComputerManagement11";"ROOT\Microsoft\SqlServer\ComputerManagement10";"ROOT\Microsoft\SqlServer\ComputerManagement")) whose (exists select objects "* from ClientNetworkProtocolProperty where PropertyName='Default Port'" of it | false)
SQL - Default Named Pipe - Windows
Period 1 day
 
  * Results in a true/false
Show indented relevance
unique values of string values of properties "PropertyStrVal" of select objects "* from ClientNetworkProtocolProperty where PropertyName='Default Pipe'" of (wmis ("ROOT\Microsoft\SqlServer\ComputerManagement12";"ROOT\Microsoft\SqlServer\ComputerManagement11";"ROOT\Microsoft\SqlServer\ComputerManagement10";"ROOT\Microsoft\SqlServer\ComputerManagement")) whose (exists select objects "* from ClientNetworkProtocolProperty where PropertyName='Default Pipe'" of it | false)

Relevance

isWindows (Relevance 1172)
Used in 1113 fixlets and 524 analyses   * Results in a true/false
Show indented relevance
windows of operating system
Used in 1 analsis   * Results in a true/false
Show indented relevance
exists wmis ("ROOT\Microsoft\SqlServer\ComputerManagement";"ROOT\Microsoft\SqlServer\ComputerManagement10";"ROOT\Microsoft\SqlServer\ComputerManagement11";"ROOT\Microsoft\SqlServer\ComputerManagement12")
Used in 1 analsis   * Results in a true/false
Show indented relevance
exists keys "HKEY_LOCAL_MACHINE\Software\Microsoft\Microsoft SQL Server\Instance Names\SQL" of (x32 registries;x64 registries)

Sharing

Social Media:
Share this page on Yammer

Comments