Understanding ServiceNow Tables & Columns
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎09-28-2017 10:34 AM
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
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎09-28-2017 10:55 AM
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!
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎09-28-2017 11:07 AM
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?
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎09-28-2017 11:35 AM
Sheikh,
You write a script to get the table name and no. of rows.
Thanks
Rahamath
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎09-28-2017 11:37 AM
Do you have a sample script that i can use if that functionality is not OOTB?