sccm 2012 SQL Query Get software updates that are downloaded but not in any software update group

Software update groups in Configmgr 2012 simplifies lot of administrative work ,which simply  contains list of updates (must be downloaded before you add any updates) merged to single deployment (can have multiple deployments for single software update group). Coming to the subject line, It is necessary (during cleanup activity) to find software updates that are…
SCCM Configmgr 2012 Troubleshoot Client software update issues

  One of most important and critically used feature in configuration manager 2012 is  Software updates .It is always challenging and import task for any sccm administrator to achieve good patch compliance success rate within the given SLA(Service level agreement).Patch compliance success rate is depends mainly on heath of your SCCM clients and some times…
SCCM Configmgr 2012 SSRS Patch Compliance Report Per Collection Per Update Group

In order to check the Patch compliance/Deployment status,there are some default reports ,one of the widely used report to know the compliance status for specific Update group on specific collection is –>Compliance 1-Overall Compliance. But the sub report /drill down/Linked report to view the list of non complaint computers do not provide you the required…
How to Uninstall Microsoft Office Security Updates using Configuration manager 2012

There are multiple posts online, discuss about how to uninstall Windows updates if something goes wrong with deployed patches, but I did not find anything related to Office security updates. In this post,I will discuss about, How to Uninstall Microsoft Office Security Updates using Configuration manager 2012. Background: With the release of December 2014 patches, A…
SCCM Configmgr 2012 SSRS Report Overall Compliance Per Update Group Per Collection will help to troubleshoot the clients

Over the past few weeks,I posted several patch Compliance reports because ,the default report do not meet the requirements what I need thus ,created custom reports that would help the team to analyze the patch Statistics and troubleshooting non compliant machines. Software update compliance report month Wise: http://eskonr.com/2013/11/sccm-configmgr-2012-patch-compliance-summary-report-month-wise/ Software update Compliance report month Wise for…

Trying to run the patch compliance report based on OU per Software update Group (For October 2014) ,report is available to download from http://eskonr.com/2014/11/sccm-configmgr-2012-patch-report-ou-based-compliance-status-per-update-group/ . Report shows some good success rate but still there are computers with unknown status .Unknown status means,these clients do not report anything to CM DB whether they required patches or…