Answered by:
SCCM 2012 Deleted machine is not deleted

Question
-
Trying to delete a machine from SCCM console. After clicking "DELETE" and confirming, the machine is removed from the console, but remains in the database.
When running a TS targeted at UNKNOWN system, the WinPE environment reports no task sequences available. Running the query below ususally shows me a NULL record and a decomissioned record when the machine is removed and "UNKNOWN".
SELECT ma.MAC_Addresses0, s.* FROM dbo.v_R_System s RIGHT OUTER JOIN dbo.v_RA_System_MACAddresses ma ON s.ResourceID = ma.ResourceID where ma.MAC_Addresses0 like '<insert MAC>'
In the past, it has taken up to 2 hours for some voodoo in SCCM to cleanup deleted devices, but in this case I've waited overnight and still the DB shows a null record and no decomissioned record. When querying the device from SCCM console, the device appears to have been removed. When querying for the MAC (in the MAC Address report), no qualifying machine appears.
Now I have a bricked laptop that I can't lay down a new image on because SCCM doesn't recognize that it's not recognized. Any help appreciated before I heave this POS off the 17th floor.
Friday, May 17, 2013 2:36 PM
Answers
-
I'd say the change is pretty much immediate. I usually wait about 15 minutes after deleting the unknowns before trying again, but that's mostly because I also have to delete AD objects and wait for replication.
- Proposed as answer by Garth JonesMVP Saturday, February 14, 2015 12:52 AM
- Marked as answer by Garth JonesMVP Tuesday, October 27, 2015 4:03 PM
Friday, May 17, 2013 3:11 PM
All replies
-
Hi,
Do you have anything showing up the the Devices list that shows as Unknown (NOT x86 Unknown Computer or x64 Unknown Computer) in the Name column? I've had machines that failed OSD end up listed this way that would stop me from reimaging them until the Unknown item was deleted.
Friday, May 17, 2013 2:51 PM -
Thanks, Mike.
I found 31 "unknown" devices and deleted them. After doing this, did you have to wait the 2 hours for SCCM to cleanup or was the change immediate?
-=Berns
Friday, May 17, 2013 2:59 PM -
I'd say the change is pretty much immediate. I usually wait about 15 minutes after deleting the unknowns before trying again, but that's mostly because I also have to delete AD objects and wait for replication.
- Proposed as answer by Garth JonesMVP Saturday, February 14, 2015 12:52 AM
- Marked as answer by Garth JonesMVP Tuesday, October 27, 2015 4:03 PM
Friday, May 17, 2013 3:11 PM -
It took over 3 hours from when I deleted the "unknown" devices. SCCM magically cleaned up and now I see the decomissioned record in the DB query I posted above.
I love this Mickeysoft Voodoo.
Friday, May 17, 2013 7:38 PM