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



Type: integer. Key. Generated ID

A unique identifier for a file evidence record.


Type: integer. Key

The file name. Foreign key to the FileEvidenceFile table.


Type: integer. Key

The company publishing the software. Foreign key to the FileEvidenceCompany table.


Type: integer. Key. Nullable

The file path where the file was located. Foreign key to the FileEvidencePath table.


Type: integer. Key. Nullable

The language identified in the file header. Foreign key to the FileEvidenceLanguage table.


Type: text (max 100 characters). Key

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


Type: text (max 200 characters). Nullable

The product name in the file header.


Type: text (max 200 characters). Nullable

The product version number in the file header.


Type: text (max 200 characters). Key

The description in the file header.


Type: integer. Key. Nullable

The size of the file.


Type: integer. Key

The management responsibility for this information. Foreign key to the OperatorManageState table.


Type: boolean

Set this field to True to indicate that this file evidence is ignored for application recognition.


Type: boolean