In this article
SQL Server Service
SQL Server Service Attributes
| Name | Type | Description |
|---|---|---|
| Service Name | String | SQL Server instance service name e.g. MSSQLSERVER, MSSQL$SQLEXPRESS, MSSQL$ADK etc
Sample Values:
MSSQLSERVER
MSSQL$SQLEXPRESS MSSQL$BKUPEXEC MSSQLServerOLAPService |
| Service Type | String | SQL Server instance service type e.g. SQL Server, Report Server, Analysis Server, etc.
Sample Values:
SQL Server
Report Server Analysis Server |
| Display Name | String | SQL Server instance display name
Sample Values:
SQL Server (MSSQLSERVER)
Microsoft SQL Server Compact 4.0 SP1 x64 ENU Microsoft SQL Server Compact 3.5 SP2 x64 ENU |
| Binary Path | String | File path to the service binary e.g. c:\Program Files\Microsoft SQL Server\MSSQL12.SQLEXPRESS\MSSQL\Binn\sqlservr.exe
Sample Values:
“C:\Program Files\Microsoft SQL Server\MSSQL14.MSSQLSERVER\MSSQL\Binn\sqlservr.exe” -sMSSQLSERVER
|
| HostName | String | The host machine name i.e. the machine SQL Server is installed on
Sample Values:
SCH-SV003
SCH-SV012 SERVER-CIX-SCCM |
| StartMode | String | The service start mode e.g. Auto, Manual, etc.
Sample Values:
Auto
Manual Disabled |
| StartName | String | The name used when starting the SQL Server service
Sample Values:
LocalSystem
NT AUTHORITY\NETWORKSERVICE NT Service\MSSQLSERVER |
| State | String | The SQL Server service state e.g. Running, Stopped, etc.
Sample Values:
Running
Stopped |
| SQLStates | String | SQLSTATE provides detailed information about the cause of a warning or error
Sample Values:
2053
2099205 |
| Version | String | SQL Server product version
Sample Values:
12.3.6024.0
11.4.7001.0 |
| SP Level | String | The SQL Server installation service pack level |
| Clustered | Enum | Is the SQL Server instance clustered
Enum Values
|
| SQL Cluster Name | String | SQL Cluster Name |
| Install Path | String | Path to where SQL Server was installed
Sample Values:
C:\Windows\Installer\{c12a134f-4032-4425-826a-24b1ca9dff1c}\arpico
|
| Data Path | String | Path to where SQL Server datafile (mdf) are stored
Sample Values:
C:\Program Files\Microsoft SQL Server\MSSQL13.MSSQLSERVER\MSSQL
|
| Language | String | The language code the SQL Server instance uses while running e.g. 1033 (note: 1033 means English)
Sample Values:
1033
|
| File Version | String | The SQL Server file version, this can be used to identify the SQL Server build |
| RegRoot | String | Where in the registry that SQL Server instance data is stored
Sample Values:
Software\Microsoft\Microsoft SQL Server\MSSQL13.MSSQLSERVER
|
| SKU | String | SQL Server product SKU |
| SKUName (Edition) | String | SQL Server product SKUName (edition) e.g. Express, Standard, Enterprise, etc.
Sample Values:
Express
Standard Windows Internal Database |
| Instance ID | String | The SQL Server instance ID e.g. MSSQLSERVER, SQLEXPRESS, ADK, etc.
Sample Values:
LOCALDB
MSSQLSERVER SQLWID SQLEXPRESS |
| StartUp Parameters | String | Parameters passed to the SQL Server instance when it starts
Sample Values:
-dC:\Program Files\Microsoft SQL Server\MSSQL13.MSSQLSERVER\MSSQL\DATA\master.mdf;-eC:\Program Files\Microsoft SQL Server\MSSQL13.MSSQLSERVER\MSSQL\Log\ERRORLOG;-lC:\Program Files\Microsoft SQL Server\MSSQL13.MSSQLSERVER\MSSQL\DATA\mastlog.ldf
|
| Error Reporting | Enum | Specifies if errors can be reported to Microsoft to improve future SQL Server releases
Enum Values
|
| Dump Dir | String | The directory where SQL Server log files, etc. are written to
Sample Values:
C:\Program Files\Microsoft SQL Server\MSSQL13.MSSQLSERVER\MSSQL\LOG\
|
| SQM Reporting | Enum | Is Software Quality Metrics enabled for SQL Server
Enum Values
|
| IsWow64 | Enum | Indicates if the SQL Server process is running under WOW64
Enum Values
|
| Collation | String | The collation this SQL Server instance is running under e.g. SQL_Latin1_General_CP1_CI_AS
Sample Values:
Latin1_General_CI_AS
SQL_Latin1_General_CP1_CI_AS |
| Feature List | String | The list of components installed with this SQL Server instance e.g. SQL_Replication_Core_Inst=3 SQL_Engine_Core_Inst=3 SQL_DataFiles_Core_Inst=3 SQL_ENGINE_DB_CNI=3
Sample Values:
RS_Server_Adv=3 RS_Web_Interface_Adv=3 RS_Web_Interface_ANS=3 RS_Server_ANI=3 RS_Server_ANS=3
|
| ProductGUIDs | String | List of SQL Server product GUIDs
Sample Values:
C18B132E-4032-4425-826A-24B1CA9DFF0C
|
| Patch Level | String | The version number for the SQL Server patch level e.g. 13.0.1601.5
Sample Values:
11.4.7001.0
12.3.6024.0 12.3.6164.21 |
| Product ID | String | The SQL Server installation Product ID e.g. 00310-50000-00033-AB834 |
| Login Audit Level | String | The level that which SQL Server logins are logged e.g. Failed Logins i.e. only failed logins are audited
Sample Values:
Failed Logins
Successful Logins |
| Default Login | String | The SQL Server default login account e.g. guest |
| Login Mode | String | The authentication method used when logging in to SQL Server – one of two options, ‘Integrated’ or ‘Mixed Mode’
Sample Values:
Mixed Mode
Integrated |
| Source | String | SAm360 field to identify the source of the SQL Server instance data – can be a mix of WMI, Windows Registry, AddRemovePrograms or Windows Services
Sample Values:
AddRemovePrograms | Registry
AddRemovePrograms | WindowsServices | WMI | Registry AddRemovePrograms | WindowsServices | Registry |
| Major Version | String | The SQL Server majour version number e.g. 3.5, 2012, 2008 R2, etc.
Sample Values:
2014
2016 2008 R2 |
Leave A Comment