What fields or columns (attributes) are in cm_computer_system and what do they mean?
CM_COMPUTER_SYSTEM (servers/devices)
csId (Integer)
Computer System ID (number)
description: database generated ID - primary key for the record
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.
change_time:
When this entry was last modified by discovery_server. (Discovery server found some change to the robot. Some examples: adding a probe (change to niscache), adding an IP, adding a probe that has its own discovery such as snmpcollector, vmware)
alive_time:
The time when discovery_server last saw this device. This works with the expire_time raw configure key in discovery_server.
dedicated
A description of the type of system this may be.
state
description: Computer System state
valid values: 0, 2, 3
Maintenance = 3
Managed = 2
Unmanaged = 0
ip
IP address (Integer String)
icmpResponse (Integer Bit)
description: This is a Boolean: 0 = false, 1 = true
valid values: 0, 1
nimbusType
description: Type of component
valid values: 0=other, 1=robot, 2=hub