SoftwareVersion Table

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



Type: integer. Key. Generated ID

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


Type: text (max 128 characters). Key

The name of the software defined by the vendor.


Type: text (max 72 characters). Key

The version of the software defined by the vendor.


Type: datetime. Key

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