This discussion has been locked. The information referenced herein may be inaccurate due to age, software updates, or external references.

You can no longer post new replies to this discussion. If you have a similar question you can start a new discussion in this forum.

IPAM Report

mattjenkins over 14 years ago

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

Parents

0 Peter.Cooper over 14 years ago

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.
IPAM_SampleReport_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!
Cancel
Vote Up 0 Vote Down

Cancel

Reply

0 Peter.Cooper over 14 years ago

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.
IPAM_SampleReport_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!
Cancel
Vote Up 0 Vote Down

Cancel

Children

0 mattjenkins over 14 years ago in reply to Peter.Cooper

Thanks for that Peter...
Its nearly what i wanted but i think its becuase of the way i explained it... Ill try again:
I want to have a list of subnets (not the IP's) where i only have IP's below .101 used/reserved/transient. If an IP over .101 is used/reserved/transient it wont list it.
Hope this explains it better...
Cancel
Vote Up 0 Vote Down

Cancel
0 mattjenkins over 14 years ago in reply to mattjenkins

Peter,
Are you able to help modify your report as per my last post??
Cancel
Vote Up 0 Vote Down

Cancel
0 Peter.Cooper over 14 years ago in reply to mattjenkins

Hello Matt, please check your email. If you're not getting emails from this forum, just click my avatar and send me one.
Cheers!
Cancel
Vote Up 0 Vote Down

Cancel