In-depth guides for Microsoft System Center products including SCCM/ConfigMgr, SCOM, SCVMM, and Orchestrator. Written for IT professionals.
One of the great functions of Configuration Manager 2012 is the Software Catalog. This allows your users to become self-sufficient and stops them from pestering the IT Department every time they want the latest version of Java Client installed! So, apart from all your custom tools and programs, what should you have in your catalogue … Read more
With the recent release of Dell’s new laptop ranges, Configuration Manager OSD professionals face new challenges. We recently had issues with some of Dell’s new laptops not picking up the network after PXE boot even though we had gone through the normal process of adding the network card drivers to the boot image and ensuring … Read more
A free utility to get the WMI information from a computer. This is a great tool for SCCM administrators.
If you are using Configuration Manager, you will be aware that you can create a number of custom reports using the SQL data and SSRS to produce the reports. The best way to start to create a custom report is to ensure that you get your SQL query correct first. We have written hundreds of … Read more
We are asked a lot both in a professional context and through this website about how first line techs can use the remote control functionality that Configuration Manager gives us without giving out access to the full Configuration Manager Console. Well, the answer is fairly simple, if your client machines have the Configuration Manager client … Read more
If you are using SCCM for Operating System Deployment (OSD) – which is one of the main functions of the system so we will assume that you are – then you may want to monitor the process of your task sequences. To do this, you should go into your Configuration Manager Console and click on … Read more
An excellent tool to use alongside Configuration Manager is SCCM Client Center Tool. We have been using it for years and it also makes a great tool to hand out to helpdesk staff if you do not want them to have access to the full Configuration Manager Console. The tool has many functions but the … Read more
Introduction If you are trying to use any remote tools like sysinternals against Windows Vista, 7 or 8.1 machines then you need to have remote UAC elevation privileges to enable you to carry out changes on the machine you are trying to amend. However, you may find that you are still having problems with connecting … Read more
This is a SQL query for your SCCM database or you can use it to create a report using SSRS. For this work, you must ensure that you have the Logical Disk class enabled in the hardware inventory settings. This will give you the following information: Computer Name Disk Description Drive Letter Volume Name File … Read more
This query will give you the amount of ConfigMgr clients that are installed on machines per AD site. This can be run on your Configuration Manager SQL database or you can use it to build a custom report using SSRS. More Queries Our full range of SQL and WQL Collection queries are available here. Feedback If … Read more
This is a very simple SQL query but still very useful and will give you a lot of information about your Configuration Manager hierarchy. select * from sites Run this on your Configuration Manager database server or you can use it to create a custom report using SSRS. More Queries Our full range of SQL … Read more
If you want to retrieve the site roles from your ConfigMgr environment, you can use the following SQL query: select SiteCode, RoleName, ServerName from SysResList More Queries Our full range of SQL and WQL Collection queries are available here. Feedback If you have any questions or feedback about this post, or if you would like us … Read more