SQL query to find Orphaned Distribution Point References
Below query can be used to identify if there are any orphaned rows left in the database for a DP that is no longer in the environment. There could be orphaned rows if the DP [...]
SQL queries
SQL Queries for Packages Distribution status on Distribution Points
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
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 [...]
SCCM 2012 – List of SQL queries
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 [...]
