Table structure - finding data of specific table(s)

[machzreik]

We recently migrated away from ServiceNow but when we had it, we used these parts in our instance:

• Incidents
• Problems
• Changes
• COE (Custom)

We asked ServiceNow to provide us with an export of our data so we can import into our new system. They provided us with a MariaDB that's around 15GB zipped and 39GB unzipped.

The database contains 8927 tables, but we’re unable to find any tables that stores the COE data. It seems these tables are for backend data of Service Now internal fields. Is there any way that we can take a look at what the table structure is and where the tables/data is for our COE component?

We've asked Support for help and they said because our contract is expired, all they can do is point us to KB articles.

https://www.servicenow.com/community/itsm-articles/attachments-in-servicenow/ta-p/2305632

https://support.servicenow.com/kb?id=kb_article_view&sysparm_article=KB0995336

 https://support.servicenow.com/kb?id=kb_article_view&sysparm_article=KB1123074

I've looked through these links and it doesn't look like they have what we're looking for.

Can anyone provide any guidance?

Thanks!

[Ratnakar7]

Hi @machzreik ,

It can be difficult to locate specific data in a large database like ServiceNow without knowledge of the table structure. However, there are a few options you can explore:

1. Use the "Tables" module in the ServiceNow platform: The Tables module provides a list of all tables in the instance, as well as their relationships to each other. You may be able to locate the tables you need by browsing through the list.

2. Use a database exploration tool: If you have access to the unzipped MariaDB file, you can use a tool like MySQL Workbench to explore the database schema and search for specific tables or fields.

Thanks,

Ratnakar

[machzreik]

Thanks for the suggestion. Unfortunately for your first point, we no longer have access to our SN platform. We received an export of our data though and that's what we're trying to sift through.