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 |