How to find number of custom tables?

[Piotr Sadowski1]

Hi,

could you help me please how can I find number of custom tables which were created?
I want to check if we do not reach the limit of 50 custom tables. I read this document custom-table-guide.pdf

Does such query on Tables [sys_db_object] should be good qualification to display all custom tables?

Or maybe there is a better way to find number of custom tables which were created?

Thank you for your help 🙂

[Piotr Sadowski1]

Hi @Jaspal Singh, I still don't have the satisfied answer - in Custom Table Inventory [ua_custom_table_inventory] it show me 24, but when I run query against Tables [sys_db_object] which start with u_ or x_ it shows me 61. Do you know why and which one is correct? Thank you for your help

[Jaspal Singh]

Ones that start with u_ or x_ which has count of 61 did you check what is the Extends table for those? Seems, a few apart from the ones you added might be a miss.

Custom Table Inventory is something that would be account for licensing if any & used by ServiceNow.

[Piotr Sadowski1]

Yes, I double checked those tables which are not included in Custom Table Inventory but start with u_ or x_ and found that 13 tables do not extend any table (Extends table=(empty)) and 1 table extends Task table. So I wonder why they are not counted in Custom Table Inventory

[Sulabh Garg]

Hello

Please check this SN Link "Monitor your custom Tables"

Please Mark ✅ Correct/helpful, if applicable, Thanks!! 

Regards

Sulabh Garg

[SumanthDosapati]

Hi @Piotr Sadowski 

Navigate to pa_dashboards.LIST

Search with name : "Custom Table Subscription Overview".

You can see the number of custom tables count there.

Mark as correct and helpful if it solved your query.

Regards,

Sumanth