![]() On SMS_G_System_NETWORK_ADAPTER.ResourceId = SMS_R_System. If the query is shown stale records, you could add in where "client =1" (no sql access at the mo so can't write and test it) I'm not on a sql box now but try using a distinct statement in your query, and also start leaning to use abreviations in your queuries as well, will save you a lot of time, ABreviation is whatever you want it to be, I've used SYS and NDAP as an example below. The fact you have multiple MAC address for a laptop shown in your properties page means there are mulltiple network devices, eg Virtual NIC, WIFI, 3G card etc anything really that needs an IP Address so to speak. MAC Addresses are unique so rebuilding a machie makes no difference to the MAC address as its a physical hardware address that doesn't change. I've attached an example duplication of a laptop machine, found in my query. I don't know enough about how SCCM and SQL work together to handle records to know whether SCCM is capable of managing old records or whether our process needs attention. When we rebuild a machine, we sometimes delete the computer object completely and import it afresh, entering computer name and MAC address and choosing a destination build collection. Once those machines are built, we move the computer object out of that build collection. I'm concerned that our process of building and rebuilding machines is causing duplication, triplication, etc of system records.Ĭurrently, we advertise our bare metal Task Sequence to unknown computers or computers in a specific collection. On SMS_G_System_NETWORK_ADAPTER.ResourceId = SMS_R_System.ResourceId When it opens, navigate to Network & Internet. Alternate MAC address -> Clear Console will restart, relaunch app and see. To find your MAC address in Windows 10 or 11, open Settings by pressing Windows+i on your keyboard. ![]() ![]() The query delivers many results, but I'm concerned that there are many instances of duplication, where a given machine with a certain MAC address is listed multiple times. Method 1: Through Windows Search Menu Method 2: Run Task Manager as Admin from. Out of curiousity, I have created a Query in SCCM 2012 SP1 Admin Console that lists all systems and their MAC addresses.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |