Microsoft SCCM Attribute Reference

Table of Contents

Microsoft Windows Server Attribute Reference

Microsoft SCCM Attribute Reference

This reference lists the attributes that Device Security collects from Microsoft SCCM, their names as stored in Device Security, and the Device Security fields they map to.

When Device Security integrates with Microsoft SCCM, it imports device attributes from the SCCM inventory to enrich device records. The attributes in this reference cover hardware, OS, and configuration data for SCCM-managed computers.

The third-party attribute name in Device Security refers to the attribute name as it appears in the Assets Inventory table and in Query Engine. This follows the format of third-party-name.attribute-name. When viewing the attribute name in the Assets Inventory table column selector or on a Device Details page, where the third-party name can be found as a header for the attributes section, then the third-party name is removed from the attribute name.

For example, micrsoft_defender_xdr.macAddress would appear in the Query Builder and in the Assets Inventory table, but under Device DetailsAttributesIntegration Specific AttributesMicrosoft Defender, the attribute would appear as macAddress.

Sql Query Get Device Details V1 Attributes

Device Security collects sql query get device details v1 attributes from Microsoft SCCM. The following table lists each Microsoft SCCM attribute, its name as stored in Device Security, and the Device Security field it maps to (if applicable).

* Only some attributes map to a Device Security Common Attribute.

Microsoft Intune Attribute Reference

Microsoft Windows Server Attribute Reference

Device Security Docs

Microsoft SCCM Attribute Reference

Device Security Docs

Microsoft SCCM Attribute Reference

Sql Query Get Device Details V1 Attributes

Activation & Onboarding

Next-Generation Firewalls

SASE

Microsoft SCCM Attribute	Device Security Attribute Name	Device Security Common Attribute*	Description
GS_COMPUTER_SYSTEM.Domain0	microsoft_sccm.GS_COMPUTER_SYSTEM.Domain0	AD Domain	Domain0
GS_COMPUTER_SYSTEM.UserName0	microsoft_sccm.GS_COMPUTER_SYSTEM.UserName0	AD Username	UserName0
GS_COMPUTER_SYSTEM.Name0	microsoft_sccm.GS_COMPUTER_SYSTEM.Name0	hostname	Name0
deviceid	—	id; MAC	Deviceid
ipAddress	—	IP Address	IpAddress
GS_COMPUTER_SYSTEM.Model0	microsoft_sccm.GS_COMPUTER_SYSTEM.Model0	Model	Model0
GS_OPERATING_SYSTEM.BuildNumber0	microsoft_sccm.GS_OPERATING_SYSTEM.BuildNumber0	OS Build Number	BuildNumber0
GS_OPERATING_SYSTEM.Caption0	microsoft_sccm.GS_OPERATING_SYSTEM.Caption0	OS Name	Caption0
GS_OPERATING_SYSTEM.Version0	microsoft_sccm.GS_OPERATING_SYSTEM.Version0	OS Version	Version0
windowsVersion	—	raw_os	WindowsVersion
serialNumber	—	Serial Number	SerialNumber
GS_SOFTWAREPRODUCT	microsoft_sccm.GS_SOFTWAREPRODUCT	third_party_learned_installed_software	GS SOFTWAREPRODUCT
windowsInstalledPatches	microsoft_sccm.windowsInstalledPatches	third_party_learned_os_kb_articles	WindowsInstalledPatches
GS_COMPUTER_SYSTEM.Manufacturer0	microsoft_sccm.GS_COMPUTER_SYSTEM.Manufacturer0	Vendor	Manufacturer0
CH_ClientSummary.AADDeviceID	microsoft_sccm.CH_ClientSummary.AADDeviceID	—	AADDeviceID
CH_ClientSummary.ClientActiveStatus	microsoft_sccm.CH_ClientSummary.ClientActiveStatus	—	ClientActiveStatus
CH_ClientSummary.ClientState	microsoft_sccm.CH_ClientSummary.ClientState	—	ClientState
CH_ClientSummary.ClientStateDescription	microsoft_sccm.CH_ClientSummary.ClientStateDescription	—	ClientStateDescription
CH_ClientSummary.ExpectedNextPolicyRequest	microsoft_sccm.CH_ClientSummary.ExpectedNextPolicyRequest	—	ExpectedNextPolicyRequest
CH_ClientSummary.IsActiveDDR	microsoft_sccm.CH_ClientSummary.IsActiveDDR	—	IsActiveDDR
CH_ClientSummary.IsActiveHW	microsoft_sccm.CH_ClientSummary.IsActiveHW	—	IsActiveHW
CH_ClientSummary.IsActivePolicyRequest	microsoft_sccm.CH_ClientSummary.IsActivePolicyRequest	—	IsActivePolicyRequest
CH_ClientSummary.IsActiveStatusMessages	microsoft_sccm.CH_ClientSummary.IsActiveStatusMessages	—	IsActiveStatusMessages
CH_ClientSummary.IsActiveSW	microsoft_sccm.CH_ClientSummary.IsActiveSW	—	IsActiveSW
CH_ClientSummary.LastActiveTime	microsoft_sccm.CH_ClientSummary.LastActiveTime	—	LastActiveTime
CH_ClientSummary.LastDDR	microsoft_sccm.CH_ClientSummary.LastDDR	—	LastDDR
CH_ClientSummary.LastEvaluationHealthy	microsoft_sccm.CH_ClientSummary.LastEvaluationHealthy	—	LastEvaluationHealthy
CH_ClientSummary.LastHealthEvaluation	microsoft_sccm.CH_ClientSummary.LastHealthEvaluation	—	LastHealthEvaluation
CH_ClientSummary.LastHealthEvaluationResult	microsoft_sccm.CH_ClientSummary.LastHealthEvaluationResult	—	LastHealthEvaluationResult
CH_ClientSummary.LastHW	microsoft_sccm.CH_ClientSummary.LastHW	—	LastHW
CH_ClientSummary.LastMPServerName	microsoft_sccm.CH_ClientSummary.LastMPServerName	—	LastMPServerName
CH_ClientSummary.LastOnline	microsoft_sccm.CH_ClientSummary.LastOnline	—	LastOnline
CH_ClientSummary.LastPolicyRequest	microsoft_sccm.CH_ClientSummary.LastPolicyRequest	—	LastPolicyRequest
CH_ClientSummary.LastStatusMessage	microsoft_sccm.CH_ClientSummary.LastStatusMessage	—	LastStatusMessage
CH_ClientSummary.ResourceID	microsoft_sccm.CH_ClientSummary.ResourceID	—	ResourceID
CP_Machine.AssignedSiteCode	microsoft_sccm.CP_Machine.AssignedSiteCode	—	AssignedSiteCode
CP_Machine.Description	microsoft_sccm.CP_Machine.Description	—	Description
CP_Machine.InitialRequestDate	microsoft_sccm.CP_Machine.InitialRequestDate	—	InitialRequestDate
CP_Machine.LastErrorCode	microsoft_sccm.CP_Machine.LastErrorCode	—	LastErrorCode
CP_Machine.LatestProcessingAttempt	microsoft_sccm.CP_Machine.LatestProcessingAttempt	—	LatestProcessingAttempt