Question from configmgr technet forum : Need SQL Query for disk space <500 MB (windows drive) for servers from most recent 10 records. Whenever there is any such request on reporting ,i always make use of SQL views documentation https://gallery.technet.microsoft.com/SCCM-Configmgr-2012-R2-SQL-5fefdd3b. This excel sheet contains list of all SQL view+some functions that would help you to identify the information stored in where so it would be easier for you pick the right SQL views to join with other views to prepare your query. History of disk space information is stored in v_HS_LOGICAL_DISK ,where as the current inventory information is stored in…
Author: Eswar Koneti
Hello Guys, For all those,who are running Smartphone's,you can now browse my website(www.eskonr.com) as an application(.apk) on your android device without using any browser(like Explorer,Firefox). For now,this application is not made available as offline to browse ,but may be near future ,can be done. Download the application available from here . IF you want to know ,how to install Android app(.apk) outside of google play store,follow the link here
working on some Inventory Customizations.I need to get some registry information into Configmgr Database.For this,I have to do MOF changes to both configuration.mof and hardware inventory from Default Client settings. How to get the MOF Syntax ? I have used mark’s Regkey2mof tool .This tool will provide you both configuration.mof and clientsettings mof . with the syntax,I got from the tool, done the changes in both the places (configuration.mof and default client settings—hardware inventory and import the mof file) Monitor the log dataldr.log on the server,if the mof files are complied successfully or not. Initiated machine policy retrieval on the…
Another Configmgr 2012 SSRS Report that brings Client Health Summary.This time,it will be a dashboard instead normal SSRS report.Dashboard is nice way to display multiple reports into one report.Dashboard reports are very helpful if you want to monitor the information about client health (mainly the Count),client hardware/software,operating system,IE versions etc.You can also link all these individual reports to get list of computers with its hardware information. I created Dashboard report to get client health summary into one Page instead browsing to multiple reports when required. This report consists of several individual reports listed below: 1.Total Computers 2.Client Installed Vs Active…
Configmgr 2012 allow admins to Configure Custom Client Settings at collection level to control the behavior and functionality of the Configmgr 2012 clients. You can create as many number of Custom Client Device/User settings (9999) ,which you can apply onto collections(Device/User). What happens if client is member of multiple collections that have client settings ? All the Custom Client settings that you create are chosen with the priority. Higher the priority(1) will take over the settings with lower priority(10000). If you are going to have multiple client agent settings,focus attention else you will see undesired results. By Default,Configmgr will Configure default…
Background: I had a requirement to not allow others except Configmgr admins to deny access to Configmgr 2012 Console, also to Configmgr SQL Database access (this can be done by revoking access from SSRS_Read Group.If the users are part of this group,they can install SQL and try to connect to configmgr database remotely to run queries).How do we provide access to service Desk /Others to access reports In General? Create AD security group,add this group to SMS Admins (to get access to the SMS Provider) on Configmgr server,Create new Security role in Configmgr by providing Run report permissions and add…
This Blog post brings up some basics about Configmgr Client Actions, what they are and what each action does. After you have installed the Configuration manager Client on computers, Client will get install (refer log ccmsetup.log for more information ) with exit code 0 and It takes little while ,to register the client in Configuration manager Database, assigned to Site, load policies etc. After a while, you can open Configuration manager applet from Control panel (shortcut to use: control smscfgrc from Run Command), go to Actions, you should see more than 2 actions, if not ,as usual start troubleshooting by…
We have been seeing many hotfixes and Cumulative updates for configmgr 2012 product .For each hotfix /CU level,the client version will get change. As you test and deploy these hotfixes /CU's in your environment ,you are also required to maintain the environment both clients and server client to the same level as your site running. Being configmgr admin,you are responsible to maintain clients levels same as that of your site server.i created SSRS Report to list down all the client versions, Description of Version name and its count. I have created nice SSRS Report to list the count of configmgr…