Raynet Integration Attribute Mapping
Table of Contents
Matching Keys
- Matching key for Raynet users: ASMRaynetUserClassBase.UserID (source attribute ‘import_id’)
- Matching key for Raynet Device: ASMRaynetUserClassDevice.DeviceKey (source attribute ‘device_key’)
- Matching key for AD Domain: SPSADDomainClassBase.NT4Name, SPSADDomainClassBase.DomainName (source attribute ‘DomainName’)
- Matching key for Computer: SPSComputerClassBase.PrimaryMACAddress, SPSComputerClassBase.DNSName, SPSComputerClassBase.Name, SPSAssetClassBase.RaynetDeviceKey (source attributes 'PrimaryMACAddress', ‘FQDN’, ‘Name’, ‘DeviceKey’)
- Matching key for Asset: SPSAssetClassBase.SerialNumber (source attribute 'SerialNumber')
- Matching key for Inventory Application: SPSInventoryClassApplication.Name, SPSInventoryClassApplication.Version, ASMRaynetClassDevice.DeviceKey, ASMRaynetClassInventoryApplication.Name, ASMRaynetClassInventoryApplication.Version (source attributes ‘Name’, ‘Version', ‘import_device_id’, ‘product’, ‘product_version’)
- Matching key for Applications: SPSApplicationClassBase.Name, SPSApplicationClassBase.Version (source attributes ‘Name’, ‘Version')
- Matchink key for Computers Virtualization: SPSComputerClassBase.RaynetDeviceKey (source attribute ]import_from_device_id')
Attribute Mapping
| Import Job | Source Attribute/Transformation | Target Data Definition | Target Attribute | Relation Match Attribute |
|---|---|---|---|---|
| Raynet: Import Users [Staging] | “1” (Fixed value) | ASMRaynetUserClassBase | SyncState | |
| Raynet: Import Users [Staging] | ASMRaynetUserClassBase | |||
| Raynet: Import Users [Staging] | import_id | ASMRaynetUserClassBase | UserId | |
| Raynet: Import Users [Staging] | userPrincipalName | ASMRaynetUserClassBase | UserPrincipalName | |
| Raynet: Import Computers [Staging] | “1” (Fixed value) | ASMRaynetUserClassDevice | SyncState | |
| Raynet: Import Computers [Staging] | bios | ASMRaynetUserClassDevice | BIOSVersion | |
| Raynet: Import Computers [Staging] | cpu_chip_count | ASMRaynetUserClassDevice | ProcessorCount | |
| Raynet: Import Computers [Staging] | cpu_core_count | ASMRaynetUserClassDevice | AmountProcessorCores | |
| Raynet: Import Computers [Staging] | cpu_core_count_limited | ASMRaynetUserClassDevice | LogicalCPUCores | |
| Raynet: Import Computers [Staging] | cpu_speed | ASMRaynetUserClassDevice | ProcessorClock | |
| Raynet: Import Computers [Staging] | cpu_thread_count | ASMRaynetUserClassDevice | ThreadsCount | |
| Raynet: Import Computers [Staging] | device_key | ASMRaynetUserClassDevice | DeviceKey | |
| Raynet: Import Computers [Staging] | device_manufacturer | ASMRaynetUserClassDevice | ManufacturerName | |
| Raynet: Import Computers [Staging] | device_model | ASMRaynetUserClassDevice | Model | |
| Raynet: Import Computers [Staging] | device_name | ASMRaynetUserClassDevice | Name | |
| Raynet: Import Computers [Staging] | fqdn | ASMRaynetUserClassDevice | FQDN | |
| Raynet: Import Computers [Staging] | graphics | ASMRaynetUserClassDevice | Graphics | |
| Raynet: Import Computers [Staging] | hyper_threading_act | ASMRaynetUserClassDevice | HyperthreadingActive | |
| Raynet: Import Computers [Staging] | import_cpu_type_id | ASMRaynetUserClassDevice | Processor | |
| Raynet: Import Computers [Staging] | import_domain_id | ASMRaynetUserClassDevice | DomainName | |
| Raynet: Import Computers [Staging] | import_operating_system_id | ASMRaynetUserClassDevice | OSName | |
| Raynet: Import Computers [Staging] | import_user_id | ASMRaynetUserClassDevice | UserId | |
| Raynet: Import Computers [Staging] | inventory_date | ASMRaynetUserClassDevice | LastScanDate | |
| Raynet: Import Computers [Staging] | inventory_number | ASMRaynetUserClassDevice | InventoryNumber | |
| Raynet: Import Computers [Staging] | ip_address | ASMRaynetUserClassDevice | IPAddressList | |
| Raynet: Import Computers [Staging] | mac_address | ASMRaynetUserClassDevice | MACAddressList | |
| Raynet: Import Computers [Staging] | network | ASMRaynetUserClassDevice | Network | |
| Raynet: Import Computers [Staging] | ram | ASMRaynetUserClassDevice | Memory | |
| Raynet: Import Computers [Staging] | serial_number | ASMRaynetUserClassDevice | SerialNumber | |
| Raynet: Import Computers [Staging] | source | ASMRaynetUserClassDevice | ObjectCreator | |
| Raynet: Import Computers [Staging] | storage | ASMRaynetUserClassDevice | Storage | |
| Raynet: Import Computers [Staging] | uuid | ASMRaynetUserClassDevice | UUID | |
| Raynet: Import Domains | DomainName | SPSADDomainClassBase | NT4Name | |
| Raynet: Import Domains | DomainName | SPSADDomainClassBase | DomainName | |
| Raynet: Match Computer by MAC Address | DeviceKey | SPSComputerClassBase | RaynetDeviceKey | |
| Raynet: Match Computer by MAC Address | PrimaryMACAddress | SPSComputerClassBase | PrimaryMACAddress | |
| Raynet: Match Computer by Serial Number | DeviceKey | SPSComputerClassBase | RaynetDeviceKey | |
| Raynet: Match Computer by Serial Number | SerialNumber | SPSAssetClassBase | SerialNumber | |
| Raynet: Match Computer by DNSName | DeviceKey | SPSComputerClassBase | RaynetDeviceKey | |
| Raynet: Match Computer by DNSName | FQDN | SPSComputerClassBase | DNSName | |
| Raynet: Match Computer by Name and Domain | DeviceKey | SPSComputerClassBase | RaynetDeviceKey | |
| Raynet: Match Computer by Name and Domain | DomainName | [Source] DomainName | ||
| Raynet: Match Computer by Name and Domain | Name | SPSComputerClassBase | Name | |
| Raynet: Import Computers [Insert Only] | DeviceKey | SPSComputerClassBase | RaynetDeviceKey | |
| Raynet: Import Computers [Insert Only] | Name | SPSComputerClassBase | Name | |
| Raynet: Import Computers [Insert Only] | ObjectCreator | SPSAssetClassBase | ObjectCreator | |
| Raynet: Import Computers [Insert Only] | “Raynet” (Fixed value) | SPSComputerClassBase | ManagedBy | |
| Raynet: Import Computers [Insert Only] | (ComputerState) | SPSCommonClassBase | State | Value |
| Raynet: Import Computers [Insert Only] | "10911" (Fixed Value) | SPSAssetClassBase | ManagementType | Value |
| Raynet: Import Computers [Update Only] | AmountProcessorCores | SPSComputerClassBase | AmountProcessorCores | |
| Raynet: Import Computers [Update Only] | BiosVersion | SPSComputerClassBase | BIOSVersion | |
| Raynet: Import Computers [Update Only] | DeviceKey | SPSComputerClassBase | RaynetDeviceKey | |
| Raynet: Import Computers [Update Only] | DomainNam | SPSComputerClassBase | WindowsDomainName | |
| Raynet: Import Computers [Update Only] | FQDN | SPSComputerClassBase | DNSName | |
| Raynet: Import Computers [Update Only] | HyperthreadingActive | SPSComputerClassBase | HyperthreadingActive | |
| Raynet: Import Computers [Update Only] | InventoryNumber | SPSAssetClassBase | InventoryNumber | |
| Raynet: Import Computers [Update Only] | LastScanDate | SPSInventoryClassBase | LastScanDate | |
| Raynet: Import Computers [Update Only] | LogicalCPUCores | SPSComputerClassBase | LogicalCPUCores | |
| Raynet: Import Computers [Update Only] | ManufacturerName | SPSAssetClassBase | ManufacturerName | |
| Raynet: Import Computers [Update Only] | Memory | SPSComputerClassBase | Memory | |
| Raynet: Import Computers [Update Only] | Model | SPSAssetClassBase | Model | |
| Raynet: Import Computers [Update Only] | OSName | SPSComputerClassOS | Name | |
| Raynet: Import Computers [Update Only] | ObjectCreator | SPSAssetClassBase | ObjectCreator | |
| Raynet: Import Computers [Update Only] | PrimaryIPAddress | SPSComputerClassBase | IPAddress | |
| Raynet: Import Computers [Update Only] | PrimaryIPv6Address | SPSComputerClassBase | IPv6Address | |
| Raynet: Import Computers [Update Only] | PrimaryMACAddress | SPSComputerClassBase | PrimaryMACAddress | |
| Raynet: Import Computers [Update Only] | Processor | SPSComputerClassBase | Processor | |
| Raynet: Import Computers [Update Only] | ProcessorClock | SPSComputerClassBase | ProcessorClock | |
| Raynet: Import Computers [Update Only] | ProcessorCount | SPSComputerClassBase | ProcessorCount | |
| Raynet: Import Computers [Update Only] | SerialNumber | SPSAssetClassBase | SerialNumber | |
| Raynet: Import Computers [Update Only] | ThreadsCount | SPSComputerClassBase | ThreadsCount | |
| Raynet: Import Computers [Update Only] | (SyncDate) | SPSInventoryClassBase | LastImportDate | |
| Raynet: Import Computers Virtualization | “1” (Fixed value) | SPSComputerClassBase | IsVirtual | |
| Raynet: Import Computers Virtualization | import_data_source_id | SPSComputerClassBase | VirtualType | |
| Raynet: Import Computers Virtualization | import_from_device_id | SPSComputerClassBase | RaynetDeviceKey | |
| Raynet: Import Computers Virtualization | import_to_device_host_id | SPSComputerClassBase | vCenter | RaynetDeviceKey |
| Raynet: Import Computers Virtualization | import_to_device_id | SPSComputerClassBase | Host | RaynetDeviceKey |
| Raynet: Import Computers Virtualization | powerState | SPSComputerClassBase | PowerState | Replace(Production.DisplayString,' '," |
| Raynet: Import Inventory Application [Staging] | import_device_id | ASMRaynetClassDevice | DeviceKey | |
| Raynet: Import Inventory Application [Staging] | installation_date | ASMRaynetClassInventoryApplication | Installed | |
| Raynet: Import Inventory Application [Staging] | last_usage | ASMRaynetClassInventoryApplication | LastUsage | |
| Raynet: Import Inventory Application [Staging] | product | ASMRaynetClassInventoryApplication | Name | |
| Raynet: Import Inventory Application [Staging] | product_version | ASMRaynetClassInventoryApplication | Version | |
| Raynet: Import Inventory Application [Staging] | publisher | ASMRaynetClassInventoryApplication | Manufacturer | |
| Raynet: Import Inventory Application [Staging] | usage_frequency_month | ASMRaynetClassInventoryApplication | UsageFrequency | |
| Raynet: Import Inventory Application [Staging] | usage_time | ASMRaynetClassInventoryApplication | UsageTime | |
| Raynet: Import Inventory Application | DeviceKey | SPSComputerClassBase | RaynetDeviceKey | |
| Raynet: Import Inventory Application | Installed | SPSInventoryClassApplication | InstallationDate | |
| Raynet: Import Inventory Application | LastUsage | SPSInventoryClassApplication | LastUsage | |
| Raynet: Import Inventory Application | Manufacturer | SPSInventoryClassApplication | Manufacturer | |
| Raynet: Import Inventory Application | Name | SPSInventoryClassApplication | Name | |
| Raynet: Import Inventory Application | UsageFrequency | SPSInventoryClassApplication | UsageFrequency | |
| Raynet: Import Inventory Application | UsageTime | SPSInventoryClassApplication | UsageTime | |
| Raynet: Import Inventory Application | Version | SPSInventoryClassApplication | Version | |
| Raynet: Import Inventory Application | “1” (Fixed value) | SPSInventoryClassApplication | DetectionType | |
| Raynet: Import Inventory Application | (ImportDate) | SPSInventoryClassApplication | LastSyncDate | |
| Raynet: Import Inventory Application | “1” (Fixed value) | SPSInventoryClassApplication | Installed | |
| Raynet: Import Inventory Application | (ImportDate) | SPSInventoryClassApplication | LastChangeDate | |
| Raynet: Import Applications | Manufacturer | SPSApplicationClassBase | Manufacturer | |
| Raynet: Import Applications | Name | SPSApplicationClassBase | Name | |
| Raynet: Import Applications | Version | SPSApplicationClassBase | Version | |
| Raynet: Import Applications | “10903” (Fixed value) | SPSApplicationClassBase | DetectionType | |
| Raynet: Import Applications | "Raynet Integration" (FixedValue) | SPSApplicationClassBase | CreatedBy |