cancel
Showing results for 
Search instead for 
Did you mean: 
Create Post
Level 8

IPAM Report For DHCP Scopes With 0% Used IPs

Jump to solution

Hi All,

I am looking for a report that I can run that will list all of the scopes that have 0% of the IP addresses used, meaning the DHCP scope is not being utilized.  Is that possible?

Thanks!

Tags (2)
0 Kudos
1 Solution
Level 10

Create custom table report and set the following criteria:

pastedImage_0.png

Then add whatever fields you want too see in table layout (for example Address and Percent used) and you will get what you need.

View solution in original post

0 Kudos
4 Replies
Level 10

Create custom table report and set the following criteria:

pastedImage_0.png

Then add whatever fields you want too see in table layout (for example Address and Percent used) and you will get what you need.

View solution in original post

0 Kudos

Hi jpaluch, Thanks for the response and sorry for my slow response. 

Your query does work; however, I think it is reporting the DHCP scopes twice because we have a pair of DHCP servers at each site.  I wonder if there is a way to clean that up?  See screenshot for what I mean.

pastedImage_0.png

0 Kudos

Using the "Group results by: Address - DHCP Scope" makes it a bit more tolerable.

0 Kudos

interesting ... all subnets are served from two different locations.  how do you prevent duplicate IPs being issued?

 

0 Kudos