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)