Alphabetic Connector List > Deduplicator > Extracted Data

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.

Device Deduplication

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

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

•Integer

•String

•GUID

•String

•Integer

•String

•Integer

•String

•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

•GUID

•String

•Boolean

•Integer

•String

•GUID

•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

•GUID

•String

•GUID

•String

•Integer

•Boolean

•Integer

•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

•Integer

relations

Deduplicated device relation records (for example, virtual machine to host relationships).

•FromDeviceKey

•PowerState

•RelationType

•Sources

•ToDeviceKey

•String

hardware_summary

Hardware component summary. Aggregates unique hardware models used across deduplicated devices.

•Id

•manufacturer

•model

•type_hint

•used_by

•GUID

•String

•Integer

hardware_matching

Links between deduplicated devices and their hardware components in the hardware summary table.

•deviceId

•hardwareId

•GUID

Software Deduplication

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

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

•Integer

•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

•GUID

•String

•Boolean

•Integer

•String

SoftwareDuplicateMatching

Duplicate pair relationships for software records.

•SourceRowIdentifier

•SourceSoftwareId

•SourceTable

•TargetRowIdentifier

•TargetSoftwareId

•TargetTable

•MasterRowIdentifier

•MasterSoftwareId

•ClusterId

•Confidence

•GUID

•String

•GUID

•String

•GUID

•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

•Integer

User Deduplication

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 •Email •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 •ClusterId •MasterRowIdentifier •MasterUserId •IsDuplicate •MatchConfidence •Email •UserPrincipalName •Login •UserKey •FirstName •LastName	•GUID •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

Table

Column

Type

DeduplicatedUsers

Deduplicated user records. One row per merged user cluster.

•MasterRowIdentifier

•MasterUserId

•MasterSource

•ClusterId

•MergedUserCount

•ContributingSources

•Email

•FirstName

•ImportDataSourceId

•ImportId

•ImportLevel2Id

•ImportLocationId

•IsActive

•LastName

•Login

•Source

•SourceTable

•UserKey

•UserPrincipalName

•GUID

•String

•Integer

•String

•Boolean

•String

UserRawWithMergeInfo

All source user records with information about which master user record each was merged into.

•RowIdentifier

•UserId

•SourceTable

•ClusterId

•MasterRowIdentifier

•MasterUserId

•IsDuplicate

•MatchConfidence

•Email

•UserPrincipalName

•Login

•UserKey

•FirstName

•LastName

•GUID

•String

•GUID

•String

•Boolean

•Integer

•String

UserDuplicateMatching

Duplicate pair relationships for user records.

•SourceRowIdentifier

•SourceUserId

•SourceTable

•TargetRowIdentifier

•TargetUserId

•TargetTable

•MasterRowIdentifier

•MasterUserId

•ClusterId

•Confidence

•GUID

•String

•GUID

•String

•GUID

•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

•Integer

Legacy Tables

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_users User records in legacy format.	•email •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

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

•Integer

•Double

•String

•Boolean

•String

•Integer

•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

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

•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

•GUID

•String

•Integer

•String

result_users

User records in legacy format.

•email

•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

•Boolean

•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

•Boolean

•String