- Audit Level
Audit level. Possible values are none, success, failure, and all. Audits are written to the error log and to the Windows Event Viewer. - Audit Level ID
ID of the Audit Level set in registry. None = 0, Successful Logins Only = 1, Failed Logins Only = 2, Both Failed and Successful Logins = 3 - Build CLR Version
Version of the Microsoft.NET Framework common language runtime (CLR) that was used while building the instance of SQL Server. - Cluster Name
Name of the WSFC cluster that hosts the instances of SQL Server that are enabled for Always On availability groups. - Cluster Quorum State
State of the WSFC quorum (one of UNKNOWN_QUORUM_STATE, NORMAL_QUORUM, FORCED_QUORUM) - Cluster Quorum Type
Type of quorum used by this WSFC cluster (one of NODE_MAJORITY, NODE_AND_DISK_MAJORITY, NODE_AND_FILE_SHARE_MAJORITY, NO_MAJORITY:_DISK_ONLY, UNKNOWN_QUORUM, CLOUD_WITNESS. - Collation
Name of the default collation for the server. - Collation ID
ID of the SQL Server collation. - Comparison Style
Windows comparison style of the collation. - Computer Name Physical Net BIOS
NetBIOS name of the local computer on which the instance of SQL Server is currently running. For a clustered instance of SQL Server on a failover cluster, this value changes as the instance of SQL Server fails over to other nodes in the failover cluster. On a stand-alone instance of SQL Server, this value remains constant and returns the same value as the MachineName property. Note: If the instance of SQL Server is in a failover cluster and you want to obtain the name of the failover clustered instance, use the MachineName property. - Default Backup Directory
- Default Data Path
Name of the default path to the instance data files. - Default Log Path
Name of the default path to the instance log files. - Edition
Installed product edition of the instance of SQL Server. 64-bit versions of the Database Engine append (64-bit) to the version. - Edition ID
EditionID represents the installed product edition of the instance of SQL Server. - Engine Edition
Database Engine edition of the instance of SQL Server installed on the server. - Engine Edition ID
Database Engine edition ID of the instance of SQL Server installed on the server. - Error Log File Name
Active error log file. - Error Log File Path
Error log files path. - Error Log Files
- Filestream Configured Level
The configured level of FILESTREAM access. - Filestream Effective Level
The effective level of FILESTREAM access. This value can be different than the FilestreamConfiguredLevel if the level has changed and either an instance restart or a computer restart is pending. - Filestream Share Name
The name of the share used by FILESTREAM. - Full-Text Service Account
Account under which the Full-Text Search service is running. This account is authorized to control the service. This account can start or stop the service, or modify service properties. - Full-Text Service File Name
The path and filename of the Full-Text Search executable. - Full-Text Service Name
Name of the Full-Text Search service. - Full-Text Service Process Id
The process ID of the Full-Text Search service. - Full-Text Service Startup Type
The start mode of the Full-Text Search service. - Full-Text Service Status
The current status of the Full-Text Search service. - Host Distribution
Description of the operating system. - Host OS Language Version
Windows locale identifier (LCID) of the operating system. - Host Platform
The type of operating system: Windows or Linux - Host Release
Microsoft Windows operating system release (version number). - Host Service Pack Level
Service pack level of the Windows operating system. For Linux, returns an empty string. - Host Sku
Windows Stock Keeping Unit (SKU) ID. - Install ID
ID of the installation. - Instance Name
Name of the instance to which the user is connected. Returns NULL if the instance name is the default instance. - Is Advanced Analytics Installed
Returns 1 if the Advanced Analytics feature was installed during setup; 0 if Advanced Analytics was not installed. - Is Big Data Cluster
Returns 1 if the instance is SQL Server Big Data Cluster; 0 if not. - Is Case Sensitive
Returns 1 if the default instance collation is case sensitive. - Is Clustered
Server instance is configured in a failover cluster. - Is External Authentication Only
Returns whether Azure AD-only authentication is enabled. Applies to: Azure SQL Database and Azure SQL Managed Instance.