—Single system required Patch’s report from SQL SELECT DISTINCT SYS.Name0 AS [Machine Name], UCS.Status AS [Patch Status Code], CASE WHEN UCS.Status = ‘2’ THEN ‘Applicable’ WHEN UCS.Status = ‘3’ THEN ‘Installed’ ELSE ” END AS ‘Patch Status’, UI.BulletinID, UI.ArticleID, UI.Title FROM v_R_System AS SYS LEFT OUTER JOIN v_Update_ComplianceStatusAll AS UCS ON SYS.ResourceID = UCS.ResourceID … Read more
run the below script to get the actual system state. this will help to report back actual compliance of patch level to SCCM Server Option ExplicitOn Error Resume Next Call RefreshServerComplianceState ‘ WScript.Echo “Finished” Sub RefreshServerComplianceState() ‘ Initialize the UpdatesStore variable. dim newCCMUpdatesStore ‘ Create the COM object. set newCCMUpdatesStore = CreateObject … Read more
Below is for a compliance report based on SQL declare @CollectID AS varchar(8)SET @CollectID= ‘SMS0001’ declare @CollectionListID AS varchar(90)SET @CollectionListID=’ScopeId_5432f432-F885-4A98-B666-5432134122/AuthList_F15C63EA-B655-4940-A250-654323fd432′ declare @CI_ID int; select @CI_ID=CI_ID from v_ConfigurationItems where CIType_ID=9 and CI_UniqueID=@CollectionListID declare @CollCount int, @NumClients int; select @CollCount = count(*), @NumClients=isnull(sum(cast(IsClient as int)), 0) from v_ClientCollectionMembers ccm where ccm.CollectionID=@CollectID select CollectionName=vc.Name, ‘Update List’=al.Title, Status=sn.StateName, … Read more
Read here on the WSUS Team Blog a nice article about troubleshooting WSUS. It references the site https://www.wsuswiki.com/. This site was created to provide a place for the WSUS community to share information about WSUS, including troubleshooting steps and best practices. The advantages that this site provides over public news groups include: Content on this … Read more
********************************************************************Title: Microsoft Security Bulletin Minor RevisionsIssued: June 30, 2010******************************************************************** Summary=======The following bulletins have undergone a minor revision increment.Please see the appropriate bulletin for more details. * MS10-041 – Important* MS10-040 – Important* MS10-038 – Important* MS09-040 – Important Bulletin Information:===================== * MS10-041 – Important – https://www.microsoft.com/technet/security/bulletin/ms10-041.mspx– Reason for Revision: V1.3 (June 30, 2010): Corrected the … Read more
Windows Update Explained Source as it is https://download.microsoft.com/download/a/9/4/a94af289-a798-4143-a3f8-77004f7c2fd3/Windows%20Update%20Explained.docx How the Software Update Service Works and Why it Matters to You Published: September 2008 For more information, please see https://www.microsoft.com/windows/downloads/windowsupdate/default.mspx Contents Introduction. 1 The Problem with Keeping Computers Up to Date. 1 Windows Update to the Rescue. 2 Windows Update for Individual Computers. 2 Windows … Read more
ConfigMgr sccm patching status based collections LastEnforcementMessageIDLastEnforcementMessageName 1 Enforcement started 3 Waiting for another installation to complete 6 General failure 8 Installing update 9 Pending system restart 10 Successfully installed update 11 Failed to install update 12 Downloading update 13 Downloaded update So in this example we would like to use the status of reboot … Read more
Security Patches MS10-032/KB979559 – Important (2000, XP, 2003, Vista, 7, 2008, 2008 R2): A trio of bugs in the Windows kernel can allow the use of malformed fonts to allow escalation of privileges attacks. It would be a bit hard to sneak a font onto the system without some sort of install privileges anyways, which … Read more
By default, software update files are downloaded from the Internet using the credentials of the logged-on user and the proxy settings configured for the user in Internet Explorer. The UpdDwnldCfg.exe utility is available on the Configuration Manager 2007 DVD and on every site server. It can be used to modify the server and account credentials … Read more
Superseding and Superseded Updates Typically, an update that supersedes other updates does one or more of the following: Enhances, improves, or adds to the fix provided by one or more previously released updates. Improves the efficiency of its update file package, which is installed on client computers if the update is approved for installation. For … Read more
