SoftwareDetails Table

The SoftwareDetails table contains a record of detailed data for each SoftwareOccurrence found.

Table 1. Database columns for SoftwareDetails table

Database Column

Details

SoftwareDetailsID

Type: integer. Key. Generated ID

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

RawSoftwareName

Type: text (max 128 characters). Key

The name of the software defined by the vendor, unprocessed by IT Asset Management.

RawVersion

Type: text (max 72 characters). Key

The version of the software defined by the vendor, unprocessed by IT Asset Management.

Publisher

Type: text (max 256 characters). Key

The publisher of the software defined by the vendor.

ProductID

Type: text (max 256 characters). Key

The MSI product ID of the software defined by the vendor.