vLicenseInfo
|
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. |
