ConfigMgr(SCCM) report for subnets which are undefined Posted on January 19, 2012 by Eswar Koneti | 0 Comments | 270 Views 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