1 Reply Latest reply on Jul 27, 2015 5:08 AM by muralikvp

    IPAM Filters

    nkoos

      I've searched through the forums here, but so far have only found a dated post from 2010 asking for a 'not available' filter so that used, reserved, transient, and DHCP managed addresses would show up.  Basically I want to be able to view a list of all of our used addresses without having to sift through all the available addresses as well.  The only way I can think of doing this with the current setup is changing our static assignments from 'used' to 'reserved' so that I can view them all on one filter.  Does anyone know if we can create custom filters or if Solarwinds plans on implementing more filter options?

        • Re: IPAM Filters
          muralikvp

          You may create an custom SWQL report which will give the list of 'Not available' ipAddress list.Could you use the below query to get the list of Not available ip Address collection

           

          ========================

          SELECT IPAddress, CASE i.status WHEN 1 THEN 'USED' WHEN 4 THEN 'Reserved'  WHEN 8 THEN 'Transient' END as Status FROM IPAM.IPNode I

          Where i.Status !=2

           

          ==========================