How to Query the SQL SCCM Database

Benoit LecoursSCCMLeave a Comment

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

How to use SCCM Cloud Management Gateway bulk registration token

Jonathan LefebvreSCCMLeave a Comment

One of the less-known benefits of the SCCM Cloud Management Gateway is the ability to install the Configuration Manager client to devices that are not connected locally and manage those devices without ever being on the internal network. For example DMZ servers. To do so, the client must be installed by a command line with an SCCM CMG Bulk Registration Token. In this post, we will show how to use the Bulk Registration Token to enroll DMZ servers to the Cloud Management Gateway. Requirements Configuration Manager version 2002 or higher Supported OS for Config Manager Cloud Management Gateway configured See … Read More

Create SCCM Windows 10 Collections for Feature Updates deployments

Benoit LecoursSCCMLeave a Comment

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

Windows 10 Feature Update deployment and Troubleshooting guide

Benoit LecoursSCCMLeave a Comment

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

Deploy Windows 10 21H1 Upgrade using SCCM

Benoit LecoursSCCMLeave a Comment

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

How to Enable and Monitor SCCM BranchCache

Benoit LecoursSCCMLeave a Comment

In this post, we will cover how to configure BranchCache on your SCCM server SCCM clients. It’s quite straight forward and using BranchCache can significantly optimize network bandwidth during deployment. BranchCache is a bandwidth-optimization feature introduce with Windows Server 2008 R2 and Windows 7. Each client uses a cache and acts as an alternate source for content that devices on its own network request. SCCM can use BranchCache to optimize network bandwidth during deployments. That way you decrease your request on your distribution points since your client act as the source for other clients. We won’t go into detail on … Read More

Deploy Windows 10 feature update using an SCCM Upgrade task sequence

Benoit LecoursSCCM4 Comments

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

Renew an Expired SCCM CMG Server Certificate

Benoit LecoursSCCMLeave a Comment

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

Quickly Disable SCCM Application Deployment

Benoit LecoursSCCM1 Comment

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

How to fix SCCM Enhanced HTTP prerequisite check during SCCM Site Upgrade

Benoit LecoursSCCM1 Comment

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