Silverback data provider attribute mapping

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
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
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