Solved

asset details in sccm

Posted on 2014-12-02
1
132 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

Optimizing Cloud Backup for Low Bandwidth

With cloud storage prices going down a growing number of SMBs start to use it for backup storage. Unfortunately, business data volume rarely fits the average Internet speed. This article provides an overview of main Internet speed challenges and reveals backup best practices.

Question has a verified solution.

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

Suggested Solutions

The recent Microsoft changes on update philosophy for Windows pre-10 and their impact on existing WSUS implementations.
When you try to extract and to view the contents of a Microsoft Update Standalone Package (MSU) for Windows Vista, you cannot extract the files from the MSU. Here we are going to explain how to extract those hotfix details without using any third pa…
This Micro Tutorial will give you a introduction in two parts how to utilize Windows Live Movie Maker to its maximum capability. This will be demonstrated using Windows Live Movie Maker on Windows 7 operating system.
This Micro Tutorial will give you a introduction in two parts how to utilize Windows Live Movie Maker to its maximum editing capability. This will be demonstrated using Windows Live Movie Maker on Windows 7 operating system.

776 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