SMS 2003 Health Check Report: Machines missing a Site assignment
This report will show you all of the machines that are not assigned to a Site. This will allow you to figure out what boundaries are missing. Just change the collection ID to the collection you need the info from.
SELECT DISTINCT
Sys.Netbios_Name0
, Sys.Client0
, Sys.Operating_System_Name_and0
, v_RA_System_IPAddresses.IP_Addresses0
, v_RA_System_IPSubnets.IP_Subnets0
FROM v_R_System Sys INNER JOIN
v_FullCollectionMembership ON Sys.ResourceID = v_FullCollectionMembership.ResourceID INNER JOIN
v_RA_System_IPSubnets ON Sys.ResourceID = v_RA_System_IPSubnets.ResourceID INNER JOIN
v_RA_System_IPAddresses ON Sys.ResourceID = v_RA_System_IPAddresses.ResourceID
WHERE (v_FullCollectionMembership.CollectionID LIKE 'PAC00094')
ORDER BY Sys.Netbios_Name0