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


AccessEvidenceMatch CountID

Type: integer. Key. Generated ID

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


Type: integer. Key

The access evidence which is being matched. Foreign key to the AccessEvidence table.


Type: integer. Key. Nullable

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


Type: integer

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


Type: integer

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