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

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

SCCM Client Version and Cumulative Update List

Benoit LecoursSCCM97 Comments

SCCM Client Version Report

We compile a list of SCCM client version, build numbers and cumulative updates since the 2012 RTM release. SCCM Upgrades are released 3-4 times a year. After an SCCM Upgrade, it’s important to upgrade your SCCM Client version to the latest version. 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. We recommend that you upgrade all your clients when you are applying the latest SCCM version. We release a step-by-step guide on how to update your SCCM server each time a version comes out. Just use the link next to the client … 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

Windows 10 Compatibility Check using SCCM and Report

Benoit LecoursREPORT, Reports, SCCM, SSRS34 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 deployment. SCCM Windows 10 Compatibility Check Package Creation We will start by creating a package for Windows 10 compatibility check. The source of this package must be the Windows 10 installation media. The deployment option and command line is important here. If they are not set correctly you’ll end up sending … Read More

SCCM Report Manager Tool for managing SCCM Reports

Benoit LecoursSCCM5 Comments

We developed an SCCM Report Manager tool using Powershell to manage your reports on an SCCM Reporting Point. 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. This tool is then a must if you need to manage multiple reports. 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 — Useful if you have multiple custom reports and are doing a migration to a new reporting point Change data source of all reports from a specific SSRS folder — Useful if you upload multiple new reports … Read More

New SCCM Endpoint Protection Dashboard and Reports Available

Thomas LarsenREPORT, SCCM, SCEP3 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 5 categories a client can be in (Protected-Inactive-At Risk-Unprotected-Infected) . The two At Risk and Unprotected categories shows a breakdown of the subcategories that make up the these two states. If you bought the System Health – Endpoint Protection reports you can click on a number and it will drill-trough to a filtered … 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 to the SCCM console ? This post will describe how to create SCCM Report Administrator Role which will fulfill this need. How to Create SCCM Report Administrator Role The first step is to create a Report Users role Once created, go to Administration \ Security \ Security Roles Right-click Report … Read More

Step-by-Step SCCM 1606 Upgrade Guide

Benoit LecoursSCCM75 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 upgrade post which explain it all. Similar to SCCM 1602, if you need to make a new SCCM installation, you can’t install SCCM 1606 directly. You need to install SCCM 1511 first and then apply SCCM 1606 from the console. SCCM 1511 is still the baseline version if you’re starting from … 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. You need to install SCCM 1511 first and then apply SCCM 1602 from the console. SCCM 1511 is still the baseline version if you’re starting from scratch. The update process seem quite easy but don’t get confused. Yes, it’s easy to apply, but these updates needs to be planned as … Read More