Wednesday 15 July 2015

SCCM Report to check Video card 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

0 commenti:

Post a Comment

Give me you feedback!