Reply

IPAM Statistic Used/Unused IPs per a subnet

Adviser
Posts: 141
3200     0

This simple search shows IPAM network usage statistic.

index=ib_ipam sourcetype="ib:ipam:network" cidr<25 
| streamstats dc(_time) as distinct_times | head (distinct_times == 1) 
| table NETWORK address_total address_alloc address_unalloc

IPAM_Utilisation_per_network.png

Vadim

Re: IPAM Statistic Used/Unused IPs per a subnet

Adviser
Posts: 141
3201     0

This search shows changes in networks utilisation for the period.

IPAM_Changes_in_Networks.png

 

index=ib_ipam sourcetype="ib:ipam:network"
| stats last(address_alloc) as address_alloc_n first(address_alloc) as address_alloc_b last(address_unalloc) as address_unalloc_n first(address_unalloc) as address_unalloc_b  by NETWORK 
| where address_alloc_n != address_alloc_b 
| rename address_alloc_n as "Allocated Now" address_alloc_b as "Allocated Before" address_unalloc_n as "Unallocated Now" address_unalloc_b as "Unallocated Before"

 

Showing results for 
Search instead for 
Did you mean: 

Recommended for You