question Re: How to find amount of customisation on a ServiceNow sub prod instance ? in Developer forum

How to find amount of customisation on a ServiceNow sub prod instance ?

Snehal13 — Sat, 03 Aug 2024 16:17:59 GMT

- How to find amount of customisation on a ServiceNow sub prod instance ? Like while loading forms, or saving records etc. Not want to check every table and see the scripts on them, any better way to drill them at a instance level ?

- How to get the total consumption of worker nodes as per the running transactions on the instance ?

The objective is to infer amount of load on memory and workers due to long running jobs/transaction/queries etc ?

When checking slow queries, long running transactions, it does not provide details on the amount of memory they consume and how much they make other jobs wait.

Re: How to find amount of customisation on a ServiceNow sub prod instance ?

Bert_c1 — Sat, 03 Aug 2024 16:41:54 GMT

Try using 'stats.do' in the instance URL. Lots of related info there for the application node.

For customizations, look at the update sets in the instance.

Re: How to find amount of customisation on a ServiceNow sub prod instance ?

Mark Roethof — Sat, 03 Aug 2024 16:43:03 GMT

Hi there,

See this question earlier today where I answered a similar question on customization:

https://www.servicenow.com/community/now-platform-forum/how-to-trace-customizations-in-servicenow/m-p/3008259

Re: How to find amount of customisation on a ServiceNow sub prod instance ?

Sumanth16 — Sun, 04 Aug 2024 05:57:57 GMT

Hi @Snehal13 ,

You may use Update Version (sys_update_version) table for your analysis. It persists any change to existing object (table, field, script..etc) and new objects too.

For any existing object, it would have more than one record if it was customized.

New records many have only one entry too. But you may find out the new ones by checking the creation date and any reference between parent object (for example new field added in incident table).

Hope this helps. Mark the answer as correct/helpful based on impact.

Thanks & Regards,

Sumanth Meda

Re: How to find amount of customisation on a ServiceNow sub prod instance ?

Snehal13 — Sun, 04 Aug 2024 14:39:16 GMT

So can I create a report on categorisation of how much % is custom - scripts, custom tables, scheduled jobs, etc

Re: How to find amount of customisation on a ServiceNow sub prod instance ?

Mark Roethof — Sun, 04 Aug 2024 14:40:16 GMT

Sure, why not?

Re: How to find amount of customisation on a ServiceNow sub prod instance ?

Snehal13 — Sun, 04 Aug 2024 14:40:53 GMT

can I create a pie chart type report on categorisation on how much is custom scripts, custom tables, scheduled jobs etc

Re: How to find amount of customisation on a ServiceNow sub prod instance ?

Snehal13 — Sun, 04 Aug 2024 14:43:05 GMT

Great! Which table to report on ? My purpose is to take this report to management and show the amount of customisation done without any regard to OOB

Re: How to find amount of customisation on a ServiceNow sub prod instance ?

Mark Roethof — Sun, 04 Aug 2024 15:07:20 GMT

The tables are literally mentioned in the solution I shared.