SQL Queries

SQL Queries for Packages Distribution status on Distribution Points

October 15, 2017 // 2 Comments

All Failed Packages/DPs : SELECT distinct A.DPName, A.PackageID, B.Name, A.MessageState, A.LastStatusTime, A.SiteCode FROM vSMS_DPStatusDetails A JOIN SMSPackages_All B ON [...]

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

July 31, 2015 // 1 Comment

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 // 3 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 // 5 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 [...]