Howto Clear out the CMDB

nathanshearer
Mega Contributor

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

1 ACCEPTED SOLUTION

Pradeep Sharma
ServiceNow Employee
ServiceNow Employee

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


View solution in original post

4 REPLIES 4

Pradeep Sharma
ServiceNow Employee
ServiceNow Employee

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
ServiceNow Employee
ServiceNow Employee

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!


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
ServiceNow Employee
ServiceNow Employee

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


Screen Shot 2017-01-19 at 8.55.52 AM.png