SCCM Custom Reports

Report Goal

Assess Bitlocker’s compliance level and quickly detect potential BitLocker encryption risks.

Report Features

• Total percentage of encrypted devices
• Which computers are Bitlocker-compliant
• What computer manufacturer and model is compliant
• Which Operating System is compliant
• Is TPM enabled on our computers?
• Unveil relevant information by using Name and Status Scoping
• The report is scoped using BitLocker status. You can show the only machines that are encrypted or focus on the one that is not. You can also find a particular machine’s status using its name.

Additional information in the blog post: Bitlocker Status report prerequisites and features.

How to download – FREE

Report Goal

Quickly display the compliance state of a specific baseline in SCCM.

Report Features

• Baseline Configuration Definition: The report typically details compliance policies, versioning, or reference data.
• Device Summary: The report will often provide a high-level summary of the compliance state, including the total number of devices in the scope of assessment and how many are compliant, non-compliant, or pending evaluation.
• Configuration Item Details: The report will show individual configuration items or settings that are part of the baseline. Each item may include the setting name, description, and expected value.
• Non-Compliant Devices: A section of the report will provide information about devices not complying with the baseline configuration. This can include details of the affected user.
• Non-Compliance Reasons: The report may explain why specific devices are non-compliant. It might include error messages, warnings, or explanations for the particular configuration items that failed.
• Export and Sharing Options: SSRS typically offers options to export the report data in various formats (e.g., PDF, CSV, Excel) for sharing with stakeholders or further analysis.

How to download – FREE

Report Goal

Display all your hardware inventory in a single view. Quickly Find a specific machine having particular hardware specifications (Disk, CPU, Serial number, RAID controller…).

Report Features

• Report outdated devices to management for replacement during Windows 10 migration projects.
• How many computers our company owns?
• Which devices are near their end of life?
• How many DELL Latitude 5510 remain?
• Which computers are still running Windows 7 or Windows 2008?
• Find the serial number of a specific computer
• Identify specific hard drive firmware

How to download – 21.99$

Report Goal

Display all your software inventory in a single view. Quickly finds a specific machine having particular software installed on a computer.

Report Features

• Display a quick overview of which software is on how many computers
• Display a quick overview of which software is not on computers
• Click on a number to list the machine name which has the specific software
• Use the search function to find only a specific product
• This product contains 2 reports, 1 for the overview of your installed software and their count, and the other one shows details on all the devices that have the selected software.

How to download – 10.99$

Report Goal

Display all your software inventory and usage in a single view. Quickly find a specific machine having particular software installed and its usage on a computer.

Report Features

• Help to build a comprehensive software usage audit
• Display an overview of which software is on how many computers and its last utilization
• Identify which computer has a software license but is not using it
• Use the search function to find only a specific product

SCCM Software Utilization Report Requirement

Before using this report, make sure you read all posts from Asset Intelligence series and that you configured custom labels in Asset Intelligence.

• Part 1 | Why should you use Asset Intelligence in SCCM
• Part 2 | How to maximize the use of Asset Intelligence with Labels
• Part 3 | Create Custom Reports with Labels of Asset Intelligence
• Part 4 | Merging Last Usage of Software Metering with Custom Labels of Asset Intelligence

How to download – 21.99$

Report Goal

Quickly find a machine having a particular or outdated Office 365 version. Report outdated devices to stay supported by Microsoft and take action to update those machines.

Report Features

• Display all your different Office 365 versions, channels, and platform
• Display which machines are managed by SCCM for their updates
• Report their last update status

Report Goal

Display all your Microsoft Office inventory in a single view. Quickly find a machine having a particular or outdated Office product. It can be used for the Office suite (Word,Excel, Outlook) as well as other Office Products like Visio or Project. Report outdated devices to stay supported by Microsoft and take action to update those machines.

Report Features

• Display all your different Office product versions, architecture, and platform
• Count the different Office version
• Report their last update status

We also have a complete blog post on this report. See this post for complete details

Report Goal

Quickly display Software Metering Data from the SCCM inventory. Monitoring software usage can help achieve substantial saving by targeting which devices have costly software but is not using it.

Report Features

• Report which machines have run a specific software based on an SCCM Metering Rules.
• See details on a specific software metering rule
• See who has run specific software on a specific period of time
• Take action to uninstall software based on its utilization
• Save on licensing cost by removing unused software

If you are using Asset Intelligence, see our related product which could help you achieve a robust solution to save on licensing cost.

Report Goal

Display all your Microsoft Surface inventory in a single view. If your organization has lots of Microsoft Surface, this report is a must.

Report Features

• List all Microsoft Surface devices
• Report outdated devices to management for replacement during hardware refresh or update project.
• Quickly identify UEFI enabled Surfaces and their UEFI version
• Inventory their Serial Numbers and Firmware Version
• Rapidly see the count of Surfaces per model
• 4 comprehensive pie-charts

Report Goal

The SCCM Windows 10 Servicing dashboard in the console is incomplete to effectively manage your Windows 10 updates. The dashboard does a good job of showing an overview of your servicing plans and basic inventory information. The problem is there’s no way to actually see which machines are compliant to a specific support state.

Our SCCM Windows 10 report fixes those gaps and will help your team in their Windows 10 servicing tasks

Report Features

• List all Windows 10 devices
• Report outdated devices to management for replacement during Windows 10 migration projects.
• Quickly identify near-expiration and expired Windows 10 devices
• Rapidly have inventory count of Windows 10 per: Edition, Version, Build, Branch and support state
• 5 comprehensive pie-charts

Report Goal

Lists problematics Windows 10 compatibility errors during Windows 10 migration projects. Easily identify which computers could cause a failure during their Windows 10 upgrade.

Report Features

• List all Windows 10 devices
• Quickly identify Windows 10 migration error
• Identify if a particular model is failing
• Search the error code to find a solution before your actual migration

See this blog post for complete details about this report.

Report Goal

Display all your Windows 11 Readiness in a single view. How can you ensure that your device will be ready to install Windows 11? The best solution as of today is to build an SCCM Windows 11 report to list which device is ready and which needs attention.

Report Feature

• List : Device Name, UserName, Client Status, Client Version, OS Edition, OS Version, OS Branch, CPU Speed, RAM, Free Space, Device Manufacturer, Device Model, Secure Boot Status, UEFI Bios status, TPM version and status
• 6 comprehensive pie charts to list a count of compliant devices in each category
• Red highlight if a component did not match Microsoft’s minimum requirement
• 5 comprehensive pie-charts

Report Goal

This SCCM Applications report is an easy way to inventory your applications and deployment types. Keep your console clean and delete unused applications by seeing all relevant information on a single screen.

Report Feature

• List all applications and deployment type
• The powerful search feature to find any information about your applications
• List the Content Source and content size of each deployment type
• Complete installation statistics  for each application (by device and user)
• Which user created or modified a certain application
• Identify the application set as Featured in Software Center or an application that fits a specific Category

Report Goal

Identify and monitor the boundary configurations of your SCCM site. This product contains 2 reports :

• Configuration Manager – Boundaries:List all the boundaries along with site assignment and site systems
• Configuration Manager – Boundary groups : List of all boundary groups with site system names, fallback options configured (if they are applicable).

Report Features

• Quickly identify specific boundary information with its assigned site, site systems and fallback options
• Troubleshoot content downloads and site assignment issues
• Track the fallback options for boundaries with its site system names
• Identify if a site system is in more than 1 boundary group.

See this blog post for complete details about this report.

Report Goal

The SCCM Cloud Management dashboard in the console is incomplete to effectively manage your CMG Clients. The dashboard does a good job of showing an overview of your Cloud Management Gateway statistics. The problem is there’s no way to actually see which machines are actually using your CMG. Our SCCM Cloud Management Gateway Client report fixes those gaps and will help your team in their management tasks

Report Features

• List all CMG-connected devices and the total count
• Quickly identify if your CMG is working correctly
• See which CMG is used by your client
• 2 comprehensive pie-charts

See this post for complete details about this report

Report Goal

The SCCM CoManagement dashboard in the console is incomplete to effectively manage your comanagement Clients. The dashboard makes a good job of showing an overview of your comanagement statistics. The problem is there’s no way to actually see which specific machines are actually using comanagement. Our SCCM comanagement report fixes those gaps and will help your team in their management tasks

Report Features

• Shows the count of client devices per OS build such as 1803,1809, 202H2 etc.
• Quickly identify if your comanagement is working correctly
• A pie chart shows the number of devices with enrollment states
• A table shows the count of devices that has enrollment errors

See this post for complete details about this report

Report Goal

Simplify your collection management in a single view. Creating and managing collections in SCCM is quite easy but it can become a burden when you have hundreds or thousands of them. Collections in Configuration Manager is a resources-intensive task, some best practices need to be followed. This SCCM collections report will help decrease your management cost and save valuable time searching in the SCCM console.

Report Features

• List all users and device collections names, folder,s and properties
• Powerful Search to quickly find any collection
• List a count of members, deployments, variables, rules and maintenance windows assigned to a collection
• Find all incremental collections
• List resource extensive collections
• List all collections with a defined member count
• List collection by evaluation time

Report Goal

Easily find and identify which Maintenance Window applies to a specific computer or collection. You can’t find this information straight in the SCCM Console. This report is very useful for identifying problematic deployment due to maintenance window misconfiguration.

Report Features

• 2 reports (1 for collections, 1 for devices)
• See your Maintenance Windows statistics overview
• Identify which Maintenance Windows applies to a provided devices
• Identify which collection has a Maintenace Window applied to it
• Click on a Collection Name or Maintenance Window to see its details
• Quickly identify which collection has a Maintenance Windows but has no members
• List the start time and duration for each Maintenace Window

Read this blog post for more information about this report.

Report Goal

Use this report to see information about your software update configuration without having access to the SCCM console. Quickly identify configuration problems and compliance statistics per update and collection.

Report Features

• Use the report to help you achieve your organization’s compliance target
• See the complete patch inventory
• Per Update list of Security and Compliance level
• Displays only the latest software updates
• Targets updates for a specific operating system by using the Search parameter
• Clicking on an update will open the Microsoft Updates website showing additional information
• List Expired or Superseded updates using the report and remove them from your Software Update Groups to save distribution point disk space
• Use Custom Severity filed to list only updates that fit these criteria. This can be useful for excluding certain updates from your environment.

Report Goal

Display all your Primary Device information in a single view. Quickly identify all User and Device Associations for a selected collection. Target a specific user or device to find who’s the primary user. This report is a must if you’re doing a User-based deployment using primary user association.

Report Feature

• List all User and Device Associations
• Display all user and their primary machines
• See if a user is assigned to multiple machines

Read our complete blog post for complete details

Report Goal

Display all your SCCM Site and device information in a single view. Quickly monitor the status of your SCCM site every morning. Look at all your SCCM configurations and what’s happening on your devices.

Report Feature

• Client information overview
• Consoles usage
• See how many applications, packages, and drivers have been created
• See how many deployments are active
• Hardware overview
• Operating Systems Overview
• Operating System deployment historical data
• Software Update Overview
• Distribution Point status
• Component error

This report is linked to many of our reports giving you the best drill-down experience.

Report Goal

Display all your device inventory in a single view. Forget about using the outdated Resource Explorer and upgrade to the next level. Access to all data that has been inventoried by hardware inventory.

Each report section sends you to the associated report automatically which makes this report the most important of all our catalogues.

Report Features

• Hardware inventory
• Installed software inventory
• Office 365
• Collection Membership
• User and device collection membership
• Software update compliance
• SCCM client health
• User affinity
• Deployment Statistics
• Endpoint Protection status

Report Goal

Display all your Endpoint Protection inventory in a single view. Provide critical Endpoint Protection data to your security team easily. Upgrade your company compliance and protect your device by quickly identifying which computer is at risk and taking action to fix them.

Report Features

• Endpoint Protection Client Status
• Historic data of Protected clients
• Historic data of Inactive clients
• Historic data of At-risk clients
• Historic data of Unprotected clients
• Historic data of Infected clients
• List of Malware detected
• List of Malware activity in the last 30 days
• Statistics of the Signature File Age

Report Goal

Monitor all your SCCM Scripts in a single view. Quickly monitor the status of your SCCM site every morning. Look at your SCCM configuration and what’s happening on your devices.

Report Feature

This product contains 2 reports :

• Dashboard – Scripts
• Configuration Manager – Scrips

Use both reports to show :

• Approval State
• Script type
• Statistics on script execution time
• Top 5 Authors
• Top 5 Approver

If you click a script name in the Dashboard – Script report, it brings you to the second report which shows execution statistics per machine on the selected script. Refer to this blog post for all details

Report Goal

Display all your Operating System Deployment statistics in a single view. Display detailed information about your operating system deployment statistics. Keep your success rate as high as possible during Windows 10 deployments and identify which computers are failing.

Report Features

This product gives access to 3 distinct reports :

• Dashboard – Operating System Deployment

The dashboard report is the overview of all your deployments by advertisement. The little bar separated by color tell you the deployment statistics by status.  The columns chart shows the count of deployments by date which helps you see trending.

• Deployment – Operating System

Monitoring your deployment and see all device statuses of advertisements and task sequences. Is there any current deployment you want to verify?

• Deployment – Task Sequences

This report shows you all the steps that the device is doing. If there’s an issue with the task sequence, you will detect it. There’s also a little description of the device.

• Deployment statistics on a specific task sequence
• Detailed information on success and failed task sequences
• How many task sequence has been deployed, per days
• Show the deployment average time per task sequence
• Sees at which task the task sequence has failed
• Quickly identify which computer has completed or failed a task sequence
• Help optimize task sequence run time Isolate run time issue based on collections
• Easily track your Windows 7 to Windows 10 deployment statistics
• Any kind of task sequence is supported (Application, Upgrade, New computers)
• Quickly identify which applications are slowing down your deployments
• Quickly identify which task is slowing down your deployments

Report Goal

Display all your Application Deployment in a single view. Instantly access to better application deployment statistics.

This product contains two SCCM Application Deployment reports :

• Deployment – Applications Overview:  Overview of all your application deployments. When clicking on a number, you are sent to the Deployment – Application report.
• Deployment – Application: Detailed list of your machines and their status for specific application deployment.

Report Features

• List all deployments from your SCCM infrastructure
• See all deployments from a specific type (Applications)
• The success rate of the deployment
• The number of devices in each status (Succeeded, Failed, Unknown)
• List all machine names from a specific status (Succeeded, Failed, Unknown)
• See rapidly all error codes and descriptions returned from a specific deployment

Report Goal

Display all your Package Deployment in a single view. Instantly access to better package deployment statistics.

This product contains two SCCM Package Deployment reports :

• Deployment – Package Overview :  Overview of all your package deployments. When clicking on a number, you are sent to the other report.
• Deployment – Package: Detailed list of your machines and their status for a specific package deployment.

Report Features

• List all packages deployment from your SCCM infrastructure
• See all deployments from a specific type (Packages)
• The success rate of a given deployment
• The number of devices in each status (Succeeded, Failed, Unknown)
• List all machines name from a specific status (Succeeded, Failed, Unknown)
• Rapidly see all error codes returned from a specific deployment

Note : If you have bought the Deployment – Package report, simply place all reports in the same folder on your SSRS server and they will be linked automatically.

Report Goal

Display all your hardware inventory in a single view. Qquickly show device compliance on a single screen. Report outdated devices to your security team for faster patching and less security vulnerability.

Report Features

• Display which updates are installed or required from a specific computer
• Display overall compliance from a specific Deployment Package
• Display only patches that fit a certain Category or Severity
• Powerful Search to display only the information you need
• Directly access the Microsoft Bulletin ID page to read the Microsoft documentation for a specific patch

Report Goal

Display all your client information in a single view. Quickly identify your unhealthy SCCM clients to increase your application deployment success and ensure up-to-date hardware inventory. Increasing your client health percentage has to be on the to-do list of every SCCM administrator.

Report Features

• 5 Comprehensive pie charts
• Display client installation status and error codes
• Display client count per version
• Display client health statistics
• Display client and management point association
• Quickly identify stalled or invalid client agents
• Report is scope by collection so you can display specific devices

Report Goal

Display all your distribution point statuses in a single view. Monitor your Distribution Point Status like a pro. Quickly identify which distribution point is having problems and save valuable time in your day-to-day task. This report is a must if you’re managing multiple distribution points as their health is critical to ensure good SCCM functionalities.

Report Features

• 5 comprehensive pie charts
• Which Distribution Points are healthy?
• Which Distribution Point is currently distributing content?
• How many Distribution Point is missing a certain package?
• Which Distribution Point is having free space issues?

Report Goal

Display all your Endpoint Protection agents in a single view. Quickly identifying unhealthy Endpoint Protection clients. Report outdated devices to your security team to address vulnerability issues and ensure that they are up-to-date.

Report Features

• 5 comprehensive pie charts
• List the version of the agent per machine including pie chart
• Shows unhealthy devices
• Last full scan date for all devices
• Shows Antivirus and NIS configuration
• Lists malware types, severity, threat information for any detected malware
• Top 10 malware threats

Report Goal

Site Monitoring Dashboard in a single view. Monitor your SCCM hierarchy like a pro! As you drink your coffee, routinely check each morning that everything runs smoothly. The SCCM Monitoring Dashboard report shows all the necessary information to look for a healthy SCCM Infrastructure.

Report Fetures

• Site Status Overview: See your SCCM Site State
• Site Server Count: Rapidly see the count of all deployed roles
• Clients: See client statistics and installed percentage
• Distribution Point : See if your distribution points are healthy or processing content
• Site Component Error/Warnings : See various errors/warnings on each site component
• SQL File Size: Monitor SQL file size and free space
• Last 10 Application Deployments: See your last deployment statistics to rapidly see if there are errors
• Last 10 Package Deployments: See your last deployment statistics to rapidly see if there are errors

This SCCM Site Monitoring Dashboard is linked to various of our other reports :

• System Health – Site System State Message report : To view details about the Site System Warning/Errors
• System Health – Distribution Point : To view detailed distribution point errors
• System Health – Configuration Manager Client : To view detailed information about your client status
• Deployment – Applications : To view all your application deployment statistics
• Deployment – Packages : To view all your application deployment statistics

Report Goal

All your SCCM Site Status State Messages in a single pane. Quickly see all messages on a specific component when you are troubleshooting site component errors. Save valuable time on your daily operation tasks. This report is a must if you’ve downloaded the System Health – Monitoring Dashboard.

Report Features

• Top 5 of which component gives the most error
• See informational, warning and error message count
• See message from a specific component
• See only the error message
• Only display messages from a specific message ID

Report Goal

Display all your Software Update compliance in a single view. Manage and monitor your software update compliance like a pro! Quickly identify which device needs a specific software update and patch the vulnerable machine.

Report Features

• 5 comprehensive pie charts
• List compliance percentage per machine
• List the number of missing updates per classification
• Assess Severity Compliance of your site to comply with Microsoft’s recommendations
• Shows Windows update agent version with last scan state status
• Display client agent Software Update Point assignation

This report can work with the Software Updates Deployment Report or in standalone mode. When both reports are linked, it allows you to click on a number in this report and be sent to the Software Updates Deployment Report. The report will show only the requested information.

Before downloading the Power BI template files, please follow our previous blogpost and install the Power BI Desktop software. Download the latest version from here.

After installation is completed, download one of our dashboards and save it on your computer.