ImportedComputerMatchResult Table

The ImportedComputerMatchResult table stores the results of performing matching between ImportedComputers.

Note: To cater for multi-tenant mode, this table may contain data for multiple tenants. Access requires that the database TenantID has been set in the SQL Server connection context information. That setting filters an underlying table to produce this view of data for the single, selected tenant.
Table 1. Database columns for ImportedComputerMatchResult table

Database Column

Details
PrimaryCompliance ConnectionID

Type: integer. Key

The identifier for a data source connection in the ComplianceConnection table that supplied the primary ImportedComputer.
PrimaryExternalID

Type: big integer. Key

The identifier used in the source connection for the primary ImportedComputer.
MatchedCompliance ConnectionID

Type: integer. Key. Nullable

The identifier for a data source connection in the ComplianceConnection table that supplied the matched ImportedComputer.
MatchedExternalID

Type: big integer. Key. Nullable

The identifier used in the source connection for the matched ImportedComputer.
MatchingRule

Type: text (max 128 characters)

The matching rule which determined the match between these ImportedComputers.
ComputerMatchingReasonID

Type: integer

The ID of the matching rule which determined the match between these ImportedComputers. Foreign key to the ComputerMatchingReason table.
TransitivelyMatched ComplianceConnectionID

Type: integer. Nullable

The identifier for a data source connection in the ComplianceConnection table that supplied the transitively matched ImportedComputer.
TransitivelyMatched ExternalID

Type: big integer. Nullable

The identifier used in the source connection for the transitively matched ImportedComputer.
TransitiveComputer MatchingReasonID

Type: integer. Nullable

The ID of the matching rule which determined the match between these transitively matched ImportedComputers. Foreign key to the ComputerMatchingReason table.