IPAM Subnet Utilization Report

What this query does

Show all subnets with IP utilization percentage and available IP count

SWQL Query

SELECT FriendlyName, Address, CIDR, TotalCount, UsedCount,
       AvailableCount, ReservedCount,
       ROUND(UsedCount * 100.0 / NULLIF(TotalCount, 0), 2) AS UtilizationPercent
FROM IPAM.Subnet
ORDER BY UtilizationPercent DESC

IPAM

subnet

utilization

IP management

Source:POLARISNOC· POLARISNOC Original

Unlock the full POLARISNOC hub

AI-powered SWQL generation, script management, CVE tracking, and verified solution intelligence.