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

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

SCCM Office 365 Inventory Report

Benoit LecoursHardware Inventory, OFFICE, REPORT, SCCM98 Comments

This post describes 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 describes 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. SCCM Office 365 inventory report post summary : Office 365 Inventory Data explained How to enable Office 365 Inventory classes Verify Office 365 Inventory data on a client How to upload and use our free Office 365 report SCCM Office 365 Inventory Report – Direct Download link If you don’t want to read the … 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

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

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

Nicolas PilonConsole, Hardware Inventory, REPORT, SCCM, SQL, SSRS5 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 data of a device in a one pager. There’s several ways to do it, some more difficult than others, but we will show you how. SCCM Hardware Inventory – Resource Explorer The first one is the Resource Explorer tool. It’s a tool accessible directly within the console and which don’t require any … Read More

List of SCCM Client Installation Error Codes

Nicolas PilonClient, REPORT, SSRS, System Health33 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 appear 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 find enough information in the ccmsetup.log, scan all related log files in c:\windows\ccm\logs. Use the command line net helpmsg, for more information about your return error code. SCCM Console You can also add the Last Installation Error in the SCCM console: Open the SCCM console and navigate to Assets and Compliance / Devices In the devices view, right-click … Read More

How to install Microsoft Intune Client for MAC OSX

Nicolas PilonClient, Console, Intune, REPORT, SCCMLeave a Comment

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 Microsoft Intune client on Mac OS X devices. Install the Intune Client Mac There is still no way to automatically install the client. Connect on the MAC OSX devices that you want to install Microsoft Intune client Open Safari and go to portal.manage.microsoft.com Click on This device is either not enrolled … Read More