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)
SCCM Report Get list of devices with pending reboot in a collection with different states
SCCM ConfigMgr Compliance status of client for multiple software update groups
How to install Data warehouse service point in SCCM Configmgr and get the historical data
Troubleshooting Client that has NO SCCM Agent in Console BUT still receive deployments