- Specifying here offline discussion information regarding this case by ssv1984 request.
This information can be found in "Inventory Solution" dataclasses/views.
At least there are "Inv_HW_Sound_Device" and "Inv_HW_Video_Controller_Windows" sql tables
here is simple query to see which asset has inventory data for video or audio hw
SELECT DISTINCT
vc.Guid,
vc.Name,
vc.Domain,
vc.[User],
vc.[OS Name],
vc.[IP Address],
vc.IsManaged,
sd.[Device ID],
vd.[Device ID]
FROM vComputerAnyStatus vc
JOIN Inv_HW_Sound_Device sd
ON vc.Guid = sd._ResourceGuid
JOIN Inv_HW_Video_Controller_Windows vd
ON vc.Guid = vd._ResourceGuid
WHERE
sd.[Device ID] != ''
OR vd.[Device ID] != ''
ORDER BY vc.Name
ASC
Query shows resources which have audio or video hw data. Pay attention that some of resources might have Inventory Agent (or without Inventory Agent) installed but haven't done an inventory scan so they will not be shown in this query output.