2.45 NC_VirtualMachine Table

Contains information about a virtual machines.

Column Name

Key

Datatype

Null

Description

VirtualMachineOID

PK,FK

binary(16)

N

internal ID number used as primary key.

HostWorkstationOID

 

binary(16)

N

identifies the workstation that hosts this VM.

VMDisplayName

 

nvarchar(100)

 

The virtual machine display name.

VMGuestOS

 

nvarchar(100)

 

The virtual machine operating system.

VMType

 

tinyint

N

The virtual machine type.

VMEthernetAddress

 

nvarchar(12)

 

The virtual machine Ethernet address.

VMUUID

 

nvarchar(36)

 

The virtual machine UID.

NOTE:

  • VMType: 0=None, 1 = Unknown, 2 = VMware, 3 = VirtualPC

FK References:

  • FK_VirtualMachine_WkstnOID: HostWorkstationOID references NC_Workstation.WorkstationOID

Indexes:

  • IDX_VirtualMachine_WkstnOID: HostWorkstationOID

Check Constraints:

  • CK_VirtualMachine_VMType: VMType between 1 and 3 (inclusive)