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, SSRS0 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

5 Ways to view Hardware Inventory Information of a Device with SCCM

Nicolas PilonConsole, Hardware Inventory, REPORT, SCCM, SQL, SSRS0 Comments

  One of the SCCM features is to inventory hardware information from devices that are managed by the SCCM client. It’s not very difficult to enable and configure the hardware inventory client settings in SCCM. Once the devices received next machine policy and hardware inventory scan, data will start to populate in your SCCM database. The information gathered from the devices can be very useful from a system health, inventory or operation perspective. You can use this information to create collections, queries as well as reports. However, one thing not too obvious with the hardware inventory information, is to see all the … Read More

SCCM Office 365 Inventory Report

Benoit LecoursHardware Inventory, OFFICE, REPORT, SCCM49 Comments

This post describe how to inventory Office 365 using SCCM 1606. We will also provide a free report at the end of the post that you could use on your Reporting Point to easily display Office 365 inventory data. SCCM 1606 introduces new hardware inventory classes for Office 365 configurations. You no longer need to edit your MOF files to gather Office 365 inventory. If you are using SCCM 1602 or below, follow Jason Sandys post which describe Office 365 inventory process using a MOF customization. If your goal is to deploy Office 365 updates, refer to our post on how to manage Office 365 updates using SCCM. … Read More

List of SCCM Client Installation Error Codes

Nicolas PilonClient, REPORT, SSRS, System Health14 Comments

As an SCCM administrator, it’s important to learn the concept of troubleshooting a Configuration Manager client installation. By targeting the SCCM client installation error codes, you will have a better idea of what is happening during client installation. The error codes is not an exact science, they can defer depending on the situation. For a better understanding about error codes, read this great post from Jason Sandys. These codes appears in ccmsetup logs, located on in C:\windows\ccmsetup\logs. During the installation process, monitor the ccmsetup.log using cmtrace.exe and locate each error codes. There are other logs, on which the SCCM client installation relates. If you don’t … Read More

How to install Microsoft Intune Client for MAC OSX

Nicolas PilonClient, Console, Intune, REPORT, SCCM0 Comments

Did you ever wanted to install the Microsoft Intune client on MAC OSX? Microsoft Intune standalone supports Apple operating systems since November 2015. SCCM 1602 is required to support the Microsoft Intune client with the SCCM connector (hybrid environment). The Intune client is a lightweight version of the SCCM client. You can deploy some policies, SCEP certificates, VPN and WiFi profiles. There is also a hardware inventory scan on the devices. In a previous post, we explained how to set up a compliance policy for MAC OSX, now that our client is ready to receive the compliance policy, we will install the … Read More

Create Custom Reports with Labels of Asset Intelligence

Nicolas PilonAsset Intelligence, SCCM, SSRS6 Comments

Usually we use information from Add Remove Programs when it’s time to make software reports. For technical reasons, it’s not always easy to have adequate results. The use of custom labels in Asset Intelligence helps standardize and gather software information. In this post, we will explain how to use the data from custom labels in asset intelligence to create a custom reports. Before starting the reports, make sure the custom labels are set in your environment from how to maximize the use of custom views in Asset Intelligence. Configuration Manager 2012 came with a couple of Asset Intelligence reports but … Read More

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

Benoit LecoursSCCM, SSRS7 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

Upload RDL File to Report Server

Nicolas PilonSCCM, SSRS33 Comments

There are many way to upload RDL file to report server (SSRS). This post will show how to do it with the web portal. A RDL file is an XML application and a standard proposed by Microsoft for defining reports. Requirements SSRS installed and all running components.  You can refer to install SCCM 2012 Reporting Services Point post. A healthy RDL file. A user account with enough access to upload a report. Please read predefined roles on MSDN for more detailed information. Upload the file We suggest uploading your file into a Test folder before releasing the report in production. The report can be tested … Read More

Install SCCM 2012 Reporting Services Point

Benoit LecoursSCCM, SQL, SSRS10 Comments

In this part of SCCM 2012 and SCCM 1511 blog series, we will describe how to install a SCCM 2012 or SCCM 1511 reporting services point. This role can be installed on a remote machine, the process is the same but the logs location is different. Requirements Before you can install the reporting services point role you must configure SQL correctly. We’ll be using SQL 2012 on this post. We are assuming that SQL is already installed and that your SCCM site is up and healthy. During the initial SQL installation, you must select Reporting Services. If you have installed SQL … Read More