Silverback data provider attribute mapping

+ More

Table of Contents

Device Step 1. Update of matching criteria for devices and import of new devices Matching Step 2. Import of attributes for devices Attributes SIM card Matching Attributes Business partner Matching Attributes Stock Keeping Unit Matching Attributes Silverback tag service form Matching Attributes Service Matching Attributes Device tag Matching Attributes Fingerprint Matching Attributes Installed application Matching Attributes

This article contains a list of attributes and data definitions that are included in mapping rules for the Silverback data provider import definitions. The article describes attribute mapping for the following CIs:

  • Device (computer)
  • SIM card
  • Business partner
  • Stock Keeping Unit
  • Silverback tag service form
  • Service
  • Device tag
  • Fingerprint (Installed Silverback applications)
  • Installed application (multifragment for computer)

Device

Step 1. Update of matching criteria for devices and import of new devices

Matching

MDMSilverbackDeviceID = SPSAssetClassMobile.MDMSilverbackDeviceID

OR

(Staging.DeviceType LIKE '%iPhone%' OR Staging.DeviceType LIKE '%iPad%' OR Staging.DeviceType LIKE '%iPod%')
AND
UUID = SPSAssetClassMobile.UUID OR SerialNumber = SPSAssetClassBase.SerialNumber OR IMEI = SPSAssetClassMobile.IMEI

OR

Staging.DeviceType LIKE '%OSX%'
AND
UUID = SPSAssetClassMobile.UUID OR SerialNumber = SPSAssetClassBase.SerialNumber OR IMEI = SPSAssetClassMobile.IMEI

OR

(Staging.DeviceType LIKE '%Android%' OR Staging.DeviceType LIKE '%SamsungSafe%')
AND
(Staging.[RelatedST-SPSComputerClassBase].PrimaryMACAddress = Production.RelatedSPSComputerClassBase.PrimaryMACAddress 
AND Staging.[RelatedST-SPSAssetClassMobile].IMEI = Production.RelatedSPSAssetClassMobile.IMEI)
  OR
  (Staging.[RelatedST-SPSComputerClassBase].PrimaryMACAddress = Production.RelatedSPSComputerClassBase.PrimaryMACAddress
  AND Staging.[RelatedST-SPSAssetClassMobile].IMEI IS NULL AND Production.RelatedSPSAssetClassMobile.IMEI IS NULL)

OR

Staging.DeviceType LIKE '%WP%'
AND
Staging.[RelatedST-SPSComputerClassBase].PrimaryMACAddress = Production.RelatedSPSComputerClassBase.PrimaryMACAddress
  OR
  (Staging.[RelatedST-SPSAssetClassMobile].IMEI = Production.RelatedSPSAssetClassMobile.IMEI OR 
  (Staging.[RelatedST-SPSAssetClassMobile].IMEI IS NULL AND Production.RelatedSPSAssetClassMobile.IMEI IS NULL))
  OR
  SerialNumber = SPSAssetClassBase.SerialNumber

OR

Staging.DeviceType LIKE '%Windows%'
AND
SerialNumber = SPSAssetClassBase.SerialNumber

Attributes

Name Source Column Data Definition Attribute Relation Match
Name optional_deviceType + device_user_userName SPSComputerClassBase Name  
Status  Status from configuration SPSCommonClassBase State Value
Last Import Date  Date of import SPSInventoryClassBase LastImportDate  
Primary MAC Address optional_networkHwAddresses SPSComputerClassBase PrimaryMACAddress  
User device_user_userEMail SPSAssetClassMobile UserName  
Serial Number optional_deviceSerialNumber SPSAssetClassBase SerialNumber  
Device Type optional_deviceType SPSAssetClassMobile DeviceType  
UUID optional_udid SPSAssetClassMobile UUID  
IMEI optional_imei SPSAssetClassMobile IMEI  
MDM Silverback ID device_deviceIdentifier SPSAssetClassMobile MDMSilverbackDeviceID  

Step 2. Import of attributes for devices

device_deviceIdentifier = SPSAssetClassMobile.MDMSilverbackDeviceID

Attributes

Name Source Column Data Definition Attribute Relation Match
Model device_deviceHardwareTypeName SPSAssetClassBase Model  
Serial Number optional_deviceSerialNumber SPSAssetClassBase SerialNumber  
Management Type   SPSAssetClassBase ManagementType Value
Manufacturer optional_manufacturer SPSAssetClassBase ManufacturerName  
Is Compromised optional_compromisedStatus SPSAssetClassBase IsCompromised  
Name optional_deviceType + device_user_userName SPSAssetClassBase Name  
Proprietary   SPSAssetClassBase Liability Value
Last Synchronization Date   SPSAssetClassMobile LastSyncDate  
MDM Silverback ID device_deviceIdentifier SPSAssetClassMobile MDMSilverbackDeviceID  
UUID optional_udid SPSAssetClassMobile UUID  
IMEI optional_imei SPSAssetClassMobile IMEI  
Last Seen Time device_lastCheckInTime SPSAssetClassMobile LastSeen  
Is Enrolled device_enrollmentStatus SPSAssetClassMobile IsEnrolled  
Device Type optional_deviceType SPSAssetClassMobile DeviceType  
Enrollment Status Changed Date   SPSAssetClassMobile EnrollmentStatusChangedDate  
User device_user_userEMail SPSAssetClassMobile UserName  
System Serial Number optional_deviceSerialNumber SPSComputerClassBase SystemSerialNumber  
Managed By   SPSComputerClassBase ManagedBy Value: "MDM"
Provisioning Location   SPSComputerClassBase ProvisioningLocation  
Name optional_deviceType + device_user_userName SPSComputerClassBase Name  
Primary MAC Address optional_networkHwAddresses SPSComputerClassBase PrimaryMACAddress  
Version device_osVersion SPSComputerClassOS Version  
Name optional_osClass SPSComputerClassOS Name  

SIM card

Matching

PhoneNumber = SPSAssetClassSIMCard.PhoneNumber
AND
Staging.SimCardIdMatch = Production.RelatedSPSAssetClassSIMCard.SimCardId

OR

PhoneNumber = SPSAssetClassSIMCard.PhoneNumber
AND
Production.RelatedSPSAssetClassSIMCard.SimCardId IS NULL

OR

Staging.SimCardIdMatch = Production.RelatedSPSAssetClassSIMCard.SimCardId
AND
Production.RelatedSPSAssetClassSIMCard.PhoneNumber IS NULL

Attributes

Name Source Column Data Definition Attribute Relation Match
Management Type   SPSAssetClassBase ManagementType Value
Proprietary   SPSAssetClassBase Liability Value
ICCID   SPSAssetClassSIMCard SimCardId  
Device   SPSAssetClassSIMCard Device Production.ID
Phone PhoneNumber SPSAssetClassSIMCard PhoneNumber  
Status   SPSCommonClassBase State Value

Business partner

Matching

Name = SPSSupplierClassBase.Name

Attributes

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

Stock Keeping Unit

Matching

Name = SPSStockKeepingUnitClassBase.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  

Silverback tag service form

Matching

TagId = SPSSilverbackTagServiceFormClassBase.TagId
AND
(Production.RelatedSPSSilverbackTagServiceFormClassBase.ProvisioningLocation = @configurationId OR 
Production.RelatedSPSSilverbackTagServiceFormClassBase.ProvisioningLocation IS NULL)

Attributes

Name Source Column Data Definition Attribute Relation Match
Tag Id tagId SPSSilverbackTagServiceFormClassBase TagID  
Name of Device Types DeviceTypes SPSSilverbackTagServiceFormClassBase NameDeviceTypes  
Provisioning Location   SPSSilverbackTagServiceFormClassBase ProvisioningLocation  

Service

Matching

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

Attributes

Name Source Column Data Definition Attribute Relation Match
Name tagName SPSArticleClassBase Name  
Description tagDescription SPSArticleClassBase Description  
Target Type   SPSArticleClassBase TargetType Value
Self Service Name tagName SPSArticleClassBase SSPName  
Self Service Description   SPSArticleClassBase SSPDescription  
Service Type   SPSArticleClassBase ServiceType Value
Portal Description HTML   SPSArticleClassBase SSPDescriptionHTML  
Provisioning Location   SPSArticleClassBase ProvisioningLocation  
Last Sync Date   SPSArticleClassBase LastSyncDate  
Service Form   SPSArticleClassBase ServiceForm Production.ID
Categories   SPSArticleClassBase Categories Production.ID
Managed by   SPSArticleClassBase ManagedBy Value
Allow Multiple Allocation   SPSArticleClassBase AllowIdenticalInstances Value
Provisioning Workflow   SPSArticleClassBase ProvisioningProcess Production.T(PLSLWorkflowComponentClassCommon). ID

Device tag

Matching

TagId = SPSSilverbackTagServiceFormClassBase.TagId

Attributes

Name Source Column Data Definition Attribute Relation Match
Tag Id TagId SPSSilverbackTagServiceFormClassBase TagId  
Assigned Silverback Devices   SPSSilverbackTagServiceFormClassBase AssignedSilverbackDevices Production.Id

Fingerprint

Matching

Name = SPSApplicationClassBase.Name
AND
SPSApplicationClassBase.GlobalApp IS NULL
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))

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, '')

Installed application

Matching

MDMSilverbackDeviceID = SPSAssetClassMobile.MDMSilverbackDeviceID

Attributes

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

Related Articles