CM_COMPUTER_SYSTEM table attributes
search cancel

CM_COMPUTER_SYSTEM table attributes


Article ID: 34671


Updated On:


DX Unified Infrastructure Management (Nimsoft / UIM) CA Unified Infrastructure Management SaaS (Nimsoft / UIM) CA Unified Infrastructure Management On-Premise (Nimsoft / UIM)


What fields or columns (attributes) are in cm_computer_system and what do they mean?


Component: CAUIM


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.


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.

  • AWSAutoScalingGroup
  • Device - This category is kind of an "other" category. Either discovery_server doesn't know how to categorize the device or it didn't have enough information to make a determination about what kind of device it is.
  • Firewall - This is a firewall
  • Host - This is synonymous with "server". It essentially means that we determined it was running a recognized operating system like Windows, Linux or Unix.
  • HostSystem
  • Router - This is a router
  • Switch - This is a switch
  • SwitchRouter
  • vCenter - VMware vCenter Link
  • VirtualMachine - This was provided by a virtualization probe, such as VMWare or HyperV.

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

Additional Information

Related KB:
Alive_Time in CM_COMPUTER_SYSTEM and CM_NIMBUS_ROBOT not in sync (