Infoblox Reporting. IPAM Statistic Used/Unused IPs per a subnet

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

This search shows changes in networks utilisation for the period.

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"

IPAM_Changes_in_Networks

Vadim

Этот сайт использует Akismet для борьбы со спамом. Узнайте как обрабатываются ваши данные комментариев.