ConfigMgr(SCCM) report for subnets which are undefined
SELECT COUNT(distinct ResourceID) as [Count], IP_Subnets0 as Subnet FROM dbo.v_RA_System_IPSubnets WHERE IP_Subnets0 NOT IN (SELECT IPSubnet FROM dbo.v_SiteRoamingBoundary_IPSubnet) GROUP BY IP_Subnets0 ORDER BY IP_Subnets0