select * from v_R_System sys
where sys.ResourceId not in (
Select resourceID from v_gs_computer_system)
and Client0 = 1