Howto Clear out the CMDB

[nathanshearer]

We'd like to clear out our CMDB in our staging/development instance.  There are no records in this instance except testing records.  Would it be appropriate to:

1. Navigate to System Definition --> Tables

2. Open the Configuration Item table

3. Open the "Show List" link

4. Select all rows

5. Select Actions on selected rows... delete

Thanks,

--Nate

[Pradeep Sharma · Accepted solution]

Hello Nathan,

That's right. The other option is to delete all those records via background-script.

Reference:

Deleting All Records from a Table - ServiceNow Wiki

http://wiki.servicenow.com/index.php?title=Remove_All_Data_from_a_Table

[doug_schulze]

If memory serves me correctly there should be a background script available to tech support that clears out the CMDB.. You might open an incident to find out for sure.   If you are looking for individual tables then Pradeep's suggestion has you covered!

[nathanshearer]

Thanks.   I did that, and here is the basic method (slightly different than what I proposed):

1. Login to the instance
2. Navigate to the System Definition > Tables & Columns module.
3. Select the "Base Configuration Item [cmdb]" table from list of table names.
4. Click on the "Delete all records" button.

[Teena Singh]

Nathan,

Glad to see that you are using the Community to learn more.

The Customer Experience team is striving to ensure that customer queries posted from the HI Service Portal are answered in timely and accurate fashion.

If you feel your question has been resolved, please mark the appropriate reply in the thread as being the Correct Answer.

This enables other customers to learn from your thread.

Thank you in advance.

Regards,

Teena Singh
Customer Experience: UX Strategy and Customer Insights
teena.singh@servicenow.com

ServiceNow