List of PCs not listed v_R_System

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)

Leave a Reply

Your email address will not be published. Required fields are marked *