ImportedFileEvidence Table

The ImportedFileEvidence table holds all of the file 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 ImportedFileEvidence table

Database Column

Details

ComplianceConnectionID

Type: integer. Key. Nullable

The identifier for a data source connection in the ComplianceConnection table.

ExternalFileID

Type: big integer. Key. Nullable

The identifier used in the source connection for the file evidence.

FileName

Type: text (max 256 characters). Key. Nullable

The name of the file used as evidence of software installation.

FileVersion

Type: text (max 100 characters). Nullable

The version number of the file used as evidence of software installation.

ProductVersion

Type: text (max 200 characters). Nullable

The product version number in the file header.

ProductName

Type: text (max 200 characters). Nullable

The product name in the file header.

FilePath

Type: text (max 400 characters). Nullable

The path of the file used as evidence of software installation.

Company

Type: text (max 100 characters). Key. Nullable

The company in the file header.

Description

Type: text (max 200 characters)

The description in the file header.

FileSize

Type: integer. Nullable

The size of the file.

Language

Type: text (max 200 characters). Nullable

The language in the file header.

AccessModeID

Type: integer. Key. Nullable

The access mode ID of the file evidence.