The Blog

In this blog post, we will show you a beginner’s guide on how to Query the SQL SCCM Database. The goal is not to make you an SQL DBA or expert. This is a guide to help you start to find the information you need in the SCCM Database. As you may know, all the information gathered by the SCCM agent is sent to an SQL Database. If you need to find a piece of specific information, you need to know in which SQL view to look for and most importantly the SQL language syntax. After reading this post, you’ll … Read More

One of the most common tasks in every Windows 10 Feature Update project is to create SCCM Windows 10 Collections in order to easily target your deployments. The goal is to target only a specific Windows version. For example let’s say that you have devices running Windows 10 1709, 1803 and 21H1, you may want to update only devices that are no longer supported which are 1709 and 1803 and leave your 21H1 alone. There are various ways to create your SCCM Windows 10 collections and this post will show you all the different methods. If you’re looking to create … Read More

This is rather an unusual post since we are used to writing and share our stuff publicly available for all. Once in a while we put lots of effort and writes guides that contain useful information on a specific topic. Since the incredible amount of work, we decide to release it as a payable guide, as others would write a book. Many of the topics covered in this Windows 10 Feature Update Troubleshooting guide are already available on our website while other topics go deeper in the paid guide. So there it is, a guide that contains 106 pages of … Read More

This blog post will cover all the tasks needed to deploy the new SCCM Windows 10 21H1 Upgrade. We will cover scenarios for new and existing computers that you may want to upgrade. Microsoft published the Windows 10 21H1feature update on VLSC on October 20th. This is the first Windows 10 feature update following the new naming convention. From now on, the new Windows 10 release will be called “Windows 10 version 21H1” (instead of “Windows 10 version 2004”). If you haven’t planned your Windows 7 migration to Windows 10, this post will help prepare your SCCM Server to deploy … Read More

As an SCCM administrator, when a new Windows 10 Feature Update would come out, you’d have to go to Microsoft website and download the latest ISO file and import it as a new Windows Operating System Upgrade Packages. Starting with SCCM 2103, you can now upgrade your SCCM client to Windows 10 by using feature update synchronized through the software update point. This simplifies the process and the size of downloaded content should also be smaller since an ESD file is smaller than a Wim file. In this post, we’ll show you how to deploy Windows 10 feature update using … Read More

The SCCM Cloud Management Gateway was one of the most installed system roles in the past months due to the COVID pandemic. Many organizations wanted to continue managing SCCM clients over the internet during this massive work from the home period. We’ve set up a lot of CMG and now we are getting more and more demand to replace an expired Server Certificate. In this post we’ll show you how to monitor an expired certificate and mostly shows you how to replace your server certificate with a valid one on your SCCM CMG Server. How to detect an Expired SCCM … Read More

Starting in SCCM 2103, you can disable an SCCM application deployment. This can be useful if you make an error when creating a deployment to a large number of users or devices and want to stop it quickly. It can be also useful if you simply want to pause an application deployment temporarily and start it back later. In this post, we’ll describe how to disable an SCCM Application deployment in SCCM v2103 and later. Prior to SCCM 2103, it was not possible to disable an SCCM application deployment but it was possible to disable : Task sequences Software update … Read More

When you’re doing an SCCM installation you have the choice to select HTTP or HTTPS client communication. Most SCCM Installations are installed with HTTP communication between the clients and the site server. We usually always install first using HTTP and then switch to HTTPS if needed by the organization. In this post, we’ll show you how to fix the Check if HTTPS or Enhanced HTTP is enabled for site during an SCCM Site Upgrade. You can also use this post to switch your site to Enhanced HTTP to stay supported after October 31st, 2022. Microsoft recommends using HTTPS communication for … Read More