1
0
-1
2 answers
- 10-1
For others playing along at home (or work, as the case may be)...
The below SQL is for a query that will show Windows devices that have been discovered successfully, but NOT had an audit script run.
Menu -> Manage -> Queries -> Create Queries.
SELECT system.id AS `system.id`, system.icon AS `system.icon`, system.type AS `system.type`, system.name AS `system.name`, system.os_name AS `system.os_name` FROM system JOIN windows on (system.id = windows.system_id) WHERE @filter AND system.os_group = "Windows" AND system.id NOT IN (SELECT windows.system_id FROM windows);
Add your comment... - 10-1
Hi Tom,
I believe it is possible but will have to look into this more. In the mean time I created a JIRA ticket for you to be able to track this issue a bit easier. You will receive an email about this topic from JIRA momentarily.
Regards,
Paul M.
Add your comment...
Hi
is it possible to create a group which selects only windows hosts with no data
Br Tom