WMIEvidenceMatchCount Table

WMIEvidenceMatchCount tracks the number of times that each WMI evidence (rule) has been detected as installed and recorded in the data source. A separate count is kept for each WMI evidence rule, and for each data source.

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 WMIEvidenceMatchCount table

Database Column

Details

WMIEvidenceMatchCountID

Type: integer. Key. Generated ID

A synthetic unique identifier is required, since ComplianceConnectionID, being nullable, cannot be included in the primary key.

WMIEvidenceID

Type: integer. Key

WMI evidence rule being matched. Foreign key to the WMIEvidence table.

ComplianceConnectionID

Type: integer. Key. Nullable

Data source where the match is occurring. Foreign key to the ComplianceConnection table.

MatchedCount

Type: integer

The number of installed WMI evidence records in this data source matching this WMI evidence rule.

InstallCount

Type: integer

The number of physical application installations recognized in this data source using this WMI evidence rule.