AccessEvidenceMatchCount Table

AccessEvidenceMatchCount tracks the number of times that each access evidence (rule) has been detected as installed and recorded in the data source. A separate count is kept for each access 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 `AccessEvidenceMatchCount` table
Database Column	Details
`AccessEvidenceMatch CountID`	Type: integer. Key. Generated ID A synthetic unique identifier is required, since `ComplianceConnectionID`, being nullable, cannot be included in the primary key.
`AccessEvidenceID`	Type: integer. Key The access evidence which is being matched. Foreign key to the `AccessEvidence` table.
`ComplianceConnectionID`	Type: integer. Key. Nullable The data source where the match is occurring. Foreign key to the `ComplianceConnection` table.
`MatchedCount`	Type: integer The number of installed access evidence records in this data source matching this access evidence rule.
`InstallCount`	Type: integer The number of physical application installations recognized in this data source using this access evidence rule.