2 Replies Latest reply on Apr 4, 2017 8:01 PM by lauminshen

    Using custom SWQL to search for subnets

    lauminshen

      Hi there,

       

      I notice after using the IPAM 4.3.2, the custom SWQL query is returning multiple results (repeated results). I did a subnet name search (refer to capture 1). It will display 181 results with the same subnet name. In the IP search, it will only return 1 search (refer to capture 2). I the SWQL queries are as below

       

      Custom SWQL Query:

      SELECT Address, CIDR, FriendlyName as DisplayName, VLAN FROM IPAM.Subnet WHERE CIDR > 0 AND GroupTypeText = 'Subnet';

       

      Search SWQL Query:

      SELECT Address, CIDR, FriendlyName as DisplayName, VLAN FROM IPAM.Subnet WHERE (Address LIKE '%${SEARCH_STRING}%' OR FriendlyName LIKE '%${SEARCH_STRING}%') AND CIDR > 0 AND GroupTypeText = 'Subnet';

       

      Anyone encounter similar issue while using the custom SWQL and how can we solve this issue?

       

      Thank you.