ImportedFileEvidence Table
The ImportedFileEvidence
table holds all of the file evidence which has been retrieved from the source connections.
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.
Database Column |
Details |
---|---|
ComplianceConnectionID
|
Type: integer. Key. Nullable The identifier for a data source connection in the |
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. |