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