Find all PCs with out any v_gs_Computer_System data
Use this query to find all PCs that don't have any data within the v_GS_* views. Right John... :-)
select
R.Netbios_Name0,
R.*
from
v_R_System r
where
R.ResourceID not in (select
cs.resourceId
from
v_gs_computer_system cs)
Order by
R.Netbios_Name0