Solved

asset details in sccm

Posted on 2014-12-02
1
139 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
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
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

Office 365 Training for IT Pros

Learn how to provision tenants, synchronize on-premise Active Directory, implement Single Sign-On, customize Office deployment, and protect your organization with eDiscovery and DLP policies.  Only from Platform Scholar.

Question has a verified solution.

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

Suggested Solutions

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…
OfficeMate Freezes on login or does not load after login credentials are input.
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.
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…

734 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