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.

computerName

varchar(80), null

holds the computer name found in the OS

groupName

varchar(100), null

Organization, then machine group the machine is assigned to.

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)

OperatingSystem

varchar(16), null

Operating system of the computer

OperatingSystemVersion

varchar(150), null

Operating system version information.

loginName

varchar(100), null

Current user logged on.

lastLoginName

varchar(100), null

Prevous user logged on.