Need a sql query to get complete list of agentless CI(being monitored from net_connect probes)
Release: DX UIM
Component: net_connect probe
SELECT DISTINCT d.target FROM s_qos_data d JOIN s_qos_snapshot s ON d.table_id = s.table_id WHERE s.sampletime >= DATEADD(DAY, -15, GETDATE()) AND d.probe = 'net_connect';
Or
SELECT DISTINCT d.target, d.robot FROM s_qos_data d JOIN s_qos_snapshot s ON d.table_id = s.table_id WHERE s.sampletime >= DATEADD(DAY, -15, GETDATE()) AND d.probe = 'net_connect';