Find all PC with Vista Video Requirements

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%’

:

Leave a Reply

Your email address will not be published. Required fields are marked *