Skip to main content
Matrix42 Self-Service Help Center

MDM AirWatch Data Provider Attribute Mapping

This article contains a list of attributes and data definitions that are included in mapping rules for the MDM AirWatch Data Provider import definitions. The article describes attribute mapping for the following CIs:

  • Device Configuration Group
  • Service Configuration Form for MDM Enrollment
  • Service Configuration Form for Application Installation
  • Service Configuration Form for Applications Assigned to Specific Devices
  • Service
  • Mobile Device
  • Mobile Configuration Profile
  • Fingerprint
  • SIM Card

Device Configuration Group

Mapping

Staging.MDMID = Production.RelatedSPSDeviceConfigurationGroupClassBase.MDMID

Attributes

Name Source Column Data Definition Attribute Relation Match
Category   SPSCommonClassBase Category  
Status   SPSCommonClassBase State Value (Value)
Name Name SPSDeviceConfigurationGroup
​ClassBase
Name  
MDM ID Id_Value SPSDeviceConfigurationGroup
​ClassBase
MDMID  
Activation Code   SPSDeviceConfigurationGroup
​ClassBase
ActivationCode  
Parent MDM ID ParentLocationGroup
​_Id_Value
SPSDeviceConfigurationGroup
​ClassBase
ParentMDMID  
Name Name SPSDeviceConfigurationGroup
​ClassBase
Name  
Authentication   SPSDeviceConfigurationGroup
​ClassBase
Authentication  
Activation Code   SPSDeviceConfigurationGroup
​ClassBase
Activation​Code  
Group ID   SPSDeviceConfigurationGroup
​ClassBase
Group ID  
Country Country SPSDeviceConfigurationGroup
​ClassBase
Country DisplayString (Display Value)
Last Sync Date   SPSDeviceConfigurationGroup
​ClassBase
LastSync
​Date
 

Service Configuration Form for Mobile Device Management Enrollment

Mapping

Staging.DeviceConfigurationGroup = Production.RelatedSVCServiceProvisioningClassBaseMDMEnrollment.DeviceConfigurationGroup

Attributes

Name Source Column Data Definition Attribute Relation Match
Status   SPSCommonClassBase Status Value (Value)
Device Configuration Group Id_Value SVCServiceProvisioningClassBaseMDM
​Enrollment
DeviceConfiguration
​Group
Value (Value)
Authentication Type   SVCServiceProvisioningClassBaseMDM
​Enrollment
AuthenticationType
 
[ASQL] Production.T(SPSDeviceConfigurationGroupClassBase).MDMID

Service Configuration Form for Application Installation

Mapping

Staging.MDMAppId = Production.RelatedSVCServiceProvisioningClassBaseMDMInstallApplication.MDMAppId

Attributes

Name Source Column Data Definition Attribute Relation Match
Bundle Id BundleId SVCServiceProvisioning
​ClassBaseMDMInstall
Application
BundleId  
Application ID Id_Value SVCServiceProvisioning
​ClassBaseMDMInstall
Application
MDMAppId  
Device Configuration Group LocationGroupId SVCServiceProvisioning
​ClassBaseMDMInstall
Application
Device
ConfigurationGroup
MDMID (MDM ID)
Platform Platform SVCServiceProvisioning
​ClassBaseMDMInstall
Application
Platform Value (Value)

Service Configuration Form for Applications Assigned to Specific Devices

Mapping

Staging.MDMAppId = Production.RelatedSVCServiceProvisioningClassBaseMDMInstallApplication.MDMAppId

Attributes

Name Source Column Data Definition Attribute Relation Match
Application ID MDMAppId SVCServiceProvisioningClassBaseMDM
​InstallApplication
MDMAppID  
Assigned Devices DeviceId SVCServiceProvisioningClassBaseMDM
​InstallApplication
Assigned
​Devices
 

Service

Mapping

Staging.ServiceForm = Production.RelatedSPSArticleClassBase.ServiceForm

Attributes

Name Source Column Data Definition Attribute Relation Match
Self Service Description   SPSArticleClass
Base
SSPDescription  
Service Type   SPSArticleClass
Base
ServiceType  
Service Form Id_Value SPSArticleClass
Base
ServiceForm [ASQL] Production.T(SVCService
ProvisioningClassBase
MDMEnrollment).Device
ConfigurationGroup.MDMID
Self Service Portal Form   SPSArticleClass
Base
SSPFormTypeID  
Uninstallation Mode   SPSArticleClass
Base
Uninstallation
​Mode
Value (Value)
Self Service Name   SPSArticleClass
Base
SSPName  
Self Service Icon Path   SPSArticleClass
Base
SSPIconPath  
Provisioning Workflow   SPSArticleClass
Base
Provisioning
Process

[ASQL] Production.T(PLSLWorkflowComponentClassCommon).
Id

Create multiple bookings   SPSArticleClass
Base
CreateMultiple
Bookings
 
Categories   SPSArticleClass
Base
Categories ObjectID (Object ID)
Allow Multiple Allocation   SPSArticleClass
Base
AllowIdentical
Instances
Value (Value)
Description   SPSArticleClass
Base
Description  
Provisioning Location   SPSArticleClass
Base
Provisioning
Location
 
Name   SPSArticleClass
Base
Name  
Managed by   SPSArticleClass
Base
ManagedBy Value (Value)

Mobile Device

Mapping

Staging.MDMDeviceID = Production.RelatedSPSAssetClassMobile.MDMDeviceID
OR
Staging.UUID = Production.RelatedSPSAssetClassMobile.UUID

Attributes

Name Source Column Data Definition Attribute Relation Match
Is compromised CompromisedStatus SPSAssetClassBase IsCompromised  
Name DeviceFriendlyName SPSAssetClassBase Name  
Device Configuration Group LocationGroupId_Id_Value SPSAssetClassBase DeviceConfigurationGroup MDMID (MDM ID)
Model Model SPSAssetClassBase Model  
Manufacturer Platform SPSAssetClassBase Manufacturer  
Serial Number SerialNumber SPSAssetClassBase SerialNumber  
Proprietary   SPSAssetClassBase Liability Value (Value)
Management Type   SPSAssetClassBase ManagementType Value (Value)
Principal User   SPSAssetClassBase AssignedUser [ASQL] Production.ID
Last Seen Time LastSeen SPSAssetClassMobile LastSeen  
Platform PlatformId_Id_Value SPSAssetClassMobile Platform Value (Value)
UUID Udid SPSAssetClassMobile UUID  
MDM ID Id_Value SPSAssetClassMobile MDMDeviceID  
Last Synchronization Date   SPSAssetClassMobile LastSyncDate  
IMEI Imei SPSAssetClassMobile IMEI  
Enrollment Status Changed Date   SPSAssetClassMobile EnrollmentStatus
ChangedDate
 
Is enrolled   SPSAssetClassMobile IsEnrolled  
Status   SPSCommonClass
​Base
State Value (Value)
Provisioning Location   SPSComputerClass
Base
Provisioning
Location
 
System Serial Number SerialNumber SPSComputerClass
Base
SystemSerial
Number
 
Name DeviceFriendlyName SPSComputerClass
Base
Name  
Managed By   SPSComputerClass
Base
ManagedBy  
Version OperatingSystem SPSComputerClassOS Version  
Name Platform SPSComputerClassOS Platform  
Detection Type DeviceId SPSInventoryClass
Application
DetectionType  
Installed   SPSInventoryClass
Application
Installed  
Reported Application Key SPSInventoryClass
Application
Reported
Application
 
Last Import Date LastSeen SPSInventoryClass
Base
LastImportDate  
Last Scan Date LastSeen SPSInventoryClass
Base
LastScanDate  

Mobile Configuration Profile

Mapping

Staging.ProfileID = Production.RelatedSPSMobileConfigurationProfileClassBase.ProfileID

Attributes

Name Source Column Data Definition Attribute Relation Match
Last Import Date   SPSMobileConfigurationProfile
ClassBase
LastImportDate  
Profile ID Id_Value SPSMobileConfigurationProfile
ClassBase
ProfileID  
Managed By ManagedBy SPSMobileConfigurationProfile
ClassBase
ManagedBy  
Model Model SPSMobileConfigurationProfile
​ClassBase
Model  
Minimum OS OperatingSystem SPSMobileConfigurationProfile
​ClassBase
MinimumOS  
Parent MDM ID ParentLocationGroup_Id_Value SPSMobileConfigurationProfile
​ClassBase
ParentMDMID  
Platform Platform SPSMobileConfigurationProfile
​ClassBase
Platform  
Name ProfileName SPSMobileConfigurationProfile
​ClassBase
Name  
Assignment Type Type SPSMobileConfigurationProfile
​ClassBase
Assignment Type DisplayString (Display String)
Devices DeviceId SPSMobileConfigurationProfile
​ClassBase
Devices  

Fingerprint

Mapping

Staging.Description = Production.RelatedSPSApplicationClassBase.Description
AND
Staging.Name = Production.RelatedSPSApplicationClassBase.Name AND Staging.Version = Production.RelatedSPSApplicationClassBase.Version

Attributes

Name Source Column Data Definition Attribute Relation Match
Description Identifier SPSMobileConfigurationProfileClass
Base
Description  
Name Name SPSMobileConfigurationProfileClass
​Base
Name  
Version Version SPSMobileConfigurationProfileClass
​Base
Version  

SIM Card

Mapping

Staging.PhoneNumber = Production.RelatedSPSAssetClassSIMCard.PhoneNumber

Attributes

Name Source Column Data Definition Attribute Relation Match
Device DeviceId
_Value
SPSAssetClassSIMCard Device [ASQL] Production.T(SPSAssetClass
Mobile).MdmDeviceId
Phone Number Phone
Number
SPSAssetClassSIMCard PhoneNumber