SCCM Configmgr 2012 R2 SP1 download content from Microsoft updates causing client stuck at downloading policies

Since few days ,have been working on case with Microsoft on client issue wherein ,some clients stuck at downloading the policies/jobs and remain in Queued state without any reason and they never get deployments. When you deploy the software update group to collection ,you will have to put a special attention to configuration setting in…
SCCM Configmgr software update scan failed OnSearchComplete – Failed to end search job Error 0x80072ee2

Other day,I was looking at the client health dashboard which I published long ago https://gallery.technet.microsoft.com/SCCM-Configmgr-2012-SSRS-2863c240 . From the dashboard report ,noticed that couple of clients were having software update scan issues . If client fail to perform success software update scan ,it is out of patching window and client will never send or receive any…
SCCM Configmgr SQL query to find Top X missing updates for specific collection for specific update group

Since few days ,I am working on a customized Software update compliance dashboard report with some Pie charts for management to see how the patch compliance progress for each Business Unit (I say business unit means for each country). Management are interested to see the overall patch compliance summary for each country (focused on servers…
SCCM Configmgr how to clean ccmcache content older than x days using compliance settings

A friend of mine (you know who you are) asked help (kind of) ,how to clean up the content inside ccmcache folder in better way instead of using script to deploy it as application/package/task sequence . I would recommended to use compliance settings(configuration item/configuration baseline) to deploy the script on schedule basis (monthly once or…
Download SCCM Configmgr CB 1606 SQL views documentation

Microsoft released new version of SCCM Configmgr Current Branch 1606 (YY MM) with lot of new features and improvements to the existing features. You can install this update via in-console update. With this new update ,there are also couple of newly added SQL views compared to its previous update (1602) which will help us to…
SCCM Configmgr Current Branch 1606 is now available

Yesterday (22-July-2016) Microsoft released new version of SCCM Configmgr Current Branch 1606 (YY MM) with lot of new features and improvements to the existing features. You can install this update via in-console update. You can update to latest version of SCCM Configmgr Current branch 1606 either from Configmgr 1511 or 1602 using in-console update. This…
SCCM Configmgr Get the Update Compliance Status for multiple Update groups against Multiple collections using SQL query without reporting

Recently ,we had an issue with SCCM Configmgr Reporting services role (Remote SQL sitting on VM was crashed ,blog post coming soon ) and we were unable to generate reports mainly for the Software update compliance status that happens every month. This post is about ,how to check the software update compliance status for the…