SQL Queries

SQL Query to list software updates deployment status for a specific BulletinID

July 31, 2015 // 0 Comments

This query will be useful if any specific Bulletin ID update causing issue on the machines and to figure out the deployed machines & other status to troubleshoot [...]

SQL Query to list all the systems with OS & BIOS Version details

July 20, 2015 // 2 Comments

Select comp.Name0 as [Machine Name], comp.Manufacturer0 as [Manufacturer], comp.Model0 as [Model], bios.SerialNumber0 as [Serial Number], bios.SMBIOSBIOSVersion0 as [BIOS [...]

SCCM 2012 – List of SQL queries

May 23, 2015 // 0 Comments

I have included a list of sql queries that we frequently use in SCCM 2012. 1. SCCM 2012 SQL query to get the machines name with required , not required & installed [...]