SoftwareFile Table

!!!!!!!!! IMPORTANT !!!!!!!!!! The following stored procedures are manually overwritten in Inventory.sql, if any schema change here, please make sure the changes are reflected in those stored procdures: - SoftwareFilePutByComputerIDSoftwareIDPathIDNameID - SoftwareFileUpdateByComputerIDSoftwareIDPathIDNameID !!!!!!!!! IMPORTANT !!!!!!!!!!

The SoftwareFile table contains a record for each file associated with an application on each computer. File tracking is not enabled by default. For more information on configuring which files to track, see the section about the Inventory Agent.

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 `SoftwareFile` table
Database Column	Details
`SoftwareFileID`	Type: big integer. Key. Generated ID The id for the software file. This is automatically generated by SQL Server.
`ComputerID`	Type: integer. Key The computer on which the file was tracked. This is a foreign key into the `Computer` table.
`SoftwareID`	Type: integer. Key. Nullable The software containing the file that was tracked. This is a foreign key into the `SoftwareVersion` table.
`SoftwareIsoTagFileID`	Type: integer. Key. Nullable The software ID tag content of the file. This is a foreign key into the `SoftwareIsoTagFile` table.
`Version`	Type: text (max 32 characters). Nullable The version of the software file defined by the vendor.
`MD5`	Type: text (max 32 characters) The file’s MD5 digest.
`Size`	Type: integer The file’s size in bytes.
`DateTime`	Type: datetime. Nullable The last date and time the file was modified on the computer.
`FileVersion`	Type: text (max 256 characters). Nullable The file version of the software file defined by the vendor.
`FileDescription`	Type: text (max 256 characters). Nullable The file description of the software file defined by the vendor.
`Language`	Type: text (max 256 characters). Nullable The language of the software file defined by the vendor.
`CompanyName`	Type: text (max 256 characters). Nullable The company name of the software file defined by the vendor.
`SoftwareFilePathID`	Type: integer. Key. Nullable The full path to the file that was tracked, minus the filename. This is a foreign key into the `SoftwareFilePath` table.
`SoftwareFileNameID`	Type: integer. Key. Nullable The name of the file that was tracked, minus the path. This is a foreign key into the `SoftwareFileName` table.