Deploy SCCM Wifi Profiles with Password to Windows 10 Devices

Benoit LecoursSCCM10 Comments

Introduced since SCCM 2012 R2, SCCM Wifi profiles are used to send Wifi configurations to clients. It can be useful if your company is not using certificates or any automated authentication methods. A smaller organization that uses a simple WPA2 setup can use SCCM Wifi profiles to send Wifi SSID and password so that the computers connect automatically to that network. You can also use Wifi profile to manage mobile devices with Intune but we won’t cover this scenario in this post. The major drawback of the SCCM Wifi Profile is that it’s impossible to enter the Wifi password using the console UI. (Even in the newest versions). We will show you how to deploy Wifi profiles on a Windows 10 or Windows 8.1 computer, including the Wifi password using an XML file. How to deploy SCCM Wifi Profiles with password to Windows 10 devices Since it’s not possible to enter a password in … Read More

SCCM Report Builder Error – The Certificate Chain was issued by an Authority that is not Trusted

Benoit LecoursSCCM, SSRS13 Comments

If you’re like us and love to create and build awesome reports, you may get an error when running report builder on a remote computer. When editing an SCCM report in Report Builder you may receive the following error: A connection was successfully established with the server, but then an error occurred during the login process. (provider: SSL Provider, error: 0 – The certificate chain was issued by an authority that is not trusted.) SCCM Report Builder error – Cause This error occurs because you don’t have the required SCCM SQL certificate on the computer running Report Builder. Follow the following steps in order to resolve the issue. Export the certificate from your SQL server On the SQL Server Click the Start menu, click Run, and then type mmc. Click Enter. This starts the Microsoft Management Console (MMC) In the console, click the File menu and then click Add/Remove Snap-in On the … Read More

Extend your inventory with SCCM Active Directory Attributes

Benoit LecoursSCCM11 Comments

SCCM Active Directory System Discovery is a discovery method to bring discovered devices into your SCCM server. It’s one of the most used discovery methods for its simplicity. Many organization extends their Active directory to include custom attributes to their records. By default, SCCM brings a couple of default Active Directory attributes but it’s also possible to bring any custom attribute that you may have. The good news is that it’s quite simple to add these custom Active Directory Attributes to your SCCM Discovery methods. What is more complicated is how to fetch this data once it’s discovered. Over the years, we’ve seen much different information stored in AD Attributes. For this post, we’ll add the Description attribute from a computer account to SCCM and describe how to query this information to create collections or reports. SCCM Custom Active Directory attributes Configuration The first step is to find the name of … Read More

Step-by-Step SCCM Report Creation using Report Builder

Benoit LecoursREPORT, SCCM, SSRS8 Comments

One of our favorite tasks when it comes to ConfigMgr management is SCCM Report Creation. Not only it bring value to an SCCM installation, but it also brings visibility to your hard work toward your management. Without SCCM reports, this huge management tool is running silently on all your devices but you’re not benefiting from all the advantages. It’s like having a sports car and discovering the Autobahn … ok maybe not. But what makes a good SCCM report? Data, data, data This is the more important part of your reports. You need to query the right SQL views in the SCCM database. If you’re showing incorrect information, your report will be useless Building an efficient SQL query is the hard part of report creation. Without any SQL skills, it will be hard to achieve what you want… but, everything can be learned. Two years ago I’ve never done an … Read More

How to Find SCCM Server Log Files

Benoit LecoursSCCM2 Comments

Here’s a simple tip to know which SCCM server logs files to check if you want to dig an error returned by an SCCM Component. In SCCM, client and site server components record process information in individual SCCM log files. You can use the information in these log files to help you troubleshoot issues that might occur. The default path to find the SCCM server logs files is in your SCCM Installation Directory\Logs. If you’ve used the default installation directory, it will be located in C:\Program Files\Microsoft Configuration Manager\Logs. The problem is that when opening this directory, you’ll find dozens of SCCM logs files. When you manage SCCM for multiple years, you get to know which logs to look at, but as a beginner, it can be hard to find the right log. This post aims to help you find the right log file based on a specific component error. … Read More

Monitor SCCM Task Sequence Progress

Benoit LecoursSCCM, WINDOWS 104 Comments

When deploying Windows 10 operating system using SCCM (OSD), you will need to monitor SCCM task sequence progress. This allows us to track task sequence start, end time and most importantly errors (if any). Our post will show 4 different ways to monitor SCCM task sequences. Each of them has its own benefits and drawbacks. Monitor SCCM Task Sequence Using the Console You can view the progress of a task sequence using the SCCM console. This method is simple and easy but permit to see the status of only one machine at the time. If your deployment staff don’t have access to the console or view deployment status, this option is not for you. Open the SCCM Console Go to Monitoring / Deployments Search and right-click the deployment linked to your Windows 10 task sequence On the menu, select View Status In the Deployment Status screen, select the In Progress tab for a running … Read More

How to upgrade SCCM SQL version

Jonathan LefebvreSCCM, SQL6 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 versions must be one of the following : SQL Server 2008 SP4 or later SQL Server 2008 R2 SP3 or later SQL Server 2012 SP2 or later SQL Server 2014 or later SQL Server 2016 or later Download SQL reporting services Download SQL Management studio The operating system is still … Read More

Identify Office Products with its architecture using SCCM report

Benoit LecoursConfiguration Manager, OFFICE, REPORT, Reports, SCCM, SSRS17 Comments

I did blog post year ago on Microsoft office product versions with its architecture type and count. But lately, my blog readers have requested to add Office 365 ProPlus product into the report. The Original Office Product report was created to include all Microsoft Office products from Office 2007 to Office 2016 but it doesn’t have any click-to-run (C2R) products which are Office 365. So we started looking around and developed the report for you. This free report will have all Microsoft Office products information with its architecture type (x86 or x64) and the count. The report can be run on a specific collection which is useful to scope specific group of machines. This can be used as all-in-one SCCM report for Microsoft Office product versions with architecture type. This report comes with a drill-down feature to see the list of all devices with the selected product. You’ll need our … Read More

How to configure Windows Analytics with Log Analytics

Jonathan LefebvreAzure4 Comments

Windows Analytics is the suite name following the original release of Upgrade readiness. The suite adds Device Health and Update Compliance under the same roof. Depending on the environment each sub-product will provide key information for end-user computer admins. Windows Analytics and Log Analytics is better together! Upgrade readiness can help assess applications and drivers compatibility prior to migrate from Windows 7/8.1 to Windows 10, or even from one Windows 10 build to another. Device Health provides extra information for admins to review various crash within their environment. Update compliance provides a way to track how updates and upgrades are doing in the environment. This will be particularly useful when mixed with Windows Update for Business. All of the Windows Analytics features sit on Log Analytic from Azure. Previously it was possible to host the data in OMS. OMS as retired and it is possible to move it into Log … Read More

How to update HP BIOS using latest HPFirmwareUpdRec with SCCM

Jonathan LefebvreSCCM22 Comments

At a client site, they received newest HP models to be tested. Downloading drivers and BIOS updates were the usual. Looking at details about the BIOS update, we noticed that the HPBIOSUPDREC.exe that was used was no longer available.  HP released a new version called HPFirmwareUpdRec to replace it. Even if the help stated the command line to be the same, it turned out it didn’t work at all. Unfortunately, it doesn’t seem HP documented the new tool and how to use it. we were able to figure it out by digging into HP forums… In this post, we will show hot to update HP BIOS using the latest HPFirmwareUpdRec tool within a task sequence. Prerequisites When downloading the bits from HP, looking at the BIOS files you need to see HPFirmwareUpdRec.exe. If the file is not there, the update should be done using the old tool HPBIOSUPDREC.exe like before. Update … Read More