|
<< Click to Display Table of Contents >> Raynet One Data Hub > 2026.2 > Connectors > Alphabetic Connector List > Deduplicator > Extracted Data Tables |
The tables listed below are written to the results database on each run. The active tables depend on which deduplication type is configured for the task.
The following tables are written when the Device Deduplication type is selected.
Table |
Column |
Type |
|---|---|---|
devices Deduplicated device records. One row per merged device cluster. |
•MasterRowIdentifier •MasterDeviceId •MasterSource •ClusterId •MergedDeviceCount •ContributingSources •SerialNumber •Uuid •Bios •HostName •Fqdn •Domain •Cpu •CpuChipCount •CpuCoreCount •CpuCoreCountLimited •CpuLimitCoreCount •CpuSpeed •CpuThreadCount •Graphics •Ram •Storage •HyperThreadingAct •Manufacturer •DeviceModel •OperatingSystem •DeviceEvidence •DeviceStatus •DeviceType •Network •Tags •User •InventoryNumber •InstallationDate •InventoryDate |
•GUID •String •String •String •Integer •String •String •GUID •String •String •String •String •String •Integer •Integer •Integer •Integer •Integer •Integer •String •Integer •Integer •String •String •String •String •String •String •String •String •String •String •String •DateTime •DateTime |
raw_devices All source device records with information about which master device each record was merged into. |
•RowIdentifier •DeviceId •Source •SourceTable •ClusterId •MasterRowIdentifier •MasterDeviceId •IsDuplicate •MatchConfidence •HostName •SerialNumber •Uuid •Bios •Domain •InventoryDate |
•GUID •String •String •String •String •GUID •String •Boolean •Integer •String •String •GUID •String •String •DateTime |
matching Duplicate pair relationships. One row per matched device pair, showing why the two records were considered duplicates. |
•SourceRowIdentifier •SourceDeviceId •Source •SourceTable •TargetRowIdentifier •TargetDeviceId •TargetSource •TargetTable •MasterRowIdentifier •MasterDeviceId •ClusterId •Confidence •MatchingMacCount •HasMatchingMac •AllMacsMatch •MatchingIpCount •HasMatchingIp •AllIpsMatch |
•GUID •String •String •String •GUID •String •String •String •GUID •String •String •Integer •Integer •Boolean •Boolean •Integer •Boolean •Boolean |
field_scores Per-field similarity scores for each matched device pair. Written only when the Write Field Scores option is enabled. |
•SourceRowIdentifier •SourceDeviceId •TargetRowIdentifier •TargetDeviceId •FieldName •Similarity •WeightContributed |
•GUID •String •GUID •String •String •Integer •Integer |
relations Deduplicated device relation records (for example, virtual machine to host relationships). |
•FromDeviceKey •PowerState •RelationType •Sources •ToDeviceKey |
•String •String •String •String •String |
hardware_summary Hardware component summary. Aggregates unique hardware models used across deduplicated devices. |
•Id •manufacturer •model •type_hint •used_by |
•GUID •String •String •Integer •Integer |
hardware_matching Links between deduplicated devices and their hardware components in the hardware summary table. |
•deviceId •hardwareId |
•GUID •GUID |
The following tables are written when the Software Deduplication type is selected.
Table |
Column |
Type |
|---|---|---|
DeduplicatedSoftware Deduplicated software installation records. One row per merged software cluster. |
•MasterRowIdentifier •MasterSoftwareId •MasterSource •ClusterId •MergedSoftwareCount •ContributingSources •Product •ProductVersion •Publisher •DeviceId •Edition •InstallationDate •LanguageCode •Type |
•GUID •String •String •String •Integer •String •String •String •String •String •String •String •String •String |
SoftwareRawWithMergeInfo All source software records with information about which master software record each was merged into. |
•RowIdentifier •SoftwareId •SourceTable •ClusterId •MasterRowIdentifier •MasterSoftwareId •IsDuplicate •MatchConfidence •Product •ProductVersion •Publisher •DeviceId |
•GUID •String •String •String •GUID •String •Boolean •Integer •String •String •String •String |
SoftwareDuplicateMatching Duplicate pair relationships for software records. |
•SourceRowIdentifier •SourceSoftwareId •SourceTable •TargetRowIdentifier •TargetSoftwareId •TargetTable •MasterRowIdentifier •MasterSoftwareId •ClusterId •Confidence |
•GUID •String •String •GUID •String •String •GUID •String •String •Integer |
SoftwareDuplicateFieldScores Per-field similarity scores for each matched software pair. Written only when the Write Field Scores option is enabled. |
•SourceRowIdentifier •SourceSoftwareId •TargetRowIdentifier •TargetSoftwareId •FieldName •Similarity •WeightContributed |
•GUID •String •GUID •String •String •Integer •Integer |
The following tables are written when the User Deduplication type is selected.
Table |
Column |
Type |
|---|---|---|
DeduplicatedUsers Deduplicated user records. One row per merged user cluster. |
•MasterRowIdentifier •MasterUserId •MasterSource •ClusterId •MergedUserCount •ContributingSources •FirstName •ImportDataSourceId •ImportId •ImportLevel2Id •ImportLocationId •IsActive •LastName •Login •Source •SourceTable •UserKey •UserPrincipalName |
•GUID •String •String •String •Integer •String •String •String •String •String •String •String •Boolean •String •String •String •String •String •String |
UserRawWithMergeInfo All source user records with information about which master user record each was merged into. |
•RowIdentifier •UserId •SourceTable •Source •ClusterId •MasterRowIdentifier •MasterUserId •IsDuplicate •MatchConfidence •UserPrincipalName •Login •UserKey •FirstName •LastName |
•GUID •String •String •String •String •GUID •String •Boolean •Integer •String •String •String •String •String •String |
UserDuplicateMatching Duplicate pair relationships for user records. |
•SourceRowIdentifier •SourceUserId •SourceTable •TargetRowIdentifier •TargetUserId •TargetTable •MasterRowIdentifier •MasterUserId •ClusterId •Confidence |
•GUID •String •String •GUID •String •String •GUID •String •String •Integer |
UserDuplicateFieldScores Per-field similarity scores for each matched user pair. Written only when the Write Field Scores option is enabled. |
•SourceRowIdentifier •SourceUserId •TargetRowIdentifier •TargetUserId •FieldName •Similarity •WeightContributed |
•GUID •String •GUID •String •String •Integer •Integer |
The following tables are written only when the Create Legacy Tables option is enabled in the Configuration settings. They provide output in a legacy format compatible with older downstream systems and are written in addition to the standard output tables above.
Table |
Column |
Type |
|---|---|---|
result_devices Deduplicated devices in legacy flat-table format. |
•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 •Double •Double •Double •Integer •Double •String •String •String •String •String •String •String •String •String •String •String •String •String •String •String •String •String •String •String •String •String •String •String •String •Boolean •String •String •Integer •String •String •String •Integer •String |
result_device_relations Device relations in legacy format. |
•import_data_source_id •import_device_rel_type_id •import_from_device_id •import_id •import_to_device_host_id •import_to_device_id •powerState •source •source_table |
•String •String •String •String •String •String •String •String •String |
result_software Software installation records in legacy format. |
•description •edition •file_name •file_path •import_account_id •import_data_source_id •import_device_id •installation_date •last_usage •os •product •product_code •product_version •publisher •source •source_table •usage_frequency_month •usage_time |
•String •String •String •String •String •String •String •String •String •String •String •String •String •String •String •String •Integer •Integer |
result_software_summary Aggregated software title summary in legacy format. One row per unique software title. |
•description •edition •file_name •file_path •id •import_data_source_id •installedon •os •product •product_code •product_version •publisher •source •source_table |
•String •String •String •String •GUID •String •Integer •String •String •String •String •String •String •String |
result_inv_raw_msi MSI software installation records in legacy format. Contains only records where the software type is MSI. |
•import_data_source_id •import_device_id •import_id •installation_date •product •product_code •product_version •publisher •source •source_table |
•String •String •String •String •String •String •String •String •String •String |
result_users User records in legacy format. |
•first_name •import_data_source_id •import_id •import_level_2_id •import_location_id •is_active •last_name •login •source •source_table •user_key •userPrincipalName |
•String •String •String •String •String •String •Boolean •String •String •String •String •String •String |
result_user_device_relations User-to-device assignment records in legacy format. |
•creation_time •import_data_source_id •import_device_id •import_id •import_user_id •is_active •is_primary •source •source_table |
•String •String •String •String •String •Boolean •Boolean •String •String |
result_accounts User account records in legacy format. |
•account •import_data_source_id •import_id •import_provider_instance_id •import_user_id •source •source_table •userPrincipalName |
•String •String •String •String •String •String •String •String |