Need to delete computer objects from CMDB but not server objects

[Ken Berger]

Hi folks,

We have been running an import set that pulls computer objects from SCCM into our CMDB.  I have been tasked with deleting all of these objects but the caveat is that I CANNOT touch any server objects (these would be any objects that were not puled in via this import set).  I have been trying to figure a way to query but any criteria I choose is not exact and still returns some server objects.

I did notice that the CMDB context menus show as a "Computers" and a "Servers" context menus separately.  If there is a way to query for items that are in the Computers list but NOT in the Servers list, this might do the trick.

Ultimately the goal would be to just delete the objects that were imported from SCCM.

If anyone has any suggestions, please help 🙂

Thanks!

Ken

[Robbie · Accepted solution]

Hi @Ken Berger,

There sure is (assuming the SCCM import has been configured to correctly to import the objects into the correct 'class').

You'll notice from the 2 links in the navigation menu ('Computers' and 'Servers') that the table opened is different.

Computers should open the 'cmdb_ci_computer' table (displayed in the URL at the top of the page).

Servers should open the 'cmdb_ci_server' table (displayed in the URL at the top of the page).

A key column to display into the list view when you click on these links is the 'class' column to confirm this categorisation.

Essentially, as long as you open up the 'Computers' link, the url displays the 'cmdb_ci_computer' table, and the class column also displays the class as 'Computer' for each of these records - you should be good to distinguish these 2 sets of CI's and delete appropriately.

Depending on your access, comfort, and preferred method of deleting, you can either select a record/numer of records at a time by clicking on the left-hand check box, or delete as per the number of rows you are displaying (eg 100 at a time), or delete all records in the query eg 1000+ records.

Before deleting any records, I would absolutely export these records as XML as a backup and also triple check you do indeed have the correct result to delete before doing so. 

To help others (or for me to help you more directly), please mark this response as correct and/or helpful.

Thanks, Robbie

[Robbie]

Hi @Ken Berger - Thanks for marking my response as helpful. 

Did this not solve your question? How can I help you resolve this?

To help others (or for me to help you more directly), please mark this response as correct and/or helpful.

Thanks, Robbie

[Ken Berger]

I marked as helpful and did some testing.  Now marked as solution.  Thank you!

[Robbie]

No worries at all @Ken Berger - Happy to help. I just wanted to make sure we closed it out or if I was missing something.

Thanks,

Robbie