List of record counts in each table?

vprakash
Giga Contributor

Is there somewhere I can see a list of all the tables in ServiceNow and how many records each has?

6 REPLIES 6

try


select count(*) from task



and see what that says, but I am not a MySQL expert so I have no idea when the data in INFORMATION_SCHEMA.TABLES gets updated.


Subhajit1
Giga Guru

Hi VPraksah,



As already stated, there is no way you can get this Data from ServiceNow Application


But this data can be very easily obtained by your DBA.


If yours is an On-Premise Instance, connect with your Org's DBA team, otherwise raise a request on HI portal for this.



Regards,


Subhajit