SCCM Query to Get Screen Resolutions

I wrote the following queries to find the video resolutions used by clients reporting into SCCM. They currently only look at Windows Workstations 6.x (excludes servers, and also anything older than Windows Vista or whatever v7 ends up being), and only those who have submitted a hardware inventory in the last 30 days. Feel free to steal & modify.

This query lists every card with resolution:

This query sums up the resolutions reported in the previous query:


Leave a Reply

This site uses Akismet to reduce spam. Learn how your comment data is processed.