Add Relations Between Devices & Enriched Hardware

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