IPAM Subnets Near Exhaustion

What this query does

Alert on subnets with fewer than 10 available IP addresses remaining

SWQL Query

SELECT FriendlyName, Address, CIDR, TotalCount,
       UsedCount, AvailableCount,
       ROUND(UsedCount * 100.0 / NULLIF(TotalCount, 0), 2) AS UtilizationPercent
FROM IPAM.Subnet
WHERE AvailableCount < 10 AND TotalCount > 0
ORDER BY AvailableCount ASC

IPAM

exhaustion

capacity

critical

Source:POLARISNOC· POLARISNOC Original

Unlock the full POLARISNOC hub

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