MDM AirWatch data provider attribute mapping
- Last updated
-
-
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 |
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
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 |
SVCServiceProvisioningClassBaseMDMEnrollment |
DeviceConfigurationGroup |
Production.ID |
Authentication Type |
|
SVCServiceProvisioningClassBaseMDMEnrollment |
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 |
AssignedDevices |
|
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 |
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
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 |
|
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
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 |
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
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 |
|