We had seen a few posts around the internet where people are asking the differences between the various Add_Remove_Programs data within the System Center Configuration Manager database. So we thought we would post a quick reference here to confirm which table of data means what. There are five different tables of data available to you … Read more
If you are looking for an SQL query to use against your System Center Configuration Manager database to give you the ability to report on server CPU information, this is the query for you! You can use the below to get various information on the CPU or you can use SELECT * to bring back … Read more
If you have been using System Center Endpoint Protection and you now want to move away from it, you will need to carry out an uninstall of the software. This can be very easily carried out either through a manual process of uninstalling using the Programs and Features within the Windows Control Panel or if … Read more
Some time ago there was a bug within SCCM where when you deployed an application, you had to change the deployment date back a day to make it work. This seemed to have been fixed when moving over to current branch but this issue has raised it’s head again. This will cause clients trying to … Read more
This guide assumes that you use Microsoft Deployment Toolkit (MDT build 8443) or Microsoft System Center Configuration Manager (SCCM) capturing Windows. You capture a task sequence, and the capture computer does not have Internet access. When the task sequence is running and the computer is checking for updates (pre-application installation), the installation freezes for 2 … Read more
If you are using Configuration Manager, you will be aware that you can create a number of custom reports using the SCCM SQL data and SSRS to produce the reports. The best way to start creating a custom report is to ensure that you get your SQL query correct first. We have written hundreds of … Read more
This is a quick reference guide to the Chassis Type values that are pulled from machine when using SCCM. 1 = ‘Other’ 2 = ‘Unknown’ 3 = ‘Desktop’ 4 = ‘Low Profile Desktop’ 5 = ‘Pizza Box’ 6 = ‘Mini Tower’ 7 = ‘Tower’ 8 = ‘Portable’ 9 = ‘Laptop’ 10 = ‘Notebook’ 11 = … Read more
When you create a new System Center Orchestrator Runbook and you have checked it in ready to use, you may not see it in systems that will want to use it, like Configuration Manager, Microsoft Deployment Toolkit or Service Manager. This is due to authorisation cache not updating and as so, not showing the newly … Read more
If you have started a task sequence in Configuration Manager and you hit a problem, the last thing you want to do is to have to go through the reboot process back into Windows PE. So, if you want to just restart the task sequence without rebooting, carry out the following steps: Press F8 to … Read more
If you are using WIM files for Operating System Deployments (OSD) you may be injecting Windows Updates into the WIM to keep them up to date. If you are doing this, you may run into errors when processing through the updates like this: This is because the mounted WIM thinks that there are pending updates. … Read more
If you are using System Center Orchestrator (SCORCH) Runbooks then you may have run into issues where the database is increasing in size due to the large amount of log files being created. This typically occurs when monitoring event logs on servers amongst some other runbook options in SCORCH. If you want to check how … Read more
If you are looking to extract an icon from your Programs and Features list to use in any programs, documentation or systems like Configuration Manager, then you can use this guide to do that. The icons are actually stored in the C:WindowsInstaller folder but to ensure that you get the correct one, you will need … Read more