How to upgrade SCCM SQL version

Jonathan LefebvreSCCM, SQL5 Comments

SQL Server is obviously a key component to take care of, for a healthy SCCM infrastructure. While SCCM supports a wide variety of SQL Server versions, keeping it up to date may be a good idea to avoid getting out of support. In this post, we will detail how to upgrade SCCM SQL 2014 to SQL 2017. SQL 2019 is available for a couple of weeks, but it’s still not listed as supported in the SCCM documentation. If you’re looking to install SQL 2017 from scratch, jump to our post on this topic. Upgrade SCCM SQL version Requirements Current SQL … Read More

Deploy Edge Chromium using SCCM 1910+ or Intune

Benoit LecoursSCCM30 Comments

Microsoft announced that the general availability of the new Microsoft Edge Chromium on January 15, 2020. SCCM and Intune are already ready for this launch as both products include a feature to deploy and manage the new browser. This blog post will describe how to deploy the new browser to your computer using both SCCM and Intune. You can download and install Edge Chromium from the Microsoft website. It’s available for Windows, macOS, iOS and Android. If you need to manage this in Enterprise, continue to read our post. SCCM Intune Edge Chromium Requirements The first step to deploy Edge … Read More

Create SCCM Collections Based on Active Directory OU

Benoit LecoursSCCM6 Comments

Many organizations still use Active Directory groups or Organisational Unit to do operational tasks in SCCM. Sometimes, they use OU to classify their devices or users. Many will tell that it’s not the most efficient way to do it but it’s effective for some. This blog post will describe how to do a script to create SCCM Collections based on AD OU. We’ve seen many Active Directory having thousand of different Organisational Units and been asked to create SCCM collection based on those Active Directory OU. This has to be a tedious and boring task. PowerShell to the rescue! I … Read More

Step-by-Step SCCM 1910 Upgrade Guide

Benoit LecoursSCCM10 Comments

Microsoft has released a third SCCM version for 2019. This is the first version of the new Microsoft Endpoint Configuration Manager Branding! You can begin upgrading your SCCM Current Branch environment to the latest SCCM 1910 release. If you want to install the latest updates, this post is a complete step-by-step SCCM 1910 upgrade guide. If you’re looking for a comprehensive SCCM installation guide, see our blog series which covers it all. You won’t be able to install SCCM 1910 if you are running SCCM 2012, 1902 is the latest baseline version. This means that if you’re downloading the source from … Read More

SCCM Windows 7 to Windows 10 1909 Upgrade Guide

Benoit LecoursSCCM15 Comments

Windows 7 will be out of support in less than 2 months. You’ll have to pay extended support after January 14th, 2020 to stay supported. Microsoft published the Windows 10 1909 feature update (aka Windows 10 November 2019 Update), in VLSC on November 15th, 2019. If you haven’t planned your Windows 7 migration to Windows 10, this post will help prepare your SCCM Server to deploy it. You may also need to deploy Windows 1909 to your Windows 10 computer to stay supported or to benefits from the new features. Before deploying a new Windows 10 feature upgrade, you need to … Read More

Boundary Management using SCCM Boundary Report

Benoit LecoursSCCM5 Comments

Boundaries and boundary groups in Microsoft Endpoint Configuration Manager play an important role in site assignment, policies , content download etc. The client is unusable unless site assignment, boundaries and boundary groups are configured. It’s the basis you need to understand in an SCCM implementation. Configured incorrectly, your clients may get content from the wrong site system. We created a set of reports to ease your SCCM boundary management. If you’re used to SCCM boundary and their definitions, you can skip the article and jump to the SCCM Boundary Report section. You can create boundaries with different types as listed below: … Read More

Create a Windows 10 Single-App kiosk device using Intune and AutoPilot

Benoit LecoursSCCM4 Comments

In this blog post, we’ll configure a Windows 10 Kiosk Mode in Single-App using Intune and Autopilot as the deployment method. We’ll also make sure that the user doesn’t have to log using the AutoLogin function. Our kiosk will be displaying a webpage to be used in a public area. Some desktop such a public device can be “locked down” to show specifics applications only. Windows 10 Kiosk mode offers 2 different kiosk experiences : Single-app kiosk: Runs a single app (UWP) in fullscreen on top of the lock screen. Users using the kiosk can see only that app. If … Read More

SCCM SQL 2017 Install Guide

Jonathan LefebvreSCCMLeave a Comment

In the first part of this SCCM Current Branch blog series, we planned our hierarchy, prepared our Server and Active Directory. In part 2, We will go through the complete SCCM SQL 2017 Install Guide to install and configure SQL before installing SCCM Current Branch 1806 or higher. Click the following link to see all supported SQL versions. For our post, we will install SQL 2017 locally on the same server where the Primary Site will be installed. SCCM SQL 2017 Install Guide Execute Setup.exe from the SQL installation media, select New SQL server stand-alone installation Provide the product key and click … Read More

List of SCCM Must Have Tools and blog – 2019 Edition

Benoit LecoursSCCM4 Comments

Based on the popularity of my previous post published in 2018, I decided to do a 2019 refresh of the SCCM Must have Tools and blog list since there were many changes since then. In this edition, I also added must-have blog posts that you should have already read. The tools are listed in no particular order. The list could have been longer but I needed to choose from my top personal list. If you feel that I’ve forgotten your awesome contribution to the SCCM community, please use the comment section to promote it. SCCM must have tools blog list … Read More

Create an Intune Device Profile for User Login Restriction

Benoit LecoursSCCM4 Comments

I was asked to restrict domain user access on a Windows 10 device managed by Intune. The computer was configured as a Single-App Kiosk mode so we needed to prevent a user to use CTRL-ALT-DEL and log on the computer using his domain credentials. After searching through the Intune Device restrictions available for Windows 10, I couldn’t find any UI settings for that. I had to use a Custom Profile type for that. (Custom Profiles are also called OMA-URI Settings) This blog post will describe how to Create an Intune Device Profile Restriction User Login to restrict login rights This … Read More