Community
- Command Central
- MVP Program
- Monthly Mission
- Blogs
- Groups
- Events
- Media Vault
Products
- Observability
- Network Management
- Application Management
- IT Security
- IT Service Management
- System Management
- Database Management
Content Exchange
- SolarWinds Platform
- Server & Application Monitor
- Database Performance Analyzer
- Server Configuration Monitor
- Network Performance Monitor
- Network Configuration Manager
- SQL Sentry
- Web Help Desk
Free Tools & Trials
Store

IPAM Report For DHCP Scopes With 0% Used IPs

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!

Find more posts tagged with

dhcp

ipam

Accepted answers

jpaluch

Create custom table report and set the following criteria:

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

All comments

jpaluch

Create custom table report and set the following criteria:

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

aellis

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.

aellis

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

carxfrog

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