InstalledFileEvidenceAttribute Table

The InstalledFileEvidenceAttribute table holds a record of the values of the imported file evidence attributes for each file evidence which is reported to be 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 InstalledFileEvidenceAttribute table

Database Column

Details

InstalledFileEvidence AttributeID

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). Nullable

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

AttributeID

Type: integer. Key

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

Value

Type: text

The value othe imported file evidence attribute for the installed installer evidence.