ImportedClientAccessEvidence Table

The ImportedClientAccessEvidence table holds all of the client access evidence which has been retrieved from the source connections.

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 `ImportedClientAccessEvidence` table
Database Column	Details
`ComplianceConnectionID`	Type: integer. Key The identifier for a data source connection in the `ComplianceConnection` table.
`ExternalAccessEvidenceID`	Type: big integer. Key The identifier of the client access evidence.
`ProductName`	Type: text (max 256 characters). Key. Nullable The name of the product being accessed by user or computer. This may include version and edition too.
`Version`	Type: text (max 72 characters). Key. Nullable The version of the installed product.
`Edition`	Type: text (max 50 characters). Nullable The edition of the installed product.
`UALRoleName`	Type: text (max 256 characters). Nullable The UAL role name of the product being accessed by user or computer. This is used when retrive data using UAL.
`UALRoleGUID`	Type: unique identifier. Nullable The UAL role GUID of the product being accessed by user or computer. This is used when retrive data using UAL
`Publisher`	Type: text (max 200 characters). Nullable The name of the publisher of the installed product. Defaulting to Microsoft as per recommendation.