Patching Related End to end – Collections and reports :-

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′ […]


Collections based on software updates deployment status in Configuration Manager

ConfigMgr sccm patching status based collections LastEnforcementMessageIDLastEnforcementMessageName 1        Enforcement started    3        Waiting for another installation to complete 6    General failure […]