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.
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.
Name of the default collation for the server.
ID of the SQL Server collation.
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.
Installed product edition of the instance of SQL Server. 64-bit versions of the Database Engine append (64-bit) to the version.
EditionID represents the installed product edition of the instance of SQL Server.
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.
Description of the operating system.
Host OS Language Version
Windows locale identifier (LCID) of the operating system.
The type of operating system: Windows or Linux
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.
Windows Stock Keeping Unit (SKU) ID.
ID of the installation.
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.
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.