configmgr(SCCM) report for mismatch of computers in Configmr

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