Collects SQL Server instance-level properties for each managed server using SERVERPROPERTY() and sys.dm_os_sys_info. Written in implicit mode — a new row is only stored when the data changes from the previously collected snapshot.
| Column Name | Data Type | Description |
|---|---|---|
| ID | BIGINT | Identity column. |
| ExecutionDateTime | DATETIME | When data was last collected from each server. |
| InstanceID | BIGINT | ID of the server as defined in dbo.Servers. |
| AuditLevel | VARCHAR(25) | Audit level setting. (NULL — requires sp_configure read) |
| BackupDirectory | VARCHAR(2000) | Default backup directory (SERVERPROPERTY). |
| BrowserServiceAccount | VARCHAR(2000) | SQL Browser service account. (NULL — WMI only) |
| BrowserStartMode | VARCHAR(20) | SQL Browser startup mode. (NULL — WMI only) |
| BuildClrVersion | VARCHAR(50) | CLR version the instance is built with. |
| BuildClrVersionString | VARCHAR(50) | CLR version string. |
| BuildNumber | INT | SQL Server build number. |
| ClusterName | VARCHAR(500) | Cluster or machine name. |
| Collation | VARCHAR(50) | Server-level collation name. |
| CollationID | BIGINT | Collation ID. |
| ComparisonStyle | BIGINT | Windows comparison style for the collation. |
| ComputerNamePhysicalNetBIOS | VARCHAR(50) | Physical NetBIOS name of the node currently running the instance. |
| DefaultFile | VARCHAR(4000) | Default data file directory. |
| DefaultLog | VARCHAR(4000) | Default log file directory. |
| Edition | VARCHAR(100) | SQL Server edition (Enterprise, Standard, etc.) |
| EngineEdition | VARCHAR(100) | Database engine edition number. |
| ErrorLogPath | VARCHAR(4000) | Path to the SQL Server error log. |
| FilestreamLevel | VARCHAR(100) | FILESTREAM access level. |
| FilestreamShareName | VARCHAR(200) | FILESTREAM share name. |
| HadrManagerStatus | VARCHAR(50) | Always On / HADR manager status. |
| InstallDataDirectory | VARCHAR(4000) | Default data directory at install time. |
| InstanceName | VARCHAR(2000) | Named instance name (NULL for default instance). |
| IsCaseSensitive | BIT | Whether the server collation is case-sensitive. |
| IsClustered | BIT | Whether the instance is in a failover cluster. |
| IsFullTextInstalled | BIT | Whether Full-Text Search is installed. |
| IsHadrEnabled | BIT | Whether Always On is enabled. |
| IsSingleUser | BIT | Whether the instance is in single-user mode. |
| IsXTPSupported | BIT | Whether In-Memory OLTP (XTP) is supported. |
| Name | VARCHAR(400) | Server name (@@SERVERNAME). |
| NetName | VARCHAR(50) | Network machine name. |
| OSVersion | VARCHAR(50) | OS version string. (NULL — WMI only) |
| PhysicalMemory | BIGINT | Physical RAM in MB (from sys.dm_os_sys_info). |
| Processors | SMALLINT | Logical CPU count (from sys.dm_os_sys_info). |
| Product | VARCHAR(100) | Product version string. |
| ProductLevel | VARCHAR(50) | Product level (RTM, SP1, CU5, etc.) |
| ResourceVersion | VARCHAR(50) | Resource database version. |
| RootDirectory | VARCHAR(4000) | SQL Server root installation directory. |
| Version | VARCHAR(50) | Full version string. |
| VersionMajor | INT | Major version number. |
| VersionMinor | INT | Minor version number. |
| VersionString | VARCHAR(50) | Full version string. |
| SQLStartTime | DATETIME | When SQL Server last started (from sys.dm_os_sys_info). |
| IsHidden | BIT | NULL — WMI only. |
| ForceEncryption | BIT | NULL — WMI only. |
| CertExpirationDate | DATETIME | NULL — WMI only. |
| CertFriendlyName | NVARCHAR(200) | NULL — WMI only. |
| CertIssuedBy | NVARCHAR(200) | NULL — WMI only. |
| CertIssuedTo | NVARCHAR(200) | NULL — WMI only. |
| CertName | NVARCHAR(200) | NULL — WMI only. |
| CertSHA | NVARCHAR(1000) | NULL — WMI only. |
WMI-only columns (BrowserServiceAccount, BrowserStartMode, cert columns, IsHidden, ForceEncryption) are always NULL — these properties cannot be retrieved via T-SQL alone.