> ## Content Index
> Fetch the complete content index at: https://www.techielass.com/llms.txt
> Use this file to discover other available public pages before exploring further.

# ConfigMgr Query for MAC Addresses
- URL: https://www.techielass.com/configmgr-query-mac-addresses/
- Published: 2017-03-01T06:00:00.000Z
- Updated: 2022-12-01T18:03:38.000Z
- Description: Use ConfigMgr to pull out MAC addresses
- Author: Sarah Lean
- Tags: ConfigMgr

> These queries were last tested with [Configuration Manager version 2006](https://docs.microsoft.com/mem/configmgr/core/plan-design/changes/whats-new-in-version-2006?WT.mc%5Fid=modinfra-0000-salean&ref=techielass.com)

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](https://storage.ghost.io/c/08/96/08960c71-63a2-449b-91b1-8d4628166dd2/content/images/2021/03/Untitled.jpg)

2 - Next I right clicked on Queries and selected "Create Query"  
![SCCM Query](https://storage.ghost.io/c/08/96/08960c71-63a2-449b-91b1-8d4628166dd2/content/images/2021/03/Untitled2.jpg)

3 - Selecting "Edit Query Statement" next  
![SCCM Query](https://storage.ghost.io/c/08/96/08960c71-63a2-449b-91b1-8d4628166dd2/content/images/2021/03/Untitled3.jpg)

4 - Then I clicked on "Show Query Language"  
![SCCM Query](https://storage.ghost.io/c/08/96/08960c71-63a2-449b-91b1-8d4628166dd2/content/images/2021/03/Untitled4.jpg)

5 - Within the dialogue box that appeared I typed

![SCCM Query](https://storage.ghost.io/c/08/96/08960c71-63a2-449b-91b1-8d4628166dd2/content/images/2021/03/Untitled5.jpg)

6 - I then clicked OK and named my Query, then completed the wizard  
![SCCM Query](https://storage.ghost.io/c/08/96/08960c71-63a2-449b-91b1-8d4628166dd2/content/images/2021/03/Untitled6.jpg)

7 - My query appeared within the Query list and I was able to Run it.  
![SCCM Query](https://storage.ghost.io/c/08/96/08960c71-63a2-449b-91b1-8d4628166dd2/content/images/2021/03/Untitled7.jpg)

Which produced some results  
![SCCM Query](https://storage.ghost.io/c/08/96/08960c71-63a2-449b-91b1-8d4628166dd2/content/images/2021/03/Untitled8.jpg)

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,](https://www.techielass.com/uninstall-visio-2013-with-sccm/) that will help you uninstall Visio 2013 using ConfigMgr.