SCCM SQL Query : To Gather Video Card Memory Information

Select    

SD.Name0 ‘Machine Name’,

VC.Name0 ‘Video Card’,

Convert(VarChar, VC.AdapterRam0 / 1024) + ‘ MB’

From v_R_System SD

Join v_Gs_Video_Controller VC on SD.ResourceID = VC.ResourceID

Where VC.Name0 <> ‘ConfigMgr Remote Control Driver’

Order By SD.Name0