

If you are looking for other articles on ConfigMgr I have a useful guide here, that will help you uninstall Visio 2013 using ConfigMgr. The above query will find any clients that have laptop as the first part of their name. can scroll to the right and see a lot of device properties as described previously.


In SCCM Console, Navigate to the Assets and Compliance > Devices. Check my configuration manager update size post for more details. The options are useful for the admins to perform quick troubleshooting for OSD deployments. You can search for a MAC Address in a device view of the Configuration Manager console. You can modify the ConfigMgr query to pull back the information from specific clients by using: Find Device from MAC Address in SCCM Console. 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. Using the NETDOM.EXE and the Nbtstat.exe support tools, I have scripted DomMAC.BAT to return the computer name and MAC address off all domain computers. These queries were last tested with Configuration Manager version 2006
