Reload or Refresh Location Data ('cmn_location' table) in ServiceNow PDI

[WazzaJC]

Hi Team,

I would really appreciate your help, if anyone has had to do this before.

How can I reload/refresh from scratch, all the Locations data contained in the cmn_location Table in my ServiceNow Personal Developer Instance?

I have managed to corrupt the data by change all location types to 'Floor' in error, when performing an Update All function.

I need to reload the original locations data from scratch, which contains Building, Floor, Room, City, Country etc etc.

Is there a way I can reload/refresh brand new data into my PDI, so that I have the original Demo Locations Data available in my PDI?

I would greatly appreciate any advice on how to achieve this - thanks so much team 🙂

Kind Regards, Warwick

[Sai Shravan · Accepted solution]

Hi @WazzaJC , 

To reload the original demo locations data in your ServiceNow Personal Developer Instance, you can follow these steps:

1. Log in to your ServiceNow PDI instance with an admin account.

2. Navigate to the cmn_location table by searching for "Location" in the navigation menu or typing "cmn_location.do" in the URL.

3. Click on the "Delete all records" button in the top toolbar to delete all existing records in the table.

4. In the navigation menu, search for "System Clone" and click on "Create Clone" to create a new clone of the ServiceNow demo instance.

5. Select "Location Data" as the data to be included in the clone and give the clone a name.

6. Click on the "Create Clone" button and wait for the clone to be created.

7. Once the clone is created, navigate to the cmn_location table again and verify that the original demo locations data is now present.

Note: Creating a clone of the ServiceNow demo instance can take some time and may require additional resources depending on the size of the data being cloned. Also, be sure to back up any customizations or data in your ServiceNow PDI instance before deleting any data or creating a clone.

OR 

You can release this instance and request for a new Instance, in which you will be get all the demo data from scratch, on the other side you will miss the data you worked on other modules. To avoid that take the backup of the work you have done.

Regards,

Shravan

[WazzaJC]

Hi Sai,

Please can you help me further. These steps don't seem to work for me.

I have no option to 'Create Clone', within 'System Clone' in Filter Navigator?

Do I have to install a certain plugin - there is no option/button where I can Create Clone or an option to just select Location Data.

Could you please help clarify for me further.

Many thanks, Warwick.

[Sai Shravan]

Hi @WazzaJC ,

Below is the reference ServiceNow document for the system clone

https://docs.servicenow.com/bundle/utah-platform-administration/page/administer/managing-data/concep...

I hope this helps you 🙂