5 Replies Latest reply on Nov 12, 2015 12:48 PM by Craig Norborg

    Is It Possible To Search IPAM Description Field?

    ken.collins@sunbeltrentals.com

      We recently started using IPAM its great but we are finding it difficult to track down what location number is tied to what IP as we have a very large IP address space. We can't seem to search the description field of each supernet we create. For example We do the following

       

       

      10.20.0.0 /16 -- Root

                  10.20.0.4 /23 -- Location 123

       

      it is very difficult to track down what has been tagged is there an easier way to do it rather than open every single folder and control F? Using IPAM 4.3

       

      Thanks.

        • Re: Is It Possible To Search IPAM Description Field?
          Craig Norborg

          I'm going to give this a "probably".  The default search is a bit restricted, but if you click on the down arrow in the search box, it will drop down a box of fields you can search on.  There is both "Group Description" and "System Description".  Selecting both of these will probably get you what you want, you can always trim it down to one or the other later...  Let me know if it works or not and which one you used? 

           

           

          search_ipam.jpg

            • Re: Is It Possible To Search IPAM Description Field?
              ken.collins@sunbeltrentals.com

              Unfortunately neither could find anything existing or even subnets I imported via DHCP. I think I just need to continue to expand all the folders and supernets and do a control F on the page as that seems to be the only way to find what I'm looking for.

               

              I would think for an IPAM solution having a robust search function would be a high priority. It seems if the subnets aren't imported and exist the search functionality is useless.

               

              Thanks Craig for replying and offering a suggestion.

                • Re: Is It Possible To Search IPAM Description Field?
                  Craig Norborg

                  Did you try enabling "All Fields" to search on?  I would think its just a matter of finding the right field?

                    • Re: Is It Possible To Search IPAM Description Field?
                      ken.collins@sunbeltrentals.com

                      Yes I did try that no dice. You seem to only find something once its been added as a DHCP server or has a subnet attached to it.

                        • Re: Is It Possible To Search IPAM Description Field?
                          Craig Norborg

                          Hmm...  My next approach would be to check out the databases directly, either via SWQL or SQL.   I tend to use SWQL first when playing, so I came up with a quick query and got very odd results.  Maybe someone from solarwinds would want to weigh in on this, I'd also be curious about your results.

                           

                          I basically took your example, but changed the IP's slightly not to conflict with IP's we might already have in IPAM.  So I did this, from "Manage Subnets & IP Addresses" I clicked on "IP Networks" and then "Add Supernet" and added the "Root Test" subnet below with "Root Test" as the description.   Then I clicked on the "20.20.0.0" line and added the "Location 123 Test" supernet below it.

                          20.20.0.0 /16 -- Root Test

                                      20.20.0.4 /23 -- Location 123 Test

                           

                          Ran this query expecting to get 2 rows, but got hundreds.  692 "Root Test" rows to be exact and 1038 "Location 123 Test" rows...

                           

                          SELECT SubnetId, ParentId, Address, AddressMask, CIDR, AllocSize, FriendlyName, Comments

                          FROM IPAM.Subnet

                          WHERE (Comments LIKE '%Test%')

                          ORDER BY Comments

                           

                          I have no idea why its doing something like this?    AFAIK all the rows are >identical<.   It displays as 1, but there are tons of rows and I can't think of an explanation.

                           

                          Could probably do a DISTINCT, but then you'd have to ORDER BY all the columns you want output.

                           

                          I'm definitely confused a bit, was thinking we could make a simple resource with a search for you, but this part has me a bit stumped for now...

                           

                          Anyone?