SoftwareFilePath Table

The SoftwareFilePath table contains a record for each unique file path for files captured in inventory.

Table 1. Database columns for SoftwareFilePath table

Database Column

Details

SoftwareFilePathID

Type: integer. Key. Generated ID

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

Path

Type: text (max 400 characters). Key

The full path to a file captured in inventory, minus the filename.

CreationDate

Type: datetime. Key

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