SoftwareVersion Table

FlexNet Manager Suite 2020 R1 (On-Premises)

The SoftwareVersion table contains a record for each software name/version combination returned through inventory. The software names and versions are gathered from places such as Add/Remove Programs on managed devices. They do not represent package names and versions from the software library, although correlation is likely.

Table 1. Database columns for SoftwareVersion table

Database Column

Details

SoftwareID

Type: integer. Key. Generated ID

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

SoftwareName

Type: text (max 128 characters). Key

The name of the software defined by the vendor.

Version

Type: text (max 32 characters). Key

The version of the software defined by the vendor.

CreationDate

Type: datetime. Key

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

FlexNet Manager Suite (On-Premises)

2020 R1