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)
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)