ImportedInstalledFileEvidenceUsage Table

The ImportedInstalledFileEvidenceUsage table holds a record of end-users that are using file evidence from the source connection.

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 `ImportedInstalledFileEvidenceUsage` table
Database Column	Details
`ComplianceConnectionID`	Type: integer. Key. Nullable The identifier for a data source connection in the `ComplianceConnection` table.
`StartDate`	Type: text (max 10 characters). Nullable The start date of the file evidence usage tracking period.
`ExternalID`	Type: big integer. Key. Nullable The identifier used in the source connection for the computer that the file evidence is installed on.
`ExternalUserID`	Type: big integer. Key. Nullable The identifier used in the source connection for the end-user that has used the file evidence.
`ExternalFileID`	Type: big integer. Key. Nullable The identifier used in the source connection for the file evidence.
`ActiveTimeInSeconds`	Type: big integer. Nullable The number of seconds that the file evidence was in use during the usage tracking period.
`NumberOfSessions`	Type: big integer. Nullable The number of sessions that the file evidence was in use during the usage tracking period.
`LastUsedDate`	Type: text (max 10 characters). Nullable The last used date of the file evidence.