What fields are in cm_computer_system and what do they mean?
Computer System ID (number)
description: database generated ID - primary key for the record
csKey (unique identifier for the node)
description: Discovery server assigned GUID.
description: Computer System Type
valid values: A or D for Automatic or Discovered and E for External (imported devices)
description: Discovery server assigned time when inserting the record.
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)
The time when discovery_server last saw this device. This works with the expire_time raw configure key in discovery_server.
A description of the type of system this may be.
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