Database query to detect robots without net_connect probe monitoring
search cancel

Database query to detect robots without net_connect probe monitoring

book

Article ID: 384784

calendar_today

Updated On:

Products

DX Unified Infrastructure Management (Nimsoft / UIM)

Issue/Introduction

net_connect probe has been installed on hub xyz to facilitate all robots ping monitoring.

We previously configured numerous robot IPs on the net_connect probe approximately a year ago

We require a query to  list of newly added robots not currently covered by net_connect probe

Environment

Any supported UIM version

Resolution

Can explore below query for this use case 
 
SELECT 
    robot
FROM 
    cm_nimbus_robot
WHERE 
    robot NOT IN (
        SELECT 
            DISTINCT 
            LEFT(d.target, CHARINDEX(':', d.target) - 1)
        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'
AND d.robot = 'xyz'
    );