vBaseApplicationInfo

vCurrApplicationInfo

audit results for installed applications.  One entry per installed application found in the registry key HKEY_LOCAL_MACHINE\Software\Microsoft\ Windows\CurrentVersion\App Paths.

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

ProductName

varchar(128), null

Product name (e.g. Microsoft Office 2000)

ProductVersion

varchar(50), null

Version (e.g. 9.0.3822)

ApplicationName

varchar(128), null

Application name (e.g. Winword.exe)

manufacturer

varchar(128), null

Manufacturers name (e.g. Microsoft Corporation)

ApplicationDesc

varchar(512), null

Description (e.g. Microsoft Word for Windows)

LastModifiedDate

varchar(50), null

File date (e.g. 02/24/2000 17:23:44)

ApplicationSize

int(10), null

File size in bytes (e.g. 8810548)

DirectoryPath

varchar(256), null

Directory path on client desktop (e.g. C:\PROGRA~1\MICROS~4\OFFICE)