How to find mac address in sccm 2012 how to#

The WHERE statement is the condition by which results are filtered.

On the General tab of the Create Query Wizard, specify a unique name and, optionally, a comment for the query. I.e SCCM will record different MAC addresses. Select Create Query Find Device From MAC Address Using SCCM Query 1. We know the reason this happens is because how SCCM stores the records. Select Queries, Right-click on Queries, and choose Create Query. FROM SMS_R_SystemįROM statement indicates which table the information is stored in, in this case SMS_R_SYSTEM WHERE SMS_R_System.MACAddresses = #PRM:SMS_R_System.MACAddresses# In the Configuration Manager console, select Monitoring. You can use the query builder to add/remove fields to your preference. The SELECT statement is used to decide what information you would like retrieved by the Query in this case the following: SMS_R_System.Name You can use any physical address that is listed as the Host ID for the machine. Query Statement Explained SELECT SMS_R_System.Name, SMS_R_System.MACAddresses The getmac command will return a list of physical addresses for your machine.

You will be presented with the results for a particular MAC address.

> Enter the MAC Address you would like to query WHERE SMS_R_System.MACAddresses = #PRM:SMS_R_System.MACAddresses# You have a list of workstations and need to find their MAC addresses, you've SCCM in place but don't have console access, yep, that may happen friends. > Paste the following query into the Query Statement SELECT SMS_R_System.Name, SMS_R_System.MACAddresses > Comments: Brief description of what the query is for > Name: All Systems – Find Clients with a given MAC Address Having a browse around turns out this functionality already exists!

How to find mac address in sccm 2012 how to#

There are many ways to skin this particular cat but this seemed like a viable scenario to demo a how to query the ConfigMgr database to scan for instances where a client had a particular MAC Address. In this case the end-point would not behave as expected as the deployments the client would receive may not be the ones you expected. We discovered an issue on a client site where multiple distinct clients could have the same MAC address. Using SCCM to query the ConfigMgr database to find clients with duplicate MAC addresses. Found on .uk consolidating here for my own records