SCCM generate reports to get device info from collection

Question

Dear experts,

We are in need of getting the Display Adapter info (that we can see from Device Manager) from a specific collection of computers. Is there any report option that we can use to get it within SCCM console or SQL server?

I tried to run following in SQL server but it gave me all the computer info within our domain and seems the Display Adapter info was not up to date?

Select    
SD.Name0 'E206*',  
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  

Answer 1

Hi,

You are using the right way to get the Display Adapter info.

For the Display Adapter info was not up to date, the hardware inventory will scan and update regularly. Also we could manually force a hardware inventory cycle.

We could use the Resource Explorer tool to view and troubleshoot for one computer.

To open the Resource Explorer, open the SCCM console and navigate to Assets and Compliance / Devices
Right click on any device and select Start then Resource Explorer

For more in-depth troubleshooting, please refer to the following link:

Troubleshooting Hardware Inventory in SCCM