5 Replies Latest reply on Dec 18, 2012 11:28 PM by solarwooky

    custom sql query to filter the "Top XX Errors & Discards This Hour"?

    ian105

      I am trying to create 2 separate views

       

      One containing all devices that are on the WAN
      Other containing all devices that are not on the wan

      I wrote the below sql query, and it returns all interfaces that are a member of a node, with the custom property of WAN_Router in the DeviceType column in the nodes table.

      select * from interfaces where NodeID  in (select NodeID from nodes where DeviceType = 'WAN_Router')

      I cannot seem to figure out how to apply this query into the filter interfaces box, I keep getting Custom SQL filter is incorrectly formated.

       

      Are nested statements such as the above not allowed? If not how would I go about filtering the interface list, based on a value in the nodes table