Add Relations Between Devices & Enriched Software

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

The result_software_summary table contains summarized software data.

Table

Column

Type

result_software_summary

•id

•file_name

•file_path

•description

•import_data_source_id

•installedon

•product

•product_code

•product_version

•publisher

•source

•source_table

•os

•GUID

•String

•String

•String

•String

•Integer

•String

•String

•String

•String

•String

•String

•String

 

The result_software table contains detailed software data.

Table

Column

Type

result_software

•description

•file_name

•file_path

•import_account_id

•import_data_source_id

•import_device_id

•installation_date

•last_usage

•product

•product_code

•product_version

•publisher

•source

•source_table

•usage_frequency_month

•usage_time

•os

•String

•String

•String

•String

•String

•String

•String

•String

•String

•String

•String

•String

•String

•String

•Integer

•Integer

•String

 

 

 

The SoftwareTransformationMatching table defines the relationship between entries in the software summary and catalog software records.

Table

Column

Type

SoftwareTransformationMatching

•SoftwareSummaryId

•CatalogSoftwareId

•FingerPrintId

•IgnoreReason

•GUID

•GUID

•GUID

•Integer