SCCM Data Provider Attribute Mapping
Table of Contents
Overview
The SCCM Inventory Data Provider provides a way to import computer inventory data from SCCM into Matrix42 Asset Management. This article explains in detail which information is imported, what matching criteria is used for insert or update decision and how those attributes are mapped with the Asset Management data model.
Matching Keys
-
Matching key for Computer Suppliers:
SPSSupplierClassBase.ShortName(source attributeManufacturer) -
Matching key for SKU:
SPSStockKeepingUnitClassBase.Model(source attributeModel) -
Matching keys for Domains:
SPSADDomainClassBase.NT4Name,SPSADDomainClassBase.DomainName(source attributeDomainName) -
Matching key for Computer by SmsUID:
SPSInventoryClassBase.SMSGuid(source attributeSmsUID) -
Matching keys for Computers:
SPSInventoryClassBase.SMSGuid,SPSInventoryClassBase.SMSSiteCode,SPSComputerClassBase.DeviceID(source attributesSmsUID,(SiteCode),MachineID) -
Matching keys for BIOS:
SPSComputerClassBase.DeviceID,SPSInventoryClassBase.SMSSiteCode(source attributesMachineID,(SiteCode)) -
Matching keys for BIOS:
SPSComputerClassProcessor.DeviceId,SPSComputerClassBase.DeviceID,SPSInventoryClassBase.SMSSiteCode(source attributesDeviceId,MachineID,(SiteCode)) -
Matching keys for Hardware:
SPSComputerClassBase.DeviceID,SPSInventoryClassBase.SMSSiteCode(source attributesMachineID,(SiteCode)) -
Matching keys for Disks:
SPSComputerClassDiskPartition.DriveLetter,SPSComputerClassBase.DeviceID,SPSInventoryClassBase.SMSSiteCode(source attributesDriveLetter,MachineID,(SiteCode)) -
Matching keys for Video Cards:
SPSComputerClassBase.DeviceID,SPSComputerClassGraphicCard.BIOSVersion,SPSInventoryClassBase.SMSSiteCode(source attributesMachineID,RevisionID,(SiteCode)) -
Matching keys for Network Cards:
SPSComputerClassNetworkCard.MACAddress,SPSComputerClassBase.DeviceID,SPSComputerClassNetworkCard.Model,SPSInventoryClassBase.SMSSiteCode(source attributesMacadress,MachineID,Name,(SiteCode)) -
Matching keys for Sound Cards:
SPSComputerClassBase.DeviceID,SPSComputerClassSoundCard.DeviceID,SPSInventoryClassBase.SMSSiteCode(source attributesMachineID,RevisionID,(SiteCode)) -
Matching keys for Operating System:
SPSComputerClassBase.DeviceID,SPSInventoryClassBase.SMSSiteCode(source attributesMachineID,(SiteCode)) -
Matching keys for Inventory Application (Staging):
SPSStagingInventoryClassApplication.DeviceID,SPSStagingInventoryClassApplication.Name,SPSStagingInventoryClassApplication.Version(source attributesMachineID,ProductName,Version) -
Matching keys for Inventory Application:
SPSComputerClassBase.DeviceID,SPSInventoryClassApplication.Manufacturer,SPSInventoryClassApplication.Name,SPSInventoryClassApplication.Version(source attributesDeviceID,Manufacturer,Name,Version) -
Matching keys for Applications:
SPSApplicationClassBase.Manufacturer,SPSApplicationClassBase.Name, SPSApplicationClassBase.Version,SPSApplicationClassBase.GlobalApp(source attributesManufacturer,Name,Version,"_NULL_") -
Matching keys for Application Usage Data (AUT):
SPSComputerClassApplicationUsage.ApplicationName,SPSComputerClassApplicationUsage.ApplicationVersion,SPSComputerClassBase.DeviceID,SPSComputerClassApplicationUsage.UserName,SPSInventoryClassBase.SMSSiteCode(source attributesFileName,FileVersion,MachineID,UserName,(SiteCode)) -
Matching keys for User Logins:
SPSComputerClassLogon.LogonDate,SPSComputerClassBase.DeviceID,SPSComputerClassLogon.LogonAccountName,SPSInventoryClassBase.SMSSiteCode(source attributesLastLogin,MachineID,User,(SiteCode))
Attribute Mapping
| Import Job | Source Attribute/Transformation | Target Data Definition | Target Attribute | Relation Match Attribute |
|---|---|---|---|---|
| SCCM / EM: Import Computer Suppliers | Manufacturer | SPSSupplierClassBase |
Name | |
| SCCM / EM: Import Computer Suppliers | Manufacturer | SPSSupplierClassBase |
ShortName | |
| SCCM / EM: Import Computer Suppliers | Manufacturer | [Source]ManufacturerName | ||
| SCCM / EM: Import Computer Suppliers | “1” (Fixed value) | SPSSupplierClassBase |
IsManufacturer | |
| SCCM / EM: Import SKU | Manufacturer | SPSStockKeepingUnitClassBase |
Manufacturer | ShortName |
| SCCM / EM: Import SKU | Model | SPSStockKeepingUnitClassBase |
Model | |
| SCCM / EM: Import SKU | “0” (Fixed value) | SPSStockKeepingUnitClassBase |
Type | Value |
| SCCM / EM: Import SKU | “2073” (Fixed value) | SPSCommonClassBase |
State | Value |
| SCCM / EM: Import Domains | DomainName | SPSADDomainClassBase |
NT4Name | |
| SCCM / EM: Import Domains | DomainName | SPSADDomainClassBase |
DomainName | |
| SCCM / EM: Match Computer by SmsUID | MachineID | SPSComputerClassBase |
DeviceID | |
| SCCM / EM: Match Computer by SmsUID | Name | SPSComputerClassBase |
Name | |
| SCCM / EM: Match Computer by SmsUID | SmsUID | SPSInventoryClassBase |
SMSGuid | |
| SCCM / EM: Match Computer by SmsUID | (SiteCode) | SPSInventoryClassBase |
SMSSiteCode | |
| SCCM / EM: Match Computer by Name and Domain | MachineID | SPSComputerClassBase |
DeviceID | |
| SCCM / EM: Match Computer by Name and Domain | Name | SPSComputerClassBase |
Name | |
| SCCM / EM: Match Computer by Name and Domain | SmsUID | SPSComputerClassBase |
SMSGuid | |
| SCCM / EM: Match Computer by Name and Domain | UserDomain | [Source] UserDomain | ||
| SCCM / EM: Match Computer by Name and Domain | (SiteCode) | SPSInventoryClassBase |
SMSSiteCode | |
| SCCM / EM: Import Computers [Insert Only] | MachineID | SPSComputerClassBase |
DeviceID | |
| SCCM / EM: Import Computers [Insert Only] | Name | SPSComputerClassBase |
Name | |
| SCCM / EM: Import Computers [Insert Only] | SmsUID | SPSInventoryClassBase |
SMSGuid | |
| SCCM / EM: Import Computers [Insert Only] | (NewComputerState) | SPSCommonClassBase |
State | |
| SCCM / EM: Import Computers [Insert Only] | (ManageBy) | SPSComputerClassBase |
ManagedBy | |
| SCCM / EM: Import Computers [Insert Only] | (SiteCode) | SPSInventoryClassBase |
SMSSiteCode | |
| SCCM / EM: Import Computers [Insert Only] | (ManagementType) | SPSAssetClassBase |
ManagementType | |
| SCCM / EM: Import Computers [Insert Only] | (ManageBy) | SPSAssetClassBase |
ObjectCreator | |
| SCCM / EM: Import Computers [Update Only] | CreationDate | SPSInventoryClassBase |
FirstScanDate | |
| SCCM / EM: Import Computers [Update Only] | LastScanDate | SPSInventoryClassBase |
LastScanDate | |
| SCCM / EM: Import Computers [Update Only] | MachineID | SPSComputerClassBase |
DeviceID | |
| SCCM / EM: Import Computers [Update Only] | SMSBios_Guid | SPSComputerClassBase |
BIOSGuid | |
| SCCM / EM: Import Computers [Update Only] | UserDomain | SPSComputerClassBase |
WindowsDomainName | |
| SCCM / EM: Import Computers [Update Only] | (ImportDate) | SPSInventoryClassBase |
LastImportDate | |
| SCCM / EM: Import Computers [Update Only] | (SiteCode) | SPSInventoryClassBase |
SMSSiteCode | |
| SCCM / EM: Import BIOS | BiosReleaseDate | SPSComputerClassBase |
BIOSReleaseDate | |
| SCCM / EM: Import BIOS | BiosSerialNumber | SPSAssetClassBase |
SerialNumber | |
| SCCM / EM: Import BIOS | BiosSerialNumber | SPSComputerClassBase |
SystemSerialNumber | |
| SCCM / EM: Import BIOS | BiosVersion | SPSComputerClassBase |
BIOSVersion | |
| SCCM / EM: Import BIOS | Biosmanufactor | SPSComputerClassBase |
BIOSManufacturer | |
| SCCM / EM: Import BIOS | MachineID | SPSComputerClassBase |
DeviceID | |
| SCCM / EM: Import BIOS | (SiteCode) | SPSInventoryClassBase |
SMSSiteCode | |
| SCCM / EM: Import CPU | DeviceId | SPSComputerClassProcessor |
DeviceId | |
| SCCM / EM: Import CPU | IsHyperthreading | SPSComputerClassBase |
HyperthreadingActive | |
| SCCM / EM: Import CPU | MachineID | SPSComputerClassBase |
DeviceID | |
| SCCM / EM: Import CPU | Manufacturer | SPSComputerClassProcessor |
Manufacturer | |
| SCCM / EM: Import CPU | MaxSpeed | SPSComputerClassProcessor |
MaxSpeed | |
| SCCM / EM: Import CPU | Name | SPSComputerClassProcessor |
Name | |
| SCCM / EM: Import CPU | NormSpeed | SPSComputerClassProcessor |
NormSpeed | |
| SCCM / EM: Import CPU | NumberOfCores | SPSComputerClassProcessor |
AmountProcessorCores | |
| SCCM / EM: Import CPU | NumberOfLogicalProcessors | SPSComputerClassProcessor |
LogicalCPUCores | |
| SCCM / EM: Import CPU | (SiteCode) | SPSComputerClassBase |
SMSSiteCode | |
| SCCM / EM: Import Hardware | Computermanufacturer | SPSAssetClassBase |
ManufacturerName | |
| SCCM / EM: Import Hardware | Computermodel | SPSAssetClassBase |
Model | |
| SCCM / EM: Import Hardware | MachineID | SPSComputerClassBase |
DeviceID | |
| SCCM / EM: Import Hardware | MemorySize | SPSComputerClassBase |
Memory | |
| SCCM / EM: Import Hardware | (SiteCode) | SPSInventoryClassBase |
SMSSiteCode | |
| SCCM / EM: Import Disks | DriveLetter | SPSComputerClassDiskPartition |
DriveLetter | |
| SCCM / EM: Import Disks | FileSystem | SPSComputerClassDiskPartition |
PartitionType | |
| SCCM / EM: Import Disks | FreeSpace | SPSComputerClassDiskPartition |
PartitionFreeSpace | |
| SCCM / EM: Import Disks | MachineID | SPSComputerClassBase |
DeviceID | |
| SCCM / EM: Import Disks | SerialNumber | SPSComputerClassDiskPartition |
SerialNumber | |
| SCCM / EM: Import Disks | Size | SPSComputerClassDiskPartition |
PartitionSize | |
| SCCM / EM: Import Disks | (SiteCode) | SPSInventoryClassBase |
SMSSiteCode | |
| SCCM / EM: Import Video Cards | MachineID | SPSComputerClassBase |
DeviceID | |
| SCCM / EM: Import Video Cards | Name | SPSComputerClassGraphicsCard |
Model | |
| SCCM / EM: Import Video Cards | RevisionID | SPSComputerClassGraphicsCard |
BIOSVersion | |
| SCCM / EM: Import Video Cards | (SiteCode) | SPSInventoryClassBase |
SMSSiteCode | |
| SCCM / EM: Import Network Cards | DhcpEnabled | SPSComputerClassNetworkCard |
DHCPEnabled | |
| SCCM / EM: Import Network Cards | IpAddress | SPSComputerClassNetworkCard |
IPAddress | |
| SCCM / EM: Import Network Cards | IpSubnet | SPSComputerClassNetworkCard |
SubnetMask | |
| SCCM / EM: Import Network Cards | Ipv6Address | SPSComputerClassNetworkCard |
IPv6Address | |
| SCCM / EM: Import Network Cards | Macddress | SPSComputerClassNetworkCard |
MACAddress | |
| SCCM / EM: Import Network Cards | MachineID | SPSComputerClassBase |
DeviceID | |
| SCCM / EM: Import Network Cards | Manufacturer | SPSComputerClassNetworkCard |
Manufacturer | |
| SCCM / EM: Import Network Cards | Name | SPSComputerClassNetworkCard |
Model | |
| SCCM / EM: Import Network Cards | StandardGateway | SPSComputerClassNetworkCard |
DefaultGateway | |
| SCCM / EM: Import Network Cards | (SiteCode) | SPSInventoryClassBase |
SMSSiteCode | |
| SCCM / EM: Import Sound Cards | MachineID | SPSComputerClassBase |
DeviceID | |
| SCCM / EM: Import Sound Cards | Manufacturer | SPSComputerClassSoundCard |
Manufacturer | |
| SCCM / EM: Import Sound Cards | Name | SPSComputerClassSoundCard |
Model | |
| SCCM / EM: Import Sound Cards | RevisionID | SPSComputerClassSoundCard |
DeviceID | |
| SCCM / EM: Import Sound Cards | (SiteCode) | SPSInventoryClassBase |
SMSSiteCode | |
| SCCM / EM: Operating System | Caption | SPSComputerClassOS |
Name | |
| SCCM / EM: Operating System | MachineID | SPSComputerClassBase |
DeviceID | |
| SCCM / EM: Operating System | Manufacturer | SPSComputerClassOS |
Manufacturer | |
| SCCM / EM: Operating System | ServicePack | SPSComputerClassOS |
PatchLevel | |
| SCCM / EM: Operating System | Version | SPSComputerClassOS |
Version | |
| SCCM / EM: Operating System | (SiteCode) | SPSInventoryClassBase |
SMSSiteCode | |
| SCCM / EM: Import Inventory Application (Staging) | MachineID | SPSStagingInventoryClassApplication |
DeviceID | |
| SCCM / EM: Import Inventory Application (Staging) | ProductName | SPSStagingInventoryClassApplication |
Name | |
| SCCM / EM: Import Inventory Application (Staging) | Publisher | SPSStagingInventoryClassApplication |
Manufacturer | |
| SCCM / EM: Import Inventory Application (Staging) | Version | SPSStagingInventoryClassApplication |
Version | |
| SCCM / EM: Import Inventory Application (Staging) | (SyncDate) | SPSStagingInventoryClassApplication |
LastSyncDate | |
| SCCM / EM: Import Inventory Application | DeviceID | SPSComputerClassBase |
DeviceID | |
| SCCM / EM: Import Inventory Application | Manufacturer | SPSInventoryClassApplication |
Manufacturer | |
| SCCM / EM: Import Inventory Application | Name | SPSInventoryClassApplication |
Name | |
| SCCM / EM: Import Inventory Application | Version | SPSInventoryClassApplication |
Version | |
| SCCM / EM: Import Inventory Application | “1” (Fixed value) | SPSInventoryClassApplication |
Installed | |
| SCCM / EM: Import Inventory Application | (ImportDate) | SPSInventoryClassApplication |
LastSyncDate | |
| SCCM / EM: Import Applications | Manufacturer | SPSApplicationClassBase |
Manufacturer | |
| SCCM / EM: Import Applications | Name | SPSApplicationClassBase |
Name | |
| SCCM / EM: Import Applications | Version | SPSApplicationClassBase |
Version | |
| SCCM / EM: Import Applications | (DetectionType) | SPSApplicationClassBase |
DetectionType | |
| SCCM / EM: Import Applications | (CreatedBy) | SPSApplicationClassBase |
CreatedBy | |
| SCCM / EM: Import Applications | “_NULL_” (Fixed Value) | SPSApplicationClassBase |
GlobalApp | |
| SCCM / EM: Import Application Usage Data (AUT) | FileName | SPSComputerClassApplicationUsage |
ApplicationName | |
| SCCM / EM: Import Application Usage Data (AUT) | FileVersion | SPSComputerClassApplicationUsage |
ApplicationVersion | |
| SCCM / EM: Import Application Usage Data (AUT) | LastUsageDate | SPSComputerClassApplicationUsage |
LastUsageDate | |
| SCCM / EM: Import Application Usage Data (AUT) | MachineID | SPSComputerClassBase |
DeviceID | |
| SCCM / EM: Import Application Usage Data (AUT) | UserName | SPSComputerClassApplicationUsage |
UserName | |
| SCCM / EM: Import Application Usage Data (AUT) | (SiteCode) | SPSInventoryClassBase |
SMSSiteCode | |
| SCCM / EM: Import Application Usage Data (AUT) | “SCCM Data Provider” (Fixed Value) | SPSComputerClassApplicationUsage |
CreatedBy | |
| SCCM / EM: Import User Logins | LastLogin | SPSComputerClassLogon |
LogonDate | |
| SCCM / EM: Import User Logins | MachineID | SPSComputerClassBase |
DeviceID | |
| SCCM / EM: Import User Logins | User | SPSComputerClassLogon |
Logon Account Name | |
| SCCM / EM: Import User Logins | (SiteCode) | SPSInventoryClassBase |
SMSSiteCode |