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…
Author: Eswar Koneti
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…
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…
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…
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…