Did you know you can Create an SCCM report in Two Clicks in MPA Tools without SQL or PowerShell scripting knowledge?
This is probably the easiest way to create an SCCM Hardware Inventory report, export it to CSV format for further editing, or open it with Excel. And on TOP of all that, you can include additional information from Active Directory and/or Intune. Sounds interesting? Read on!
I banged my head on the keyboard many times over the past years, trying to create something in the report builder. It was never easy!
With MPA Tools, the process is very simple. First, select and PING / DISPLAY one or multiple computers from your list.
Quick note: You can add your custom list of computers or work with computers directly from OU, SCCM Collection, or Azure AD security group.
To create a report or just check some HW inventory data on a single computer, navigate to the SCCM Properties page and click the Hardware Inventory button.

In the Hardware Inventory space, simply check the classes you want to add to your report and run it.
Make sure you check that HW has been previously collected and is not outdated!

How to create a custom SCCM report based on hardware inventory on multiple computers?
With MPA Tools, it is quite easy!
Simply Ping / Display multiple computers from the list of your preferred source.
Go to the ACTIONS tab and select the Computer Properties blade.
In the Computer Properties action blade, you have multiple common computer properties that you can choose from—for example, CPU, RAM, Model, Serial Number, Etc.
Select the computer properties you would like on your report and click Add to a Sequence (so you can add additional actions). Note: Run Now to display the Information without sequencing.
MPA Tools first connects to a remote computer to gather the current data. If the remote computer is inaccessible, MPA Tools will connect to the SCCM server to collect the requested Information. You could use the “Load Properties from SCCM” option to skip connecting to remote computers and get data straight from SCCM (This could be the fastest choice).
TIP: Always check the Last Hardware Inventory Date on the SCCM client (this Information is displayed in the Action Log – Action Column). Hardware Inventory could be old or missing completely! If you are missing data in SCCM, you can still try and connect to the remote computer to collect the data. Just highlight the computer and rerun the task.
Below is a quick video on how to create an SCCM report in two clicks in MPA Tools; it is that simple!
(for reference on how to create SCCM Report in Report Builder can be found here)

“I’m amazed at how often I use MPA Tools. What I love the most about it is that all the information I need is at my fingertips in one tool and one window. It’s a great systems management tool that has the combined functionality of several tools all in one place. ” more
– Rashid Almaktary, Supervisor IT Services