InstalledFileEvidenceDetail Table

InstalledFileEvidenceDetail provides additional information for file evidence that has been installed on a computer.

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 `InstalledFileEvidenceDetail` table
Database Column	Details
`InstalledFileEvidence DetailID`	Type: integer. Key. Generated ID A unique identifier for a file evidence detail record.
`ComplianceConnectionID`	Type: integer. Key The data source where the match is occurring. Foreign key to the `ComplianceConnection` table.
`ComplianceComputerID`	Type: integer. Key An identifier for a computer record. Foreign key to the `ComplianceComputer` table.
`FileEvidenceID`	Type: integer. Key The file evidence related to the evidence detail. Foreign key to the `FileEvidence` table.
`FilePath`	Type: text (max 400 characters). Key. Nullable The path 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.
`FileName`	Type: text (max 256 characters). Nullable The name of the file used as evidence of software installation.
`Company`	Type: text (max 100 characters). 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.
`InventoryDate`	Type: datetime. Nullable The date the computer where the evidence was found last had inventory reported.