NewFileEvidence Table

NewFileEvidence identifies files used as evidence that an application (defined in the SoftwareTitle table) has been installed on a computer. File evidence may have wildcards, so each record in this table should be considered a rule, which one or more physical files on a computer may match.

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 `NewFileEvidence` table
Database Column	Details
`FileEvidenceID`	Type: integer. Key. Generated ID A unique identifier for a file evidence record.
`FileEvidenceFileID`	Type: integer. Key The file name. Foreign key to the `FileEvidenceFile` table.
`FileEvidenceCompanyID`	Type: integer. Key The company publishing the software. Foreign key to the `FileEvidenceCompany` table.
`FileEvidencePathID`	Type: integer. Key. Nullable The file path where the file was located. Foreign key to the `FileEvidencePath` table.
`FileEvidenceLanguageID`	Type: integer. Key. Nullable The language identified in the file header. Foreign key to the `FileEvidenceLanguage` table.
`FileVersion`	Type: text (max 100 characters). Key The version number of the file used as evidence of software installation.
`ProductName`	Type: text (max 200 characters). Nullable The product name in the file header.
`ProductVersion`	Type: text (max 200 characters). Nullable The product version number in the file header.
`Description`	Type: text (max 200 characters). Key The description in the file header.
`FileSize`	Type: integer. Key. Nullable The size of the file.
`OperatorManageStateID`	Type: integer. Key The management responsibility for this information. Foreign key to the `OperatorManageState` table.
`Ignored`	Type: boolean Set this field to `True` to indicate that this file evidence is ignored for application recognition.
`IsShared`	Type: boolean