1 Reply Latest reply on Apr 10, 2013 9:46 PM by bluefunelemental

    IPAM Subnet Report

    tgash70

      Hello,

       

      Looking for some guidance.  We are using IPAM 3.1 and have Report Writer 2012 2.1 installed.  In IPAM we have our subnets broken down into three groups,  Americas,  EMA, and APAC.  Then under the Regional groups we have site groups.  For example in Manage Subnets & IP Address our left hand column looks like the following:

       

      IP Networks

           Americas

               Boston

               New York

           EMEA

                London

               Berlin

               etc

       

       

      I know I need to execute an Advanced SQL report to get what I want I just don't know the field names to do this.  What I am trying to accomplish is a report for all the Americas subnets,  another for all the EMEA subnets, etc.   Can someone point me in the right direction to accomplish this?

       

      Thank you,

      Tom

        • Re: IPAM Subnet Report
          bluefunelemental

          Have you tried sorting by the field ${parent ID}? I have not tried this yet but all subnets under each parent should share that field so using the Orion report writer grouping function might work. 

          You can try without resorting to SQL for that field.

          1 of 1 people found this helpful