Database query to detect robots without net_connect probe monitoring

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'

    );