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

Document ID : KB000021755
Last Modified Date : 14/02/2018
Show Technical Document Details

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

Query.jpg
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