HELP! Machine deleted from all systems collection but still in database

[glen8]

Hi all,

 

ARGH! SCCM 'could' be so good if it wasn't for the little niggles.

 

There is a machine on our network which won't PXE boot. We had the TS assigned to two collections. 'Unknown computers' and 'Windows XP Deployment'. So long as I can get the machine to PXE boot I'm not bothered. The machine was in the all systems collection so I have deleted it.

 

Then I tried booting the machine up thinking it would be detected as an unknown computer.....nope

 

Then I tried putting the machine name and MAC into a txt file and loading this into the Windows XP Deployment collection.....nope.

 

The reason is that although I have deleted it from the all systems collection it is still being picked up when I go to the queries > all systems. I've just rebooted the server in the hope that syncs everything with the database but after the reboot it's still the same.

 

How to I delete this machine? Grrrrrrr!

 

Thanks!

[glen8]

Not sure if this is the best way around this problem but I created a SQL task to run this command

 

delete from v_R_System where ResourceID = EnterIDHere

 

Set the time for 1 minute in the future and hey presto the machine has actually gone. Must just be an issue with our server as to why it takes a long time for the database to sync with configmgr

[Trevor Sullivan]

I would strongly recommend against doing what you did -- modifying the ConfigMgr database directly can have unexpected results.

 

The proper way to delete a resource would be to remove it through the SCCM WMI provider: Here's a PowerShell script that should delete it for you:

 

$SccmResource = @(Get-WmiObject -Class SMS_R_System -Namespace root\sms\site_lab -Filter "Name = 'SCCMCLIENT01'")[0]

$SccmResource.Delete()

 

Replace "lab" with your three-digit site code, and replace "SCCMCLIENT01" with the target client name.

 

Hope this helps.

 

Cheers,

Trevor Sullivan

http://trevorsullivan.net

http://twitter.com/pcgeek86

[glen8]

ok thanks very much for that

 

question though, why isn't the machine being deleted from the database anyway?

[Trevor Sullivan]

I couldn't say for sure, but I would guess that maybe it's a console bug? Try the PowerShell code next time and see if it disappears.

 

That code I posted only deleted the first resource returned with that name, so if there are multiple resources, you may need to run it repeatedly.

 

Alternatively, try this:

 

Get-WmiObject -Class SMS_R_System -Namespace root\sms\site_lab -Filter "Name = 'SCCMCLIENT01'" | % { $_.Delete() }

 

Hope this helps.

 

Cheers,

Trevor Sullivan

http://trevorsullivan.net

http://twitter.com/pcgeek86

[Babs]

I'm looking to do the inverse of the above. I removed a collection and inadvertently removed the devices from the DB. How do I rebuild the DB so said devices repopulate in my "All Systems" collection?

[Babs]

I found the answer to my own question. I merely had to rerun my Active Directory System Discovery.