As I hit send I found one: SELECT DISTINCT
-- v_R_System.Name0 --, v_R_System.Client0 --, v_RA_System_IPAddresses.IP_Addresses0 v_RA_System_IPSubnets.IP_Subnets0 --, v_RA_System_SMSAssignedSites.SMS_Assigned_Sites0 FROM v_R_System LEFT OUTER JOIN v_RA_System_IPSubnets ON v_R_System.ResourceID = v_RA_System_IPSubnets.ResourceID LEFT OUTER JOIN v_RA_System_IPAddresses ON v_R_System.ResourceID = v_RA_System_IPAddresses.ResourceID LEFT OUTER JOIN v_RA_System_SMSAssignedSites ON v_R_System.ResourceID = v_RA_System_SMSAssignedSites.ResourceID WHERE (v_RA_System_SMSAssignedSites.SMS_Assigned_Sites0 IS NULL) AND (NOT (v_RA_System_IPAddresses.IP_Addresses0 IS NULL)) AND (v_R_System.Client0 IS NULL) AND (NOT (v_RA_System_IPSubnets.IP_Subnets0 IS NULL)) order by v_RA_System_IPSubnets.IP_Subnets0 http://danielssccmworld.blogspot.com/2010/01/sql-query-to-identify-missing.html From: Dzikowski, Michael Sent: Friday, July 12, 2013 2:23 PM To: [email protected] Subject: SQL query to find missing boundaries CM12 - Anyone have a SQL query to find missing boundaries? I found a few for SMS03 but nothing for CM12. Didn't want to reinvent the wheel if I didn't have to... SELECT SUB.IP_SUbnets0, COUNT(*) AS num_systems FROM v_R_System SYS RIGHT JOIN v_RA_System_IPSubnets SUB ON SYS.ResourceID = SUB.ResourceID JOIN v_FullcollectionMembership FCM ON SYS.ResourceID = FCM.ResourceID WHERE FCM.CollectionID = @CollectionID AND SUB.IP_Subnets0 NOT IN (SELECT IPSubnet FROM v_SiteRoamingBoundary_IPSubnet) GROUP BY SUB.IP_Subnets0 :( This view isn't in CM12: v_SiteRoamingBoundary_IPSubnet
