SCCM 2012 SSRS Report Content Summary With distribution Status

  This week SSRS report is about knowing the count of applications,packages,driver packages,SUP packages,boot images,OS images,Virtual packages etc into Nice Pie Chart also know about the Distribution status of each package . This report has 2 queries inside SSRS 1) for Pie Chart and 2)list the Distribution Status for each package with sorting order. Its…
SCCM Configmgr Troubleshooting 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 things…
How to Upgrade Clients to SCCM 2012 R2 CU4

It has been almost month for now ,since the release of Configmgr 2012 R2 CU4.To know more about what CU4 includes,you can refer the KB3026739 article http://support.microsoft.com/kb/3026739. Installation of Configmgr 2014 CU4 is similar to installation of previous Cumulative updates and it is straight forward. If you miss to install the Previous Cumulative updates,you can…
SCCM 2012 Deployment How to change security permissions to specific folder using icacls with Application Detection rules

  Problem Description: Users (AD Security Group called: eskonr\domain Users) from specific project in the organization do not have admin privileges on their computers (don’t ask why)  .I have an application (Matrix ) which is installed using Configuration manager 2012 and users are using this application for their daily routine activities without any issues so…
Download SCCM Configmgr 2012 R2 CU3 Status messages documentation

Status messages generated by Configmgr Components report its activity and problems when occurs .These status messages are primarily used to indicate the health of Configmgr 2012 Components . While ago, John Nelson posted blog about ,Status Messages Documentation for Configmgr 2007 SP2 available here but after that ,haven't found any status message documentation for Configuration…

This is quick post on how to get list of Applications that are deployed to users requires approval . more Details ,refer https://social.technet.microsoft.com/Forums/en-US/644ff540-4eb0-49b6-97f4-094cada74c6a/viewing-deployments-that-require-approval?forum=configmanagerapps Run the following SQL query to know apps that require Approval. select app.displayname [Application Name],app.manufacturer [Manufacturer],app.numberofdeviceswithapp [No of Devices with this App],app.numberofuserswithrequest [No of Requests] from fn_ListApplicationCIs(1033) app, v_UserTargetedApps uta where uta.ci_id=app.ci_id…

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…
SCCM Configmgr 2012 Software Update Scan error Group policy settings were overwritten by a higher authority Error Code 0x87d00692

Started working with New Customer since few weeks ago ,running Configmgr 2012 R2 CU1 ,yet to upgrade to Latest CU . since few days,I have been running lot of SQL Queries ,reports checking the SCCM client health and analyzing the existing setup for some improvements. For everything what ever you do in SCCM,the first and…