Author: Eswar Koneti

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 always nice to know the figure on the content ,content success status. Download the SSRS Report(.RDL) from TechNet Gallary,Upload to your SSRS Report,change the Database source.

Read More

I was troubleshooting configmgr 2012 R2 client,the other day ,I found below error from ccmsetup.log MSI: Setup was unable to compile the file AppSynclet_Local.mof The error code is 80041002 Error code 80041002 says ,Not found.Source: Windows Management (WMI) I tried compiling the AppSynclet_Local.mof (C:\windows\ccm) file, it throw error saying,syntax errors in line 22. This pushed me to cop MOF file from working PC if that make any difference but it did not work. if you look into the mof file,it is trying to operate on \\Root\\CCM\ namespace ,which do not exist on the problem client. I suspected this is…

Read More

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 may go wrong even though sccm client is healthy (able to receive applications/packages and performing inventory except patches). I have created lot of SSRS reports on software update compliance out of many,one of the widely used report is get the patch compliance status of software…

Read More

This blog post is quick one to check ,patch (BulletinID) is member of what software update package.You may be wondering why do you need to check since clients can connect to the DP and download the patches as long as these patches are available on the DP. Here is short background of it. Background :I was looking at patches released during February 2015 as part of patching process in Configuration manager 2012 console at customer.Configmgr site used by 2 different departments with different procedures (one dept manage X  number of  Clients and other manages Y number of clients) within the…

Read More

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 directly apply CU4 on Configmgr 2012 R2 . To check if CU4 installed ,you can check the Admin console version in the About System Center Configuration Manager dialog box and version should be 5.0.7958.1501. You can also check the registry key if CU level is…

Read More

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 far(without admin rights). Recently ,due to some project requirement,they need to have full permissions to specific folders (C: \program files\matrix\3D or what ever) to modify some files and settings to get the application working  . To grant full permissions or required permissions to specific folders…

Read More

Recently , I worked on MS Office upgrade project to 2013 and before I take any action on this,I need to identify /get count of all MS Office Versions installed on the computers that are managed by Configuration manager 2012. There is no default Configmgr report that provide you this information ,so you must create custom SSRS Report .I started working on Custom SSRS Report to get count of office versions .During my search results ,found a blog post from TechNet that provide you the count of MS Office Versions only but not what specific edition in each version…

Read More

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 information for troubleshooting clients like its last hardware inventory, os, last logged on user, last loggedon timestamp etc.For this reason,I created custom SSRS Report that will help me to get some nice statistics and extra client information . Last month I did post about Software…

Read More