caspanama.blogg.se

> 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! 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.