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

Leave a Reply