vMachine

The information known about each client desktop machine.

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), not null

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

machName

varchar(100), null

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

groupName

varchar(100), null

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

Manufacturer

varchar(100), null

Manufacturer string (type 1)

ProductName

varchar(100), null

Product Name string (type 1)

MachineVersion

varchar(100), null

Version string (type 1)

SysSerialNumber

varchar(100), null

Serial Number string (type 1)

ChassisSerialNumber

varchar(100), null

Chassis Serial Number (type 3)

ChassisAssetTag

varchar(100), null

Chassis Asset Tag number (type 3)

BusSpeed

varchar(100), null

External Bus Speed (in MHz) (type 4)

MaxMemorySize

varchar(100), null

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

MaxMemorySlots

varchar(100), null

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(100), null

Chassis Manufacturer (type 3)

ChassisType

varchar(100), null

Chassis Type (type 3)

ChassisVersion

varchar(100), null

Chassis Ver (type 3)

MotherboardManufacturer

varchar(100), null

Motherboard Manufacturer (type 2)

MotherboardProductCode

varchar(100), null

Motherboard Product Code (type 2)

MotherboardVersion

varchar(100), null

Motherboard Version (type 2)

MotherboardSerialNumber

varchar(100), null

Motherboard Serial Number (type 2)

ComputerName

varchar(80), null

Name of the Computer

IpAddress

varchar(20), null

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

SubnetMask

varchar(20), null

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

DefaultGateway

varchar(20), null

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

DnsServer1

varchar(20), null

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

DnsServer2

varchar(20), null

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

DnsServer3

varchar(20), null

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

DnsServer4

varchar(20), null

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

DhcpEnabled

int(10), null

0 -> Data is unavailable

1 -> DHCP on client computer is enabled

2 -> Disabled

DhcpServer

varchar(20), null

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

WinsEnabled

int(10), null

0 -> Data is unavailable

1 -> WINS resolution on client computer is enabled

2 -> Disabled

PrimaryWinsServer

varchar(20), null

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

SecondaryWinsServer

varchar(20), null

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

ConnectionGatewayIp

varchar(20), null

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.

ipv6Address

varchar(40), null

The ipv6 address. Null, if no address is provided.

OsType

varchar(8), null

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

OsInfo

varchar(150), null

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

MajorVersion

int(10), null

Major version number from GetVersionEx() Windows function call.

MinorVersion

int(10), null

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(40), null

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(100), null

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.

timezoneOffset

int(10), not null

The timezone offset for the agent as compared to universal time.

agentInstGuid

varchar(4) not null

The unique portion of the path to the K2 (v6.0.0.0 and above) agent directory and to the service name as KA+vMachine.agentInstGuid.