vMachine

The information known about each client desktop machine.

Column Name

Type

Purpose

Machine_GroupID

varchar

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

agentGuid

numeric

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

machName

varchar

full machine name. Everything to the left of the left most decimal point is the machine name.

groupName

varchar

full group name for this account. Everything to the right of the left most decimal point is the group name.

Manufacturer

varchar

Manufacturer string (type 1)

ProductName

varchar

Product Name string (type 1)

MachineVersion

varchar

Version string (type 1)

SysSerialNumber

varchar

Serial Number string (type 1)

ChassisSerialNum

varchar

Chassis Serial Number (type 3)

ChassisAssetTag

varchar

Chassis Asset Tag number (type 3)

BusSpeed

varchar

External Bus Speed (in MHz) (type 4)

MaxMemorySize

varchar

Maximum Memory Module Size (in MB) (type 16 - Maximum Capacity or if type 16 not available, Maximum Memory Module Size type 5)

MaxMemorySlots

varchar

Number of Associated Memory Slots (Number of Memory Devices in type 16 or if type 16 not available Number of Associated Memory Slots in type 5)

ChassisManufacturer

varchar

Chassis Manufacturer (type 3)

ChassisType

varchar

Chassis Type (type 3)

ChassisVersion

varchar

Chassis Ver (type 3)

MotherboardManfacturer

varchar

Motherboard Manufacturer (type 2)

MotherboardProductCode

varchar

Motherboard Product Code (type 2)

MotherboardVersion

varchar

Motherboard Version (type 2)

MotherboardSerialNumber

varchar

Motherboard Serial Number (type 2)

ComputerName

varchar

Name of the Computer

IpAddress

varchar

IP Address of the computer in a.b.c.d notation

SubnetMask

varchar

Subnet mask in a.b.c.d notation.  String is empty if data is unavailable

DefaultGateway

varchar

Default gateway IP address in a.b.c.d notation.  String is empty if data is unavailable.

DnsServer1

varchar

DNS server #1s IP address in a.b.c.d notation.  String is empty if data is unavailable.

DnsServer2

varchar

DNS server #2s IP address in a.b.c.d notation.  String is empty if data is unavailable.

DnsServer3

varchar

DNS server #3s IP address in a.b.c.d notation.  String is empty if data is unavailable.

DnsServer4

varchar

DNS server #4s IP address in a.b.c.d notation.  String is empty if data is unavailable.

DhcpEnable

int

0 -> Data is unavailable

1 -> DHCP on client computer is enabled

2 -> Disabled

DhcpServer

varchar

DHCP servers IP address in a.b.c.d notation.  String is empty if data is unavailable.

WinsEnabled

int

0 -> Data is unavailable

1 -> WINS resolution on client computer is enabled

2 -> Disabled

PrimaryWinsServer

varchar

Primary WINS servers IP address in a.b.c.d notation.  String is empty if unavailable.

SecondaryWinsServer

varchar

Secondary WINS servers IP address in a.b.c.d notation.  String is empty if unavailable.

ConnectionGatewayIp

varchar

IP Address in a.b.c.d notation obtained by the Kserver as the source address of the Agent.  This IP is the Agents network gateway and will be different from the IpAddress if the computer is behind NAT for example.  String is empty if unavailable.

OsType

varchar

String contains OS type, such as 95, 98, NT4, 2000, NT3.51, or WIN32s.  Derived from portions of MajorVersion, MinorVersion, and PlatformId.

OsInfo

varchar

String contains additional OS info, such as Build 1381 Service Pack 3.  Derived from portions of BuildNumber and CsdVersion.

MajorVersion

int

Major version number from GetVersionEx() Windows function call.

MinorVersion

int

Minor version number from GetVersionEx() Windows function call.If PlatformId is Win32 for Windows, then a 0 MinorVersion indicates Windows 95.  If PlatformId is Win32 for Windows, then then a MinorVersion > 0 indicates Windows 98.

MacAddr

varchar

String containing the physical address, i.e. the Media Access Control address, of the connection.  A MAC address has the form of: 00-03- 47-12-65-77

LoginName

varchar

User name of the currently logged on user.  This value is updated with every quick check in.  The agent error log file is updated with each change.