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
