

I've put together a wee guide on how I implemented the query below:ġ - First of all I opened up my ConfigMgr console and navigated to the Monitoring tab and expanded "Overview".Ģ - Next I right clicked on Queries and selected "Create Query"ģ - Selecting "Edit Query Statement" nextĤ - Then I clicked on "Show Query Language"ĥ - Within the dialogue box that appeared I typedĦ - I then clicked OK and named my Query, then completed the wizardħ - My query appeared within the Query list and I was able to Run it. 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. These queries were last tested with Configuration Manager version 2006
