Understanding ServiceNow Tables & Columns

sayub
Tera Contributor

I am new to ServiceNow and i want to start reporting in ServiceNow using PA. Although i understand that CMDB_CI and Task are the main Core

tables; and then there are bunch of parent and extended tables in Service e.g. incident/Application and other derived tables from the Core tables etc.

I want to report on Cloud account and cloud billing cost/incidents/changes and other discovery related data such as applications/software etc. Now i see incident tables that is derived

from Task; but i am getting confused when there are whole bunch of extended tables; and to add to the confusion i see multiple tables for cloud billing and then there are bucket tables called pa_bucket and group etc etc used for breakdowns in reporting.

Is there is crash course document that i can refer to which has table list along with what data that table has (not just the core/base because i see it on service now doc)

so it contains description of value in the table for easier reference (sys_dictionary only shows the table and columns but no description). Or even if someone has documented e.g. 50 main tables used for reporting all the time; will be really helpful as well

Also is there is a way to query only the table name in the sys table list that are not empty and have more than 1 record in the table.

Thanks,

Sheikh

6 REPLIES 6

shruti_tyagi
ServiceNow Employee
ServiceNow Employee

Hi Sheikh,



Check if this will help:



http://wiki.servicenow.com/index.php?title=Tables_and_Classes#gsc.tab=0



http://wiki.servicenow.com/index.php?title=Schema_Map_for_Tables#gsc.tab=0



Thanks


Shruti


If the reply was informational, please like, mark as helpful or mark as correct!


Well i have gone over all those documents. But it only show the basic parent and Core tables, e.g. if i want to report on cloud billing; the list doesnt show that. plus do you know how to filter the list of tables in sys_dictionary to only display the lsit of tables that have data and not all?


Sheikh,



You write a script to get the table name and   no. of   rows.



Thanks


Rahamath


sayub
Tera Contributor

Do you have a sample script that i can use if that functionality is not OOTB?