Orphaned mac address records remain in SQL for imported computer deleted from SCCM
I have SCCM current branch 1810 running on W2K12. The SQL DB is running on SQL 2012 on a separate W2K12 server.
I have mistakenly imported computer information for a single computer and used the wrong machine name. After deleting that computer and re-importing it back in, I now have two records in V_RA_System_MACAddresses with the same mac address (and two different ResourceID's). I deleted the correctly name computer from SCCM, and I still have two MAC Address records.
Is there a way to get rid of these orphaned records? I confirmed neither ResourceID shows up in V_R_System. I'm not sure where else to look.
I can't get deploy an OS to this computer until I get rid of these duplicate mac address records.
Any help is greatly appreciated!!
I have mistakenly imported computer information for a single computer and used the wrong machine name. After deleting that computer and re-importing it back in, I now have two records in V_RA_System_MACAddresses with the same mac address (and two different ResourceID's). I deleted the correctly name computer from SCCM, and I still have two MAC Address records.
Is there a way to get rid of these orphaned records? I confirmed neither ResourceID shows up in V_R_System. I'm not sure where else to look.
I can't get deploy an OS to this computer until I get rid of these duplicate mac address records.
Any help is greatly appreciated!!
ASKER
Just an fyi for anyone interested, the orphaned MAC addresses have apparently aged out of my SCCM database. I can no longer find them.
So patience pays off I guess....
So patience pays off I guess....
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Duplicate MAC adresses in that table won't matter when its not linked to a resource.
Reimport the computer and check if it now is linked to a ResourceID.
Are you doing a PXE boot? if yes from MDT or the SCCM internal PXE?