MDM AirWatch data provider attribute mapping
Overview
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
Matching key: SPSDeviceConfigurationGroupClassBase.GroupID
| Name | Source Column | Data Definition | Attribute | Relation Match |
|---|---|---|---|---|
| Category | SPSCommonClassBase | Category | ||
| Status | SPSCommonClassBase | State | Value | |
| Name | Name | SPSDeviceConfigurationGroupClassBase | Name | |
| Group ID | Id_Value | SPSDeviceConfigurationGroupClassBase | GroupID | |
| Activation Code | SPSDeviceConfigurationGroupClassBase | ActivationCode | ||
| Parent MDM ID | ParentLocationGroup_Id_Value | SPSDeviceConfigurationGroupClassBase | ParentMDMID | |
| Authentication | SPSDeviceConfigurationGroupClassBase | Authentication | ||
| Country | Country | SPSDeviceConfigurationGroupClassBase | Country | DisplayString |
| Last Sync Date | SPSDeviceConfigurationGroupClassBase | LastSyncDate |
Service configuration form for mobile device management enrollment
Matching key: SVCServiceProvisioningClassBaseMDMEnrollment.DeviceConfigurationGroup
| Name | Source Column | Data Definition | Attribute | Relation Match |
|---|---|---|---|---|
| Status | SPSCommonClassBase | State | Value | |
| Device Configuration Group | Id_Value | SVCServiceProvisioningClassBaseMDMEnrollment | DeviceConfigurationGroup | Production.ID |
| Authentication Type | SVCServiceProvisioningClassBaseMDMEnrollment | AuthenticationType |
Value |
Service configuration form for application Installation
Matching key: SVCServiceProvisioningClassBaseMDMInstallApplication.MDMAppId
| 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
Matching key: SVCServiceProvisioningClassBaseMDMInstallApplication.MDMAppId
| Name | Source Column | Data Definition | Attribute | Relation Match |
|---|---|---|---|---|
| Application ID | MDMAppId | SVCServiceProvisioningClassBaseMDMInstallApplication | MDMAppID | |
| Assigned Devices | DeviceId | SVCServiceProvisioningClassBaseMDMInstallApplication | AssignedDevices |
Service
Matching key: SPSArticleClassBase.ServiceForm
| 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 | UninstallationMode | 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
Matching key: SPSSupplierClassBase.Name
| Name | Source Column | Data Definition | Attribute | Relation Match |
|---|---|---|---|---|
| Name | Platform | SPSSupplierClassBase | Name | |
| Short Name | Platform | SPSSupplierClassBase | ShortName | |
| Manufacturer | SPSSupplierClassBase | IsManufacturer |
Stock Keeping Unit
Matching key: SPSStockKeepingUnitClassBase.Name
| 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)
Matching expression
Staging.MDMDeviceID = Production.RelatedSPSAssetClassMobile.MDMDeviceID OR Staging.IMEI = Production.RelatedSPSAssetClassMobile.IMEI OR Staging.SerialNumberSource = Production.RelatedSPSAssetClassBase.SerialNumber
| 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 | SPSCommonClassBase | 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
Matching key: SPSMobileConfigurationProfileClassBase.ProfileID
| 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 | SPSMobileConfigurationProfileClassBase | Model | |
| Minimum OS | OperatingSystem | SPSMobileConfigurationProfileClassBase | MinimumOS | |
| Parent MDM ID | ParentLocationGroup_Id_Value | SPSMobileConfigurationProfileClassBase | ParentMDMID | |
| Platform | Platform | SPSMobileConfigurationProfileClassBase | Platform | |
| Name | ProfileName | SPSMobileConfigurationProfileClassBase | Name | |
| Assignment Type | Type | SPSMobileConfigurationProfileClassBase | Assignment Type | DisplayString (Display String) |
| Devices | DeviceId | SPSMobileConfigurationProfileClassBase | Devices |
Fingerprint
Matching expession:
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
| 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
Matching key: SPSAssetClassMobile.MDMDeviceID
| 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
Matching key: SPSAssetClassSIMCard.PhoneNumber
| Name | Source Column | Data Definition | Attribute | Relation Match |
|---|---|---|---|---|
| Device | DeviceId_Value | SPSAssetClassSIMCard | Device | [ASQL] Production.T(SPSAssetClassMobile).MdmDeviceId |
| Phone Number | PhoneNumber | SPSAssetClassSIMCard | PhoneNumber |