Solved

asset details in sccm

Posted on 2014-12-02
1
134 Views
Last Modified: 2014-12-18
it has been installed certain video controllers in an enterprise . how to find number of computers using particular video controllers , using sccm 2012
0
Comment
Question by:techp
1 Comment
 
LVL 19

Accepted Solution

by:
Raheman M. Abdul earned 500 total points
ID: 40479304
There is a view in SQL which stores this information:

v_GS_VIDEO_CONTROLLER

Use this SQL query in criteria (SQL Query):

SELECT
  v_R_System.Name0,
  v_GS_VIDEO_CONTROLLER.Description0,
  v_GS_VIDEO_CONTROLLER.DeviceID0,
  v_GS_VIDEO_CONTROLLER.DriverVersion0,
  v_GS_VIDEO_CONTROLLER.VideoModeDescription0,
  v_GS_VIDEO_CONTROLLER.CurrentBitsPerPixel0,
  v_GS_VIDEO_CONTROLLER.AdapterRAM0,
  v_GS_VIDEO_CONTROLLER.VideoProcessor0
FROM
  v_GS_VIDEO_CONTROLLER
  inner join v_R_System on v_GS_VIDEO_CONTROLLER.ResourceID = v_R_System.ResourceID
0

Featured Post

Best Practices: Disaster Recovery Testing

Besides backup, any IT division should have a disaster recovery plan. You will find a few tips below relating to the development of such a plan and to what issues one should pay special attention in the course of backup planning.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

New Windows 7 Installations take days for Windows-Updates to show up and install. This can easily be fixed. I have finally decided to write an article because this seems to get asked several times a day lately. This Article and the Links apply to…
When you try to share a printer , you may receive one of the following error messages. Error message when you use the Add Printer Wizard to share a printer: Windows could not share your printer. Operation could not be completed (Error 0x000006…
This Micro Tutorial will teach you how to the overview of Microsoft Security Essentials. This is a free anti-virus software that guards your PC against viruses, spyware, worms, and other malicious software. This will be demonstrated using Windows…
With the advent of Windows 10, Microsoft is pushing a Get Windows 10 icon into the notification area (system tray) of qualifying computers. There are many reasons for wanting to remove this icon. This two-part Experts Exchange video Micro Tutorial s…

856 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question