How to create a report to show the row count of some table?

[Jinye Gao]

hi there, i am new to servicenow.

there is a user case that need a report to show tableA, tableB, tableC's row count.

i try to create a report, but it only can choose one table.

i can code script to get the row count of each table, but it seems there is no union option in servicenow. and i did not find the way to make the report to call the script.

i totally have no idea.

could anyone help me with that?

[Maik Skoddow · Accepted solution]

Hi

yes, such a "report" is not possible.

BUT: You can create a report for each of the tables with type score (displaying just a number, see https://docs.servicenow.com/bundle/quebec-now-intelligence/page/use/reporting/concept/c_SingleScoreC...) and then place these reports on any dashboard (see https://docs.servicenow.com/en-US/bundle/sandiego-now-intelligence/page/use/reporting/task/add-repor...).

This is the usual way in ServiceNow and you can find such dashboards throughout the platform.

Maik

[Jinye Gao]

thanks a lot, it worked!!