SCCM: Query to find clients with the same MAC address

  • Article

If you have multiple distinct clients with the same MAC address it will prevent the client from getting deployments.

Many OSD issues are caused by multiple discovery MAC for the distinct object.

Here is a query to help you to find clients with the same MAC address:

SELECT SMS_R_System.Name, SMS_R_System.MACAddresses
 
FROM  SMS_R_System
 
WHERE SMS_R_System.MACAddresses = ##PRM:SMS_R_System.MACAddresses##

The ##PRM: ## is used to prompt the user in order to enter the MACAddresses. All that you have to do is to create a query on Monitoring lab > Queries, copy the query, and then run it.