Use case of a custom table

vanessaheux · ‎05-23-2018

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

Community Alums · ‎05-23-2018

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!

View solution in original post

scott barnard1 · ‎05-23-2018

Hi Vanessa

If my reply helped please mark it helpful 🙂

Good look in your searching