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 manager 2012. There was a discussion recently on the Configmgr forum email list about status message document for CM12 R2 CU3 and Sherry Kissinger share the documentation to the group which am posting it here for rest of the world. Saud from Microsoft posted PowerShell…
Author: Eswar Koneti
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 Bulletin ID (MS14-082- KB2726958 )related to Microsoft Office 2013 caused the macros in Excel 2010 spreadsheets stop working /breaks the macros to work. More information about this issue was discussed on the TechNet forum https://social.technet.microsoft.com/Forums/en-US/17254fab-9ecd-49e7-bab7-f76906167d4a/office-2013-update-kb-2726958-problem?forum=officeitpro When user tries to execute the Excel that has Macros/VBA…
New Year (2015) around the corner and this will be the last post for this year (2014).A big Thanks to all my blog readers who followed me and supports me in writing useful blogs. I wish that You may not only change the date of the calendar, but also your focus, commitments and actions for a more fruitful year ahead. To kick off the new year, I’d like to share with you data on my blog’s activity in 2014 ,how did blogging went with posts,number of visitors and some interesting count. Crunchy numbers: The Louvre Museum has 8.5 million visitors…
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 and uta.requireapproval=1 order by app.displayname fn_ListApplicationCIs(1033) contains other important information ,so you can add all of them here if you need. To know what info ,fn_ListApplicationCIs(1033) has ,just run select top 5 * From fn_ListApplicationCIs(1033) ,gives you the first 5 rows . To know…
I got a request asking for "is there a way to find out the VM’s that are configured on each Hyper-V server ,if so ,how to I generate a report with its Base/Host Name and its VMS running on it with its possible VM setting info ". hmm..Getting VM’s that are running on Hyper-V and its VM properties ? okay,if the VMs are running on hyper-V ,then these should be registered in WMI Name space . I then Started digging to find some information about Hyper-V and its stored location in WMI . Couple of blogs that I come across…
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 Specific Collection:http://eskonr.com/2014/09/configmgr-2012-summary-of-patch-compliance-status-report-month-wise-for-specific-collection-ssrs-report/ Software update compliance report Per Update Group Per OU: http://eskonr.com/2014/11/sccm-configmgr-2012-patch-report-ou-based-compliance-status-per-update-group/ Software Update Scan Results: http://eskonr.com/2014/10/sccm-configmgr-2012-report-get-the-status-of-software-update-scan-results/ Recently ,while running the Default patch compliance report Compliance 1 - Overall compliance from category called Software Updates - A Compliance ,it gives me the count of clients…
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 not required ,no compliance information at all. I pick one computer randomly and start looking at Software Update logs on the client side . The software update logs that helps to identify the scan issues are WUAHandler.log (CCM\logs),windowsupdate.log(%Windir%) WUAHandler.log log shows ,client started to search…
Question asked in the forum ,if it is possible to get patch compliance /deployment status report (installed,required,not applicable and unknown) based on OU for specific software update group instead of collection. Long ago,I posted patch compliance report for specific collection month wise http://eskonr.com/2014/09/configmgr-2012-summary-of-patch-compliance-status-report-month-wise-for-specific-collection-ssrs-report/ but it gives you overall compliance for each month for past 12 months. If you are having multiple OU's and if you have asked to get the patch compliance status based on the OU Wise per Update Group ,how would you get ? The default report doesn't deal with such a requirement and you are required to…