SoftwareFileName Table

The SoftwareFileName table contains a record for each unique file name for files captured in inventory.

Table 1. Database columns for SoftwareFileName table

Database Column

Details

SoftwareFileNameID

Type: integer. Key. Generated ID

The id for the software file name. This is automatically generated by SQL Server.

Name

Type: text (max 400 characters). Key

The name of a file captured in inventory, minus the path.

CreationDate

Type: datetime. Key

The creation date of the SoftwareFileName which will be used to cleanup the older unused records.