#Sccm report with mac address how to
#Sccm report with mac address update
#Sccm report with mac address software

I do not believe you want four records for the same device, just because it contains four memory slots with 1 GB physical memory installed in each.Īnother good example for duplicate records is duplicates due to Windows versions. Now, if you do a JOIN into the memory table to get the memory information for a device, you will get four records for that machine, with each record representing a slot number. Say for example that a machine has 4 GB of physical memory installed in four different memory slots, that is 1 GB physical item per slot. Each record for the same machine represents a certain meaning or goal.

This is when you have two records for the same device or machine appearing in your report. I hate when the report comes back with duplicate records. There are many tables out there, but the built-in SQL views inside the configuration manager database helped me a lot in my JOIN statements. The first and biggest challenge is to understand the configuration manager SQL database schema, and to find our where the needed data resides. I hope by explaining how I thought about this report, it would make it easier for you to go and tweak the report query to fit your needs, or perhaps to add more information that you might need in your environment. You can skip this section if you want to try the report right away in your environment and enjoy the wonderful results I hope. While most of you want to jump directory and try the report, I want to spend a little time talking about the challenges I faced.

#Sccm report with mac address update

Check my configuration manager update size post for more details.

#Sccm report with mac address software

Tip:I created a blog post to list all Windows update package size, so that you can have an idea of your patching software update group before downloading them and perhaps congest your network. Usually the ResourceID is the main identifier of resources hosted inside the configuration manager SQL database. I can argue that the best way to get rich queries and information from configuration manager, is by using the SQL report engine and native SQL queries. If you are a beginner in configuration manager, you might be using the SCCM queries (WQL), which is based on WMI name spaces. After that, I would figure out the main records to query, and what columns to use for my filtering and aggregations. To do that, I had to dig deep and understand the schema of configuration manager SQL database and the relationship between tables. The reason why this report is unique, is the way it aggregate information, and help prevent duplicate records and filter orphan devices.

#Sccm report with mac address how to

This blog post talks about how to create a detailed configuration manager report, that can be considered a unique report in the internet.