Windows 10 Compatibility Check using SCCM and Report

Benoit LecoursREPORT, Reports, SCCM, SSRS20 Comments

When planning for a Windows 10 migration, understanding your environment is the key. Luckily, Windows 10 setup comes with command line options which one of them is an excellent compatibility check (/Compat ScanOnly). This command can be used on a Windows 7,8 or 10 devices before a migration in order to see if those devices are Windows 10 compatible. Using SCCM, we will run this Windows 10 compatibility check, return the results in the SCCM database and use this data to build a comprehensive report. This report can be used to detect and fix migration errors before the actual Windows 10 … Read More

SCCM Report Manager Tool

Benoit LecoursSCCM2 Comments

SQL Reporting Services can be time-consuming when you need to download, upload or change data source on multiples reports. If you purchase one of our reports or our Complete Report Bundle, you had to upload every report and change their data source one-by-one. We developed an SCCM Report Manager using Powershell to manage your reports on an SCCM Reporting Point. Based on your SCCM Reporting Point and SCCM site code, the tool allows to : Upload multiple reports from a specific folder — Useful if you have multiple RDL files to upload at once Download all report from a specific SSRS folder — … Read More

New SCCM Endpoint Protection Dashboard and Reports Available

Thomas LarsenREPORT, SCCM, SCEP2 Comments

A few days ago we released three new Endpoint Protection reports. Together these reports give you a great insight into how well your Endpoint Protection clients are doing. Endpoint Protection – Dashboard System Health – Endpoint Protection System Health – Malware Detection (System Health reports are sold together) These reports are also available bundled together with Jonathan Lefebvre Endpoint Protection Management Guide at a discounted price. SCCM Endpoint Protection Dashboard This report shows you useful information about endpoint protection on a single page. The boxes at the top show current status as well as a trend for the last 30 days for each of the … Read More

Step-by-Step SCCM Report Creation using Report Builder

Benoit LecoursREPORT, SCCM, SSRS4 Comments

One of our favorite tasks when it comes to ConfigMgr management is SCCM Report Creation. Not only it brings value to an SCCM installation, it bring visibility on your hard work toward your management. Without SCCM reports, this huge management tools is running silently on all your devices but you’re not benefiting of all the advantages. It’s like having a sport 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 … Read More

Create SCCM Report Administrator Role

Benoit LecoursSCCM3 Comments

Role based administration is used to secure the access that is needed to administer SCCM. You also secure access to the objects that you manage, like collections, deployments, and sites but lacks a couple of roles to be complete. For example, there’s no built-in role for report administration or report viewer. We already covered the report viewer role in a previous post. This role give access to your users to consult and run SCCM Reports on the SSRS website. But what if you want to give access to an administrator to create, modify and upload reports without giving them access … Read More

Step-by-Step SCCM 1606 Upgrade Guide

Benoit LecoursSCCM74 Comments

The second upgrade for SCCM Current Branch (1511) is now available. This post is a complete step-by-step SCCM 1606 upgrade guide. If you’re looking for a complete SCCM 1511 installation guide, see our blog series which covers it all. You can’t install this upgrade if you are running SCCM 2012. You need to be at least at SCCM 1511. Installing SCCM upgrades is very important to your infrastructure. It adds new feature and fixes lots of issues, which some of them are important. New Update and Servicing model If you’re not familiar with the new SCCM servicing model, read our New Update and Servicing section of the 1602 … Read More

Step-by-Step SCCM 1602 Upgrade Guide

Benoit LecoursSCCM57 Comments

The first upgrade for SCCM Current Branch (1511) is now available. This post is a complete step-by-step SCCM 1602 upgrade guide. If you’re looking for a complete SCCM 1511 installation guide, see our blog series which covers it all. Installing SCCM upgrades is very important to your infrastructure. It adds new feature and fixes lots of issues, which some of them are important. New Update and Servicing Since SCCM 1511, Microsoft now release update pack differently than services packs and cumulative updates. Downloading and updating is made directly from the console. If you need to make a new SCCM installation, you can’t install SCCM 1602 directly. … Read More

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

Benoit LecoursSCCM, SSRS10 Comments

When editing a SCCM 2012 report in Report Builder you 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.) 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. … Read More

SCCM 2012 Distribution Point Installation

Benoit LecoursSCCM40 Comments

SCCM 2012 Distribution point Installation

In the first part of this SCCM 2012 and SCCM 1511 blog series, we planned our hierarchy, prepared our SCCM Server and Active Directory. In part 2, we installed and configured SQL in order to install SCCM. In part 3, we installed a stand-alone SCCM Primary site. In the next 16 parts, we will describe how to install the numerous site systems roles available in SCCM 2012 R2 and SCCM 1511. Role installation order is not important, you can install roles independently of others. In this part, we will describe how to perform a SCCM 2012 or SCCM 1511 distribution point installation. I saw a … Read More

SCCM Version Numbers and Cumulative Update List

Benoit LecoursSCCM83 Comments

**Updated 2018/11/27** Here’s a list of SCCM version numbers, build numbers and cumulative updates since the SCCM 2012 RTM release. Cumulative updates are cumulative, meaning that the latest one includes the previous one. (Ex: You don’t need to apply CU1 if you plan to install CU2) Once you apply a cumulative update, your SCCM version on the site server itself will not change. The site server will show the latest major SCCM release (RTM,SP1,R2). However, the new SCCM version numbers will show on your Consoles and Clients. How to get your SCCM Version Number SCCM Client Version Report Use our SCCM … Read More