ConfigMgr Query for MAC Addresses

ConfigMgr Mar 1, 2017

These queries were last tested with Configuration Manager version 2006

I recently had to find the MAC Addresses of a bunch of servers that were managed by Configuration Manager (ConfigMgr) so I pulled together a simple query that would pull the information out of the database for me.

I've put together a wee guide on how I implemented the query below:

1 - First of all I opened up my ConfigMgr console and navigated to the Monitoring tab and expanded "Overview".
SCCM Query

2 -  Next I right clicked on Queries and selected "Create Query"
SCCM Query

3 - Selecting "Edit Query Statement" next
SCCM Query

4 - Then I clicked on "Show Query Language"
SCCM Query

5 - Within the dialogue box that appeared I typed

SCCM Query

6 - I then clicked OK and named my Query, then completed the wizard
SCCM Query

7 - My query appeared within the Query list and I was able to Run it.
SCCM Query

Which produced some results
SCCM Query

You can modify the ConfigMgr query to pull back the information from specific clients by using:

The above query will find any clients that have laptop as the first part of their name.

Additional Reading

If you are looking for other articles on ConfigMgr I have a useful guide here, that will help you uninstall Visio 2013 using ConfigMgr.

Tags

Great! You've successfully subscribed.
Great! Next, complete checkout for full access.
Welcome back! You've successfully signed in.
Success! Your account is fully activated, you now have access to all content.