Skip to main content
Matrix42 Self-Service Help Center

MDM AirWatch data provider attribute mapping

  1. Last updated
  2. Save as PDF

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