5 Replies Latest reply on Jul 12, 2019 9:04 AM by jf_c

    IPAM : swql request with several fields to be entered by user (need ur help!)

    jf_c

      Hi!

       

      First of all, hello everybody ! i need your help coz i just bought an IPX license for solarwinds IPAM and i am facing an issue.

      I need to make a request in the front page (not a report) that search through the database free subnets with several custom fields to be entered by the users.

       

      For exemple:  search free subnets which have the following specifications: CIDR = xxx AND status = "yyy" AND location " zzz "

      ==> I can manage to have only one free field that a user

       

      Request SWQL:

      SELECT s.Location, s.Address, s.CIDR, s.VLAN, c.Zone, c.Etat, GroupId FROM IPAM.GroupsCustomProperties c

      INNER JOIN

      IPAM.subnet AS s ON c.groupId = s.SubnetId

      where s.CIDR LIKE '${SEARCH_STRING}' AND s.location LIKE "PARIS"  AND c.Status LIKE 'LIBRE'

      order by s.location

       

      ==> so i need hundred of requests if i can have only one free fileds on a swql request

       

      Sorry for the difficulty to explain my problem.. i dont know very well the software.. !

       

      JF-C