CM_COMPUTER_SYSTEM table attributes

Products

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

Issue/Introduction

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

Environment

Release:
Component: CAUIM

Resolution

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.

• 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.

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

Additional Information

Related KB:
Alive_Time in CM_COMPUTER_SYSTEM and CM_NIMBUS_ROBOT not in sync (broadcom.com)