You could try something like: (in my small lab environment this works)
This query will:
- select all robots
- select all sources that have a qos coming from net_connect (= normally all monitored devices)
- as a result will list all robots that don't have a qos from net_connect
SELECT ip,os_major,os_minor,domain,hub,robot,origin,is_hub,robot_active,user_tag_1,user_tag_2,address FROM CM_NIMBUS_ROBOT with(nolock) where robot not in (select distinct(source) from s_qos_data where probe = 'net_connect'