Search the Community

Hello, Out of curiousity, I have created a Query in SCCM 2012 SP1 Admin Console that lists all systems and their MAC addresses. The query is not collection limited. 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. Here is the query syntax I'm using: select SMS_G_System_NETWORK_ADAPTER.MACAddress, SMS_R_System.Name from SMS_R_System inner join SMS_G_System_NETWORK_ADAPTER on SMS_G_System_NETWORK_ADAPTER.ResourceId = SMS_R_System.ResourceId I'm concerned that our process of building and rebuilding machines is causing duplication, triplication, etc of system records. Currently, we advertise our bare metal Task Sequence to unknown computers or computers in a specific collection. Once those machines are built, we move the computer object out of that build collection. 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. 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. I've attached an example duplication of a laptop machine, found in my query. Any help much appreciated. Daniel Melbourne, Victoria, Australia