SQL query to get complete list of agentless configuration items
search cancel

SQL query to get complete list of agentless configuration items

book

Article ID: 382518

calendar_today

Updated On:

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