<< Click to Display Table of Contents >> Raynet One Data Hub > 14.1 > 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 |