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 NameData TypeDescription
IDBIGINTIdentity column.
ExecutionDateTimeDATETIMEWhen data was last collected from each server.
InstanceIDBIGINTID of the server as defined in dbo.Servers.
AuditLevelVARCHAR(25)Audit level setting. (NULL — requires sp_configure read)
BackupDirectoryVARCHAR(2000)Default backup directory (SERVERPROPERTY).
BrowserServiceAccountVARCHAR(2000)SQL Browser service account. (NULL — WMI only)
BrowserStartModeVARCHAR(20)SQL Browser startup mode. (NULL — WMI only)
BuildClrVersionVARCHAR(50)CLR version the instance is built with.
BuildClrVersionStringVARCHAR(50)CLR version string.
BuildNumberINTSQL Server build number.
ClusterNameVARCHAR(500)Cluster or machine name.
CollationVARCHAR(50)Server-level collation name.
CollationIDBIGINTCollation ID.
ComparisonStyleBIGINTWindows comparison style for the collation.
ComputerNamePhysicalNetBIOSVARCHAR(50)Physical NetBIOS name of the node currently running the instance.
DefaultFileVARCHAR(4000)Default data file directory.
DefaultLogVARCHAR(4000)Default log file directory.
EditionVARCHAR(100)SQL Server edition (Enterprise, Standard, etc.)
EngineEditionVARCHAR(100)Database engine edition number.
ErrorLogPathVARCHAR(4000)Path to the SQL Server error log.
FilestreamLevelVARCHAR(100)FILESTREAM access level.
FilestreamShareNameVARCHAR(200)FILESTREAM share name.
HadrManagerStatusVARCHAR(50)Always On / HADR manager status.
InstallDataDirectoryVARCHAR(4000)Default data directory at install time.
InstanceNameVARCHAR(2000)Named instance name (NULL for default instance).
IsCaseSensitiveBITWhether the server collation is case-sensitive.
IsClusteredBITWhether the instance is in a failover cluster.
IsFullTextInstalledBITWhether Full-Text Search is installed.
IsHadrEnabledBITWhether Always On is enabled.
IsSingleUserBITWhether the instance is in single-user mode.
IsXTPSupportedBITWhether In-Memory OLTP (XTP) is supported.
NameVARCHAR(400)Server name (@@SERVERNAME).
NetNameVARCHAR(50)Network machine name.
OSVersionVARCHAR(50)OS version string. (NULL — WMI only)
PhysicalMemoryBIGINTPhysical RAM in MB (from sys.dm_os_sys_info).
ProcessorsSMALLINTLogical CPU count (from sys.dm_os_sys_info).
ProductVARCHAR(100)Product version string.
ProductLevelVARCHAR(50)Product level (RTM, SP1, CU5, etc.)
ResourceVersionVARCHAR(50)Resource database version.
RootDirectoryVARCHAR(4000)SQL Server root installation directory.
VersionVARCHAR(50)Full version string.
VersionMajorINTMajor version number.
VersionMinorINTMinor version number.
VersionStringVARCHAR(50)Full version string.
SQLStartTimeDATETIMEWhen SQL Server last started (from sys.dm_os_sys_info).
IsHiddenBITNULL — WMI only.
ForceEncryptionBITNULL — WMI only.
CertExpirationDateDATETIMENULL — WMI only.
CertFriendlyNameNVARCHAR(200)NULL — WMI only.
CertIssuedByNVARCHAR(200)NULL — WMI only.
CertIssuedToNVARCHAR(200)NULL — WMI only.
CertNameNVARCHAR(200)NULL — WMI only.
CertSHANVARCHAR(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.