Is it possible to delete an SCCM client from SCCM console and its associated SQL Server database using SQL queries ? I would check for a few conditions and if it holds , I want that client to be deleted from SCCM.

Manually editing the database is not supported. Deleting a client using the ConfigMgr console will also result in deleting the corresponding client record in the database.

So can it be done only from SCCM console ? Is there any option to do the same via SQL queries on the SCCM database ?

Hi, As Torsten already decribed editing the database is not supported as well as not recommended,You can easily delete multiple clinets from the console itself.

You can download the ConfigMgr SDK if you want to automate such things, but there are no SQL queries used. It's a communication to the ConfigMgr provider using WMI.

Hi, You can use configmgr to send a package that will perform the client uninstall. That package will be advertised to a collection in the console which should ok for you. Once the client is removed, you can have another query that will list those clients you haven't heard from and then delete those. Once deleted from the console, they will also be removed from the database.Kent Agerlund | http://scug.dk/members/Agerlund/default.aspx | The Danish community for System Center products

Just delete it from the console.Follow me through my blog and Twitter!

Hi, It's not supported to directly delete a client from database, it's recommended to delete it from SCCM console.

Common Guys!!! Stop Saying that deleting from the DB is not supported, we know. What we realy need from you guys is the WMI command line to automate this result. We don't all work in place that the computer never move, be rebuilt,etc. Here, we can get more that 300 computers a week to delete since they have been deleted from the AD and we CAN'T wait couple of weeks to them to be deleted by the Maintenance Task. (And We NEED accurate) :) Thanks for your help!

There's no single command line available. http://blog.wisefaq.com/2010/03/31/deleting-computers-from-sms-2003-and-perhaps-sccm-2007-with-a-script/ should get you started.

Hi Common_Sence, There are tons of example where you can delete a PC from SMS / ConfigMgr using a supported method, Here is one that has been around for ever. http://blogs.msdn.com/b/rslaten/archive/2006/02/14/how-to-delete-an-sms-client-throughout-your-hierarchy.aspx http://www.enhansoft.com/