CM_COMPUTER_SYSTEM table attributes

Document ID : KB000034671
Last Modified Date : 14/02/2018
Show Technical Document Details
CM_COMPUTER_SYSTEM (servers/devices)

csId (Integer)
Computer System ID (number)
description: database generated ID

csKey (unique identifier for the node)
description: Discovery server assigned GUID.

csType (String)
description: Computer System Type
valid values: A or D for Automatic or Discovered and E for External (imported devices)

createTime (Date)
description: Discovery server assigned time when inserting the record.

valid values: Virtual Machine, Host, Device

description: Computer System state
valid values: 0, 2, 3
Maintenance = 3
Managed = 2
Unmanaged = 0

IP address (Integer String)

icmpResponse (Integer Bit)
description: This is a Boolean: 0 = false, 1 = true
valid values: 0, 1

description: Type of component
valid values: 0=other, 1=robot, 2=hub

keywords: cm_computer_system attributes columns values cmdb cmdbgtw