5 Replies Latest reply on Sep 3, 2009 6:35 AM by Peter.Cooper

    IPAM Report

    mattjenkins

      Hi All,

      I'm having a problem writing a report for IPAM.
      Basically i want a list of subnets that have that have no ip address's above .101 used/transient or reserved

      Ive been sat in front of report writer for 3 hours now with no luck at all...

      Grateful for any help

      Matt

        • Re: IPAM Report
          Peter.Cooper

          Hi Matt, stand by (and take a breather from report writer).

          The method I was going to use didn't work out of the box. I'll respond back shortly with some directions.

          • Re: IPAM Report
            Peter.Cooper

            There is a column called "IP Ordinal" that isn't in the report writer system with 1.0.1. To use it, I have made a "Advanced SQL Report" so that I could select it and leverage it with you. I think this is a fairly decent starting place.

            [View:/cfs-file.ashx/__key/CommunityServer.Components.UserFiles/00.00.01.51.39/IPAM_5F00_SampleReport_5F00_IPsAbove100.zip]

            This report will select any IP above "100" that is not available (ignoring the last IP in the subnet).

            It will list: Subnet Display Name, Subnet Address, IPv4 Address, and IP Status.

            All fields, except IP Status, have appropriate web URLs assigned to them. Give it a try!