The last hardware scan is stored in the view v_GS_WORKSTATION_STATUS. When joined with either v_R_System_Valid or v_R_System, you can retrieve the last hardware scan for a computer.

The SQL code below will return the last hardware scan date for all computers in the ConfigMgr system.

SELECT        v_R_System_Valid.Netbios_Name0, v_GS_WORKSTATION_STATUS.LastHWScan
FROM            v_GS_WORKSTATION_STATUS INNER JOIN
                         v_R_System_Valid ON v_GS_WORKSTATION_STATUS.ResourceID = v_R_System_Valid.ResourceID

If you need to return the last hardware scan for a single computer you can use the query below to filter by the computer name. In this example, we filtered on computer ‘pc01’.

SELECT        v_R_System_Valid.Netbios_Name0, v_GS_WORKSTATION_STATUS.LastHWScan
FROM            v_GS_WORKSTATION_STATUS INNER JOIN
                         v_R_System_Valid ON v_GS_WORKSTATION_STATUS.ResourceID = v_R_System_Valid.ResourceID
WHERE        (v_R_System_Valid.Netbios_Name0 = N'pc01')