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

[Snehal13]

- 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.

[Snehal13]

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 

[Mark Roethof]

The tables are literally mentioned in the solution I shared.

[Sumanth16]

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

[Snehal13]

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