You can try this one if you want the see which servers that is monitored by the cdm probe:
SELECT DISTINCT s.name, s.ip, sqd.probe
FROM cm_computer_system s,
cm_device d,
cm_configuration_item ci,
cm_configuration_item_metric cim,
s_qos_data sqd
WHERE s.cs_id = d.cs_id
AND d.dev_id = ci.dev_id
AND ci.ci_id = cim.ci_id
AND cim.ci_metric_id = sqd.ci_metric_id
AND sqd.probe = 'cdm'
/Mats