What SQL Table maps to the Agent versions in DSM Explorer ?

Products

• CA Automation Suite for Data Centers - Configuration Automation
• CA Client Automation - Asset Management
• CA Client Automation - IT Client Manager
• CA Client Automation
• CA Client Automation - Remote Control
• CA Client Automation - Asset Intelligence
• CA Client Automation - Desktop Migration Manager
• CA Client Automation - Patch Manager
• CA Server Automation

Issue/Introduction

Question:

What SQL Table maps to Agent versions in DSM Explorer ?

 

Environment:                                        

CA Client Automation - All Versions 

 

Answer:                   

 USE MDB
   SELECT ca_discovered_hardware.host_name, 
   ca_class_def.class_name,
   ca_discovered_hardware.host_uuid,
   ca_agent_component.agent_comp_id,
   ca_agent_component.agent_component_version
   FROM ca_discovered_hardware, ca_agent_component, ca_class_def
   WHERE ca_discovered_hardware.dis_hw_uuid=ca_agent_component.object_uuid and
   ca_discovered_hardware.class_id=ca_class_def.class_id

<Please see attached file for image>

The query above only lists the codes for the plugins, the plugins that correspond to those codes are as follows:

   5 DSM Common Agent (CAF)        
  20 Data Transport Service Agent 
  40 Software Delivery Agent
  80 Asset Management Agent
  81 Asset Management SW Usage Agent
  85 Asset Management Performance Agent
  88 DCS Plugin
  89 RVI Plugin
 105 Common Configuration Agent
 120 Remote Control Agent
 160 Protection Monitor

 

Additional Information:                          

There are 2 ways to get the same information using DSM Reporter :

You can create Report based on:

Software
CA Unicenter Desktop and Server Management
Detected Version

OR

Inventory
System Status
Agent Software
Version

Environment

Release: UASIT.99000-12.9-Asset Intelligence
Component: