select CS.name0 as 'PC name', WS.LastHWScan as 'Last HW scan Date' from dbo.v_GS_COMPUTER_SYSTEM CS join dbo.v_GS_WORKSTATION_STATUS WS on CS.resourceID = WS.resourceID Where CS.resourceID not in (select R.resourceID from v_R_System R)