Here’s a simple SQL query you can run against your ConfigMgr site database to return hardware hashes for all devices running a client OS:

1
2
3
4
5
6

SELECT S.Name0, B.SerialNumber0, M.DeviceHardwareData0
FROM v_R_System S JOIN v_GS_PC_BIOS B ON S.ResourceID = B.ResourceID
JOIN v_GS_MDM_DEVDETAIL_EXT01 M ON S.ResourceID = M.ResourceID
JOIN v_GS_OPERATING_SYSTEM OS ON S.ResourceID = OS.ResourceID
WHERE OS.ProductType0 = 1
ORDER BY S.Name0