SQL query to get complete list of agentless configuration items

Products

• DX Unified Infrastructure Management (Nimsoft / UIM)

Issue/Introduction

Need a sql query to get complete list of agentless CI(being monitored from net_connect probes)

Environment

Release: DX UIM

Component: net_connect probe

Resolution

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';