SCCM SQL Query to Build Uninstaller Batch File

I created the follow SQL query to create a batch file that uninstalls all known versions of a piece of software. Feel free to use and tweak as you see fit. You should build the query first to make sure you’re only identifying the GUIDs for software you really want to uninstall. You’ll need to …

SCCM SQL Query to Determine Installed Browsers

I recently wrote the following SQL Query to help identify which browsers are installed across our environment.  A straight Add/Remove Programs (v_AddRemovePrograms) query didn’t really return the data in such a way that made it easy to determine major version of Firefox or Chrome, and doesn’t include Internet Explorer since that’s not listed in Add/Remove …

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 …