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
  • Business partner
  • Stock Keeping Unit
  • Device
  • Mobile configuration profile
  • Fingerprint
  • Installed application (multifragment for computer)
  • SIM card

Device configuration group

Mapping

Staging.GroupID = Production.RelatedSPSDeviceConfigurationGroupClassBase.GroupID

Attributes

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

Service configuration form for mobile device management enrollment

Mapping

Staging.[RelatedST-SVCServiceProvisioningClassBaseMDMEnrollment].DeviceConfigurationGroup.ST_DeviceConfigurationGroup = 
Production.RelatedSVCServiceProvisioningClassBaseMDMEnrollment.DeviceConfigurationGroup

Attributes

Name Source Column Data Definition Attribute Relation Match
Status   SPSCommonClassBase State Value
Device Configuration Group Id_Value SVCServiceProvisioningClassBaseMDM​Enrollment DeviceConfiguration​Group Production.ID
Authentication Type   SVCServiceProvisioningClassBaseMDM​Enrollment AuthenticationType
 		 Value

Service Configuration Form for application Installation

Mapping

Staging.MDMAppId = Production.RelatedSVCServiceProvisioningClassBaseMDMInstallApplication.MDMAppId

Attributes

Name Source Column Data Definition Attribute Relation Match
Bundle Id BundleId SVCServiceProvisioningClassBaseMDMInstallApplication BundleId  
Application ID Id_Value SVCServiceProvisioningClassBaseMDMInstallApplication MDMAppId  
Device Configuration Group LocationGroupId SVCServiceProvisioningClassBaseMDMInstallApplication DeviceConfigurationGroup MDMID (MDM ID)
Platform Platform SVCServiceProvisioningClassBaseMDMInstallApplication 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 SVCServiceProvisioningClassBaseMDMInstallApplication MDMAppID  
Assigned Devices DeviceId SVCServiceProvisioningClassBaseMDMInstallApplication Assigned​Devices  

Service

Mapping

Staging.[RelatedST-SPSArticleClassBase].ServiceForm.ST_ServiceForm = Production.RelatedSPSArticleClassBase.ServiceForm

Attributes

Name Source Column Data Definition Attribute Relation Match
Service Form   SPSArticleClassBase ServiceForm Production.ID
Allow Multiple Allocation   SPSArticleClassBase AllowIdenticalInstances Value
Name   SPSArticleClassBase Name  
Self Service Name   SPSArticleClassBase SSPName  
Description   SPSArticleClassBase Description  
Self Service Icon Path   SPSArticleClassBase SSPIconPath  
Service Type   SPSArticleClassBase ServiceType Value
Uninstallation Mode   SPSArticleClassBase Uninstallation​Mode Value
Managed by   SPSArticleClassBase ManagedBy Value
Create multiple bookings   SPSArticleClassBase CreateMultipleBookings  
Provisioning Workflow   SPSArticleClassBase ProvisioningProcess Production.T(PLSLWorkflowComponentClassCommon). Id
Provisioning Location   SPSArticleClassBase ProvisioningLocation  
Self Service Portal Form   SPSArticleClassBase SSPFormTypeID  
Categories   SPSArticleClassBase Categories Production.ID
Self Service Description   SPSArticleClassBase SSPDescriptionHTML  
Last Sync Date   SPSArticleClassBase LastSyncDate  
Self Service Image Path   SPSArticleClassBase SSPImagePath  

Business partner

Mapping

Name = SPSSupplierClassBase.Name

Attributes

Name Source Column Data Definition Attribute Relation Match
Name Platform SPSSupplierClassBase Name  
Short Name Platform SPSSupplierClassBase ShortName  
Manufacturer   SPSSupplierClassBase IsManufacturer  

Stock Keeping Unit

Mapping

Staging.Name = Production.RelatedSPSStockKeepingUnitClassBase.Name

Attributes

Name Source Column Data Definition Attribute Relation Match
Manufacturer   SPSStockKeepingUnitClassBase Manufacturer Production.ID
Type   SPSStockKeepingUnitClassBase Type Value
Description Model SPSStockKeepingUnitClassBase Description  
Name Model SPSStockKeepingUnitClassBase Name  
Model Model SPSStockKeepingUnitClassBase Model  

Device (Computer)

Mapping

Staging.MDMDeviceID = Production.RelatedSPSAssetClassMobile.MDMDeviceID
OR
Staging.IMEI = Production.RelatedSPSAssetClassMobile.IMEI
OR
Staging.SerialNumberSource = Production.RelatedSPSAssetClassBase.SerialNumber

Attributes

Name Source Column Data Definition Attribute Relation Match
Name DeviceFriendlyName SPSAssetClassBase Name  
Is compromised CompromisedStatus SPSAssetClassBase IsCompromised  
Management Type   SPSAssetClassBase ManagementType Value (Value)
Proprietary   SPSAssetClassBase Liability Value (Value)
Device Configuration Group LocationGroupId_Id_Value SPSAssetClassBase DeviceConfigurationGroup GroupID
Model Model SPSAssetClassBase Model  
Manufacturer Platform SPSAssetClassBase ManufacturerName  
Serial Number SerialNumberSource SPSAssetClassBase SerialNumber  
SKU   SPSAssetClassBase SKU Production.ID
MDM ID Id_Value SPSAssetClassMobile MDMDeviceID  
IMEI Imei SPSAssetClassMobile IMEI  
UUID Udid SPSAssetClassMobile UUID  
Is enrolled   SPSAssetClassMobile IsEnrolled  
Enrollment Status Changed Date   SPSAssetClassMobile EnrollmentStatusChangedDate  
Platform PlatformId_Id_Value SPSAssetClassMobile Platform Value (Value)
Last Synchronization Date   SPSAssetClassMobile LastSyncDate  
User UserName SPSAssetClassMobile UserName  
Last Seen Time LastSeenStringDate SPSAssetClassMobile LastSeen  
User Email Address UserEmailAddress SPSAssetClassMobile UserEmailAddress  
Status   SPSCommonClass​Base State Value (Value)
Name DeviceFriendlyName SPSComputerClassBase Name  
Provisioning Location   SPSComputerClassBase ProvisioningLocation  
System Serial Number SerialNumberSource SPSComputerClassBase SystemSerialNumber  
Managed By   SPSComputerClassBase ManagedBy  
Version OperatingSystem SPSComputerClassOS Version  
Name Platform SPSComputerClassOS Name  
Detection Type DeviceId SPSInventoryClassApplication DetectionType  
Installed   SPSInventoryClassApplication Installed  
Reported Application Key SPSInventoryClassApplication ReportedApplication  
Last Import Date LastSeenStringDate  SPSInventoryClassBase LastImportDate  
Last Scan Date LastSeenStringDate SPSInventoryClassBase LastScanDate  

Mobile Configuration Profile

Mapping

Staging.ProfileID = Production.RelatedSPSMobileConfigurationProfileClassBase.ProfileID

Attributes

Name Source Column Data Definition Attribute Relation Match
Last Import Date   SPSMobileConfigurationProfileClassBase LastImportDate  
Profile ID Id_Value SPSMobileConfigurationProfileClassBase ProfileID  
Managed By ManagedBy SPSMobileConfigurationProfileClassBase 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

Name = SPSApplicationClassBase.Name
AND
Production.RelatedSPSApplicationClassBase.DetectionType = 1034
AND
(Staging.Description = Production.RelatedSPSApplicationClassBase.Description OR (Staging.Description IS NULL AND 
Production.RelatedSPSApplicationClassBase.Description IS NULL))
AND
(Staging.Version = Production.RelatedSPSApplicationClassBase.Version OR (Staging.Version IS NULL AND 
Production.RelatedSPSApplicationClassBase.Version IS NULL))
AND
SPSApplicationClassBase.GlobalApp IS NULL

Attributes

Name Source Column Data Definition Attribute Relation Match
Description Identifier SPSApplicationClassBase Description  
Name Name SPSApplicationClassBase Name  
Version Version SPSApplicationClassBase Version  
Detection Type   SPSApplicationClassBase DetectionType Value
Global Application   SPSApplicationClassBase GlobalApp ISNULL(Production.Name, '')
Status   SPSCommonClassBase State Value

Installed application

Mapping

MDMDeviceID = SPSAssetClassMobile.MDMDeviceID

Attributes

Name Source Column Data Definition Attribute Relation Match
Device ID DeviceId SPSAssetClassMobile MDMDeviceID  
Installed   SPSInventoryClassApplication Installed  
Detection Type   SPSInventoryClassApplication DetectionType Value
Reported Application Key SPSInventoryClassApplication ReportedApplication Production['"' +Name + '""' +Description+ '""' +ISNULL(Version,'') + '"']
Last Change Date   SPSInventoryClassApplication LastChangeDate  

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(SPSAssetClassMobile).MdmDeviceId
Phone Number PhoneNumber SPSAssetClassSIMCard PhoneNumber