vLicenseInfo

License information collected during audit.

Column Name

Type

Purpose

Machine_GroupID

varchar(201), null

A concatenated representation of the machine id and the group id it is associated with.

agentGuid

numeric(26,0), null

A globally unique identifier for a machine ID.group ID account and its corresponding agent.

machName

varchar(100), null

Machine Name used for each agent

groupName

varchar(100), null

Group Name used for each agent

Publisher

varchar(100), null

software publisher (usually in the Publisher reg value)

ProductName

varchar(100), null

Software title (usually in DisplayName value but may be the reg key title)

LicenseCode

varchar(100), null

License code (usually in the ProductID value)

ProductKey

varchar(100), null

Product key

LicenseVersion

varchar(100), null

version string returned by the scanner (if any)

InstallDate

varchar(100), null

install date string returned by the scanner (if any)