open audit group select

 
1
0
-1

Hi

is it possible to create a group which selects only windows hosts with no data

Br Tom 

    CommentAdd your comment...

    2 answers

    1.  
      1
      0
      -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);
        CommentAdd your comment...
      1.  
        1
        0
        -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.

          CommentAdd your comment...