
Select the Show Query Language button and paste in the following: Give your query a name and select Edit Query Statement. Go to properties of your collection, select the Membership Rules tab and select Add rule, query rule. To do this I’ll assume you’re proficient in creating collections: Now you can create your ConfigMgr collection query in a very similar way. Don’t forget to change the CM_TST value to represent your site name. If you comment out the WHERE line (with - before it) you can browse the available network card descriptions for your estate.
SEARCH FOR MAC ADDRESS IN SCCM 2012 CODE
That query will essentially show you any record that has an error code value of anything other than 0 (zero) for a ‘Microsoft Teredo Tunneling Adapter’. WHERE ConfigManagerErrorCode0 != ” AND Description0 = ‘Microsoft Teredo Tunneling Adapter’ It is NOT supported or recommended to meddle with your ConfigMgr database but if you do wish to check (entirely at your own risk) then you might want to run something like this:įROM. There is no need to deploy anything further, the info will start collecting in your SQL database. This will now ensure that your ConfigMgr clients pull back the error information for their network cards. If you want some further info on the Win32_NetworkAdapter WMI class then go here. Now expand Network Adapter and select the ‘Config Manager Error Code’. To do this from your ConfigMgr 2012 console go to:Īdministration>Client Settings, hit properties from the ribbon and select Hardware Inventory. So, this is where the power of ConfigMgr comes into play.įirstly you need to extend the hardware inventory of your ConfigMgr clients to include an additional WMI property.

Until you can identify the machines with the issue you’re going to struggle to find the root cause.
SEARCH FOR MAC ADDRESS IN SCCM 2012 DRIVER
It may be a particular machine model, a bad driver you have, who knows. The task is to get a list of the machines using ConfigMgr 2012 which are affected by this and then you can work on narrowing down the problem.

So here’s the scenario, you’ve been told that there are machines showing a network adapter with an exclamation and error in windows device manager.
