![How to query a mac address in sccm](https://cdn1.cdnme.se/5447227/9-3/6_64e61dfae087c31b411cc5f3.png)
In each if condition we combine $SerialNumber with a dash and at the end a suffix for either a workstation or laptop. Then we create two if conditions depending on the computer model (in this case laptop or workstation). We begin with populating two variables, $ComputerModel and $SerialNumber data from WMI. In this blog post I’m performing OSD on Dell systems, but the script can easily be modified to support other vendors. Secondly we want to name the computer by using the serial number and a suffix, e.g if it’s a workstation or laptop. First we need to determine what computer model the OS is being deployed on. In this blog post we’ll be renaming the computer based upon two critera. I’ve previously blogged about how to do it with VB script, you can find that blog here. If you are looking for other articles on ConfigMgr I have a useful guide here, that will help you uninstall Visio 2013 using ConfigMgr.There are various of methods out there today on how you can automate the process of naming computers during OSD. The above query will find any clients that have laptop as the first part of their name.
![how to query a mac address in sccm how to query a mac address in sccm](https://www.manishbangia.com/wp-content/uploads/2022/06/CreateSCCMQueryMac_02-1024x154.png)
![how to query a mac address in sccm how to query a mac address in sccm](https://www.anoopcnair.com/wp-content/uploads/2022/06/Find-MAC-Address-for-Device7.jpg)
You can modify the ConfigMgr query to pull back the information from specific clients by using: 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.
![how to query a mac address in sccm how to query a mac address in sccm](https://i.ytimg.com/vi/v0BJhCwZdDI/maxresdefault.jpg)
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
![How to query a mac address in sccm](https://cdn1.cdnme.se/5447227/9-3/6_64e61dfae087c31b411cc5f3.png)