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 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. Out of curiousity, I have created a Query in SCCM 2012 SP1 Admin Console that lists all systems and their MAC addresses.
