Attribute mapping of the Intune data provider
Table of Contents
Overview
This article contains a list of attributes and data definitions that are updated by the Intune data provider.
Devices
Data Source: Managed Devices (external link)
Configuration Item: Computer
Matching Key: SPSComputerClassBase.Name
| API Property/Source Value | Data Definition | Attribute | Relation Match | Comment |
|---|---|---|---|---|
| deviceName | SPSAssetClassBase | Name | ||
| userPrincipalName | SPSAssetClassBase | UserPrincipalName | ||
| model | SPSAssetClassBase | Model | ||
| manufacturer | SPSAssetClassBase | ManufacturerName | ||
| serialNumber | SPSAssetClassBase | SerialNumber | ||
| Value set in the Data Provider configuration (by default "Intune Integration") | SPSAssetClassBase | ManagementType | ||
| id | SPSComputerClassBase | IntuneID | ||
| deviceName | SPSComputerClassBase | Name | ||
| wiFiMacAddress | SPSComputerClassBase | PrimaryMACAddress | ||
| Tenant ID from the Intune tenant record | SPSComputerClassIntuneIntegration | TenantID | ||
| id | SPSComputerClassIntuneIntegration | IntuneID | ||
| azureADRegistered | SPSComputerClassIntuneIntegration | AzureADRegistered | ||
| azureADDeviceId | SPSComputerClassIntuneIntegration | AzureADDeviceID | ||
| easActivated | SPSComputerClassIntuneIntegration | EASActivated | ||
| easDeviceId | SPSComputerClassIntuneIntegration | EASDeviceID | ||
| lastSyncDateTime | SPSComputerClassIntuneIntegration | LastSyncDateTime | ||
| Current time of the import | SPSComputerClassIntuneIntegration | LastImport | ||
| See the note below on the manufacturer value | SPSComputerClassOS | Manufacturer | ||
| operatingSystem | SPSComputerClassOS | Name | ||
| osVersion | SPSComputerClassOS | Version | ||
| Value set in the Data Provider configuration | SPSCommonClassBase | OU | Production.ID | |
| Value set in the Data Provider configuration | SPSCommonClassBase | State | Value | |
| imei | SPSAssetClassMobile | IMEI | ||
| emailAddress | SPSAssetClassMobile | UserEmailAddress | ||
| physicalMemoryInBytes | SPSComputerClassBase | Memory | ||
| systemManagementBIOSVersion | SPSComputerClassBase | BIOSVersion | ||
| ethernetMacAddress | SPSComputerClassBase | PrimaryMACAddress | ||
| ipAddressV4 | SPSComputerClassBase | IPAddress | ||
| operatingSystemLanguage | SPSComputerClassOS | Languages | ||
| securityPatchLevel | SPSComputerClassOS | PatchLevel | ||
| totalStorageSpaceInBytes | SPSComputerClassBase | TotalStorageSpace | This attribute is available starting release 26.1. | |
| freeStorageSpaceInBytes | SPSComputerClassBase | FreeStorageSpace | This attribute is available starting release 26.1. | |
| deviceCategoryDisplayName | SPSAssetClassMobile | DeviceCategory | This attribute is available starting release 26.1. | |
| complianceState | SPSAssetClassMobile/SPSComputerPickupComplianceState | ComplianceState | This attribute is available starting release 26.1. Reference to a new Pickup DD SPSComputerPickupComplianceState: Unknown Error Conflict Non-compliant Compliant Managed by Config Manager In Grace Period |
|
| isEncrypted | SPSAssetClassMobile | IsEncrypted | This attribute is available starting release 26.1 | |
| operatingSystemEdition |
SPSComputerClassOS | Edition | This attribute is available starting release 26.1, and requires using the Intune Beta API. | |
|
processorArchitecture |
SPSComputerClassBase | ProcessorType | This attribute is available starting release 26.1, and requires using the Intune Beta API. |
The SerialNumber attribute is set only if the corresponding value is meaningful and in conformity with standards. All nonsensical values are ignored.
The UserEmailAddress attribute is imported only for devices whose ownership (Proprietary in ESM) is corporate.
The Intune Inventory data provider can also set principal users for the devices. For details, please refer to Automatic assignment of principal user for imported devices.
If the manufacturer value comes as null, it is calculated as follows:
if (osName.Contains("Windows"))
{
return "Microsoft Corporation";
}
if (osName.Contains("VMware"))
{
return "VMware, Inc.";
}
if (osName.Contains("SunOS") || osName.Contains("Solaris") || osName.Contains("Oracle"))
{
return "Oracle Corporation";
}
if (osName.Contains("Linux"))
{
return "The Linux Foundation";
}
if (osName.Contains("IBM"))
{
return "IBM";
}
return "N/A";
Installations
Data Source: the Intune Integration: Import Inventory Application import definition
Configuration Item: Computer (multifragment)
Matching Key: SPSInventoryClassApplication.Name AND SPSInventoryClassApplication.Version AND SPSComputerClassBase.IntuneID AND SPSInventoryClassApplication.DetectionType
| Source Value | Data Definition | Attribute | Relation Match |
|---|---|---|---|
| ApplicationName | SPSInventoryClassApplication | Name | |
| ApplicationVersion | SPSInventoryClassApplication | Version | |
| DeviceId | SPSComputerClassBase | IntuneID | |
| DetectionType | SPSInventoryClassApplication | DetectionType | Value |
| SyncDate | SPSInventoryClassApplication | LastChangeDate | |
| Value is 1 | SPSInventoryClassApplication | Installed | |
| SyncDate | SPSInventoryClassApplication | LastSyncDate |
Fingerprints
Data Source: the Intune Integration: Import Applications import definition
Configuration Item: Fingerprint
Matching Key: SPSApplicationClassBase.Name AND SPSApplicationClassBase.Version AND SPSApplicationClassBase.GlobalApp AND SPSApplicationClassBase.DetectionType
| Source Value | Data Definition | Attribute | Relation Match |
|---|---|---|---|
| ApplicationName | SPSApplicationClassBase | Name | |
| ApplicationVersion | SPSApplicationClassBase | Version | |
| Value is '_NULL_' | SPSApplicationClassBase | GlobalApp | ISNULL(Production.Name, '_NULL_') |
| DetectionType | SPSApplicationClassBase | DetectionType | Value |
| Value is 'Intune Integration' | SPSApplicationClassBase | CreatedBy |
Stock keeping units
Data Source: Managed Devices (external link)
Configuration Item: Stock Keeping Unit
Matching Key: SPSStockKeepingUnitClassBase.Manufacturer AND SPSStockKeepingUnitClassBase.Model
| API Property/Source Value | Data Definition | Attribute | Relation Match |
|---|---|---|---|
| model | SPSStockKeepingUnitClassBase | Model | |
| manufacturer | SPSStockKeepingUnitClassBase | Manufacturer | SPSStockKeepingUnitClassBase.Manufacturer is matched by SupplierClassBase.Name OR SupplierClassBase.ShortName OR T(SPSSupplierClassAlias).Alias |
| model | SPSStockKeepingUnitClassBase | Type |
For the type value, the following values from API can be parsed:
- null as Undefined,
- Server,
- DeveloperPc,
- Notebook,
- Desktop,
- VirtualMachine.