Add Relations Between Devices & Enriched Hardware

<< Click to Display Table of Contents >>

Raynet One Data Hub > 2026.2 > Connectors > Alphabetic Connector List > Raynet One Technology Catalog > Input Data 

Add Relations Between Devices & Enriched Hardware

The result_devices table contains detailed device information.

Table

Column

Type

result_devices

•bios

•cpu_chip_count

•cpu_core_count

•cpu_core_count_limited

•cpu_speed

•cpu_thread_count

•department

•device_key

•device_manufacturer

•device_model

•device_name

•fqdn

•graphics

•hostname

•hyper_threading_act

•import_cpu_type_id

•import_data_source_id

•import_device_status_id

•import_device_type_id

•import_domain_id

•import_id

•import_location_id

•import_operating_system_id

•import_org_level_2_id

•import_user_id

•installation_date

•inventory_date

•inventory_number

•ip_address

•last_logon_timestamp

•limit_cpu_core_count

•mac_address

•network

•ram

•serial_number

•source

•source_table

•storage

•uuid

•String

•float

•float

•float

•Integer

•Integer

•String

•String

•String

•String

•String

•String

•String

•String

•String

•String

•String

•String

•String

•String

•String

•String

•String

•String

•String

•String

•String

•String

•String

•String

•Integer

•String

•String

•Integer

•String

•String

•String

•Integer

•String

 

 

 

The result_hardware_summary table contains summarized hardware data.

Table

Column

Type

result_hardware_summary

•Id

•manufacturer

•model

•type_hint

•used_by

•GUID

•String

•String

•Integer

•Integer

 

 

The HardwareTransformationMatching table defines the relationship between hardware summary entries and enriched hardware records.

Table

Column

Type

HardwareTransformationMatching

•HardwareSummaryId

•HardwareId

•FingerPrintId

•IgnoreReason

•GUID

•GUID

•GUID

•Integer