WSUS 3.0 Sp2 After two critical Patches
http://support.microsoft.com/kb/2720211 http://support.microsoft.com/kb/2734608
Some useful SCCM Patch Management – Custom Reports
http://pleasepressanykey.blogspot.com/2010/08/sccm-patchmgmt-custom-reports.html
Patch Supersedence Report from SQL Query
select cir.FromCIID [New CI], info.BulletinID [New BulletinID], info.ArticleID [New ArticleID], info.Title [New Title], info.InfoURL [New InfoURL], info.DatePosted [New DatePosted], cir.ToCIID […]
A consolidated Report for Patch Deployments
to get the consolidated Report for all your deployments / instead of depending on dashboard you can view this PVT […]
Software Updates Status messages
Software Updates Status messages are three major types and these are States for deployments States for software updates Scan […]
SCCM State ID’s from Client end error (Focused on Patching )
TopicType StateID StateName StateDescription 300 0 Compliance state unknown Compliance state unknown 300 1 Compliant Compliant 300 2 Non-compliant Non-compliant […]
Checking Patch Statuses through WMI
Normally the optimal and quickest way to determine if a patch has definitely been installed on a system is to […]
Required Patches based on collection ID
SELECT DISTINCT TOP (100) PERCENT SYS.Name0 AS [Machine Name], UCS.Status AS [Patch Status Code], CASE WHEN UCS.Status = […]