SoftwareFile Table

FlexNet Manager Suite (Cloud)

!!!!!!!!! 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.

FlexNet Manager Suite (Cloud)

Current