This query will find PCs with DirectX 9C, 128MB of Video RAM, and 32bit per pixel.

SELECT  CS.Name0,
CS.UserName0,
DX.Version0,
DX.InstalledVersion0,
VC.AdapterRAM0,
VC.CurrentBitsPerPixel0
FROM
v_GS_COMPUTER_SYSTEM CS,
v_GS_DirectX0 DX,
v_GS_VIDEO_CONTROLLER VC
WHERE  DX.ResourceID = CS.ResourceID
AND VC.ResourceID = CS.ResourceID
AND VC.AdapterRAM0 >= 130000
AND VC.CurrentBitsPerPixel0>=32
AND DX.Version0 like ‘4.09%’

: