computerSystem

The computerSystem table represents the logical or virtual perspective of the physical device

The following table describes the computerSystem table.

Table 1. computerSystem table 
Column name Type Constraints Description

entityId

Integer

not null

The identifier of a computerSystem entity from the entityData table.

architecture

255-character string

  
Architecture of the device. Valid values are
  • alpha
  • i686
  • sun4
  • PowerPC®
  • PowerPC_POWER3
  • PowerPC_POWER4
  • PowerPC_POWER5
  • PowerPC_604
  • HP PA-RISC

assetID

255-character string

  

Asset identifier for this entity.

assetTag

255-character string

  

Asset tag for this entity.

autoStart

Tiny integer

  
Indicates whether the computer system can be automatically started.
  • TRUE: computer system can be automatically started.
  • FALSE: computer system cannot be automatically started.

availableMemForAllVMs

64-bit integer

  

Amount of memory (in bytes) currently available for all virtual machines.

bootOrder

255-character string

  
Boot sequence settings of a system. The colon (:) character is used to delimit multiple device names. Possible values for this attribute are as follows:
  • Hard Drive x (where x is optional and is an integer value starting from 0).
  • DVD x.
  • CD x.
  • LAN PXE (including all variants such as MBA, IGA and others).

ciCategory

255-character string

  

Configuration item category for this entity.

ciRole

Tiny integer

  

Identifies the environment, or role, in which a configuration item (CI) resides. For example, if a CI is set aside for test purposes, then this column can be set to a value of Test. If a role is needed that is not defined in the enumeration for ciRole, then use the value Other.

cpuLimit

64-bit integer

  

Maximum amount of CPU that can be used by this virtual machine even if there is more CPU available in the resource pool.

cpuReservation

64-bit integer

  

Amount of CPU that is reserved for this virtual machine.

cpuSharesLevel

Tiny integer

  

Level of shares specified for this virtual machine. Shares define the relative priority or importance of a virtual machine within a specific Hypervisor. Each virtual machine is entitled to resources in proportion to its specified shares, bounded by its reservation and limit. A virtual machine with twice as many shares as another is entitled to twice as many resources. The values are comparable only across VMs that are virtualizing the same ComputerSystem.

cpuSharesValue

64-bit integer

  

Actual number of CPU shares allocated to this virtual machine or resource pool. It is used only when the level of CPU shares (defined by the CPUSharesLevel attribute) is set to the value Custom.

cdpDeviceId

255-character string

  

Device ID defining the node for the Cisco Discovery Protocol. This attribute is Cisco-specific and will move to a class representing the Cisco Computer System.

configLastUpdate

255-character string

  

UTC date and time when the information was last altered in the source application.

currentMemForAllVMs

64-bit integer

  

Amount of memory currently allocated for all virtual machines.

generalCIRole

255-character string

  

Environment, or role, in which a configuration item (CI) resides.

isVMIDanLPAR

Tiny integer

  
Specifies if the computer system is a Logical PARtition (LPAR) or if the computer system is using other virtual machine types, such as a central processor complex (CPC) . An LPAR represents all IBM® mainframe and non-mainframe virtualization technologies, including zSeries, pSeries, iSeries, and DS8000®. Possible value are:
  • TRUE: computer system is an LPAR.
  • FALSE: computer system is using a virtual machine type other than an LPAR.

lastAuditState

Tiny integer

  
Last audit state for this device. Possible values are:
  • 0 Unknown
  • 1 Other
  • 2 Good
  • 3 No Physical CI
  • 4 No CMDB Record
  • 5 Inaccurate CMDB Record

lastAuditTime

Timestamp

  

Last audit time this entity.

lastLifecycleStateTime

Timestamp

  

Last lifecycle state time for this entity.

lifecycleState

Tiny integer

  
Lifecycle state for this device. Possible values are:
  • 0 Unknown
  • 1 Other
  • 2 Ordered
  • 3 Received
  • 4 In Test
  • 5 Tested
  • 6 Installed
  • 7 Enabled
  • 8 Disabled
  • 9 In Maintenance
  • 10 Retired
  • 11 Archived
  • 12 Accepted
  • 13 Draft
  • 14 Build
  • 15 Validate
  • 16 ProductionReady
  • 17 Production
  • 18 Sunset
  • 19 PostProduction
  • 20 Inventory
  • 21 Development
  • 22 Offline

manufacturer

255-character string

  

Vendor-specific hardware type for this entity.

memoryLimit

64-bit integer

  

Last audit time this device.

memoryReservation

64-bit integer

  

Amount of memory that is reserved for this machine.

memorySharesLevel

Tiny integer

  

level of memory shares specified for this virtual machine. Shares define the relative priority or importance of a virtual machine. Each virtual machine is entitled to resources in proportion to its specified shares, bounded by its reservation and limit. A virtual machine with twice as many shares as another is entitled to twice as many resources.

memorySize

64-bit integer

  

Size of physical memory that is present in the computer system.

model

255-character string

  

Model name for this entity.

name

255-character string

  

The textual name of the physical entity. The value of this object must be the name of the component as assigned by the local device and is suitable for use in commands entered at the console of the device. Depending on the physical component naming syntax of the device, this value might be a text name, for example console, or a single component number, for example a port number or a module number.

namingRuleAlgorithms

255-character string

  

Proprietary attribute, used internally by IBM Tivoli Application Dependency Discovery Manager.

primaryMACAddress

255-character string

  

MAC Address of the network adapter in the computer system. If there are multiple network adapters in the computer system, the primary MAC Address is determined by ordering the MAC address according to their numeric value, selecting the lowest valued MAC address.

processCapacityUnits

Tiny integer

  

Units in which the ProcessingCapacity field value is expressed.

processingCapacity

Floating-point number

  

Processing capacity of this computer system, including all of the CPUs assigned to it.

romVersion

255-character string

  

ROM (Read-Only Memory) or the BIOS (Basic Input/Output System) version of the motherboard in the computer system.

serialNumber

255-character string

  

The serial number of the entity.

serviceConsoleMemSize

64-bit integer

  

Amount of memory that is reserved for the service console.

signature

255-character string

  

Signature of the computer system. The value is composed as follows: the dot-notated IP address, the ( character, the MAC Address in hexadecimal with upper case characters only (sans hashes), the )character.

swapMemSize

64-bit integer

  

Memory size of a datastore on which the virtual machine swap files are allocated.

systemBoardUUID

255-character string

  

Specifies the burned-in Globally Unique Identifier (GUID) of this piece of equipment.

systemId

255-character string

  

Field used by IBM Tivoli Application Dependency Discovery Manager.

cdmType

255-character string

  

Common data model type for this device.

uuid

255-character string

  

Unique identifier of this piece of equipment.

vmid

255-character string

  

Unique identifier for the virtual machine. It corresponds to the Virtual Machine ID in the VM table. For System p or System z® computer systems, this is the LPARID value.

virtual

Tiny integer

  
Specifies whether this computer system is virtual. Possible values are:
  • TRUE: computer system is virtual.
  • FALSE: computer system is not virtual.

vmotionEnabled

Tiny integer

  

Specifies whether the VMWare VMotion feature is enabled on this computer system.