Query to find source probe/robot for multiple origins

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

Sometimes you can get confused by why a device might show multiple origins. 
This query will show which probe on which robot is responsible for an entry along with the origin that was brought in as a result.

(This does not take into account origins that have been enriched by qos_processor.)

Environment:
Any UIM Version
Instructions:

DECLARE @IP VARCHAR(15) = 'IP_Adress';

SELECT ccs.cs_id, ip device_ip, ISNULL(cd_src.dev_name, cd.dev_name) source_robot, cd.probe_name source_probe, cda.dev_attr_value origin
FROM CM_COMPUTER_SYSTEM ccs
       INNER JOIN CM_DEVICE cd ON ccs.cs_id = cd.cs_id
             LEFT JOIN CM_DEVICE cd_src ON cd.dev_src_id = cd_src.dev_id
       INNER JOIN CM_DEVICE_ATTRIBUTE cda ON (cd.dev_id = cda.dev_id AND cda.dev_attr_key = 'Origin')
WHERE ip = @IP
ORDER BY cs_id;

Additional Information:

NOTE: CA Support will not provide further info about this Query, if you need more details please Engage your DBA or CA Services Team