Use case of a custom table

[vanessaheux]

Hello

Is there a way to know the use case of a table ?
I have a custom table in my system which contains huge amount of entries.
I would like to know why this table stands for, where is it used exactly in order to evaluate if that could be a problem to delete it.
For example I would like the use case, to tell me that this table is used for reporting matters, that it is called in this client script or script include or in any custom application.

Can you help me ?

Regards
Vanessa

[Inactive_Us1474]

you can navigate to tablename.CONFIG to open the configurations of the custom table in the application navigator or right click and select the configure >> ALL options.

Hit Helpful/Correct, if applicable.

[Community Alums · Accepted solution]

You could try using a Global Script Search utility to search all code that may reference this custom table:

https://share.servicenow.com/app.do#/detailV2/d22836cf13763a001d2adbf18144b039/overview

As for looking for its usage within reports, etc that may well have to be a manual task. Maybe try searching the sys_app_module table for links that point to that table and what module they may live in, that could point you in the right direction.

One final tip could be to navigate to the "collection" dictionary entry for that table. In there, look for the 'Versions' related list (you can add this be right-clicking the form header, then clicking Configure > Related Lists) and hopefully you'll see the update set that created the table, assuming you have used update sets in your instance!

[scott barnard1]

Hi Vanessa

Ok you're going to have to do some investigation

1. First off is your table name a u_name or an x_name

If it's u_ it's likely a customisation in the global scope if it's an x_ then it's likely part of a scoped app.

2. Go into the table record and check out the application field. If there is a value here it's likely you'll find the app in the system applications section

3. In the table view Open the related lists and check out the versions - there may be some update set info there that can lead you back to a story.

4. Go to the history - it's only calendar view on table but it will tell you the data it was created. Check out the dev work done at that time on stories and changes

5. get the table name and type    table_name.config into the navigator search bar. It will pop up all the config on the tables.

Work your way through the config starting with the business rules, then the ui actions. You are looking for anything that touches records on another table.

6. Go to script search admin widget and type in the name of the table and see which scripts contain references to it.

7. Look at notifications and see if any use that table.

8. Check out pa data collectors, metrics, reports and db views to see if any query the table.

You can work out what it does but you are really looking for a link back to a Story that defines what it was for and who the customer was. If your not using SDLC then you may be stuck sifting change records.

hope this helps

[vanessaheux]

Thank you so much for that Global Script search , wonderful tool to help use case of anything.

That helped me a lot (to understand how that table was filled) but as you mentionned, we are not sure exactly what does the search, as for example it did not find that the table is used for reporting.

And perhaps I forget other subjects...