Custom Tables Deletion

[roomawakar]

Hi All,

We have to analyze all the custom tables under ITSM where it is being used so that we can delete all those which are not needed.

We need to do so because the limit to have custom tables in the Production environment has already been reached to 50.

Can anyone please suggest easiest way to check where are these tables being used like script, report, modules, etc.?

Thanks,

Rooma

[Hayo Lubbers]

Hi @roomawakar ,

A nice start is the code search from the SNUtils. It will search thru a large number of script fields and can be extended (suggestions are made by the code search page itself). It will check things like script includes, client scripts, service portal widgets etc.

For reports, you could add it to the code search check or query it yourself.

Most difficult afaik are the (old) workflows and flows. I have no quick tip here.

Hope this helps,

Hayo

[roomawakar]

Hi Hayo,

Do we need add this extension in our browser. Sorry, i haven't used this previously and have no idea how to use it.

Thanks,

Rooma

[Hayo Lubbers]

Hi @roomawakar ,

Yes, it is a browser extension with a lot of functionality. One of the main functionalities is the 'slashcommands' to navigate quickly thru the instance and offer some additional functionality, like the code search page.

If you have installed the plugin in your browser and reloaded the ServiceNow screen, you can just start by typing the /. E.g. /me opens the sys_user table with your own user.

When using /code <your tableName>, it will execute a search thru a large number of tables (it will be explained on the page with a link to extend) and will list all items where the tablename is mentioned.

All information, video tutorial + cheat sheet, is available on the SNUtils site from Arnoud : https://www.arnoudkooi.com/

The code search uses the out-of-the-box API to search (similar to the code search in scoped app from the studio).

Hmm, that has now the option to search also thru a lot of tables by default (even though I prefer the SNUtils :-)), you can open the studio and after selecting a scoped app, in the top right you have the code search:

Which popups a search where you need to select search all applications

Hope this helps.

Regards,

Hayo