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

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

Step-by-Step SCCM 2103 Upgrade Guide

Benoit LecoursSCCMLeave a Comment

Microsoft has released a first SCCM version for 2021. SCCM 2103 has been released on April 5th, 2021. Don’t forget SCCM has a new branding since 1910 – now called Microsoft Endpoint Configuration Manager (MEMCM). This post is a complete step-by-step SCCM 2103 upgrade guide, meaning that if you want to upgrade your existing SCCM/MEMCM installation to the latest SCCM/MEMCM updates, this post is for you. If you’re looking for a comprehensive SCCM installation guide to build a new server, refer to our blog series which covers it all. You won’t be able to install SCCM 2103 if you are running … Read More