You will need to find the Vendor ID or Device ID from within Device Manager on a managed computer (Hardware Ids drop-down under Details tab when viewing the properties of a device.)
For example, DEV_1984 is my High Definition Audio Device on an Optiplex 755.
SELECT sd._ResourceGuid
FROM Inv_HW_Sound_Device sd
WHERE sd.[Device Id] LIKE '%DEV_1984%'
By the way, if you're ever viewing information in the Resource Manager, the name of the data class in SQL is easy to figure out. If you open Resource Manager, then choose View > Inventory, then expand Inventory > Hardware > Sound Device, you know that your data class will be called Inv_HW_Sound_Device. Software condenses to SW, Operating System to OS.
Does this help?