ServiceNow Data Model

Most of the SnowMirror users benefit from replicated ServiceNow database for reporting or business intelligence purposes. They connect their tools to a mirror database to work with the ServiceNow tables. However, to build a great report, dashboard or analysis you have to understand the ServiceNow data model very well. You have to know which tables to download to be able to construct your queries. ServiceNow contains hundreds of tables so where to learn more about its data model? Here are tips to get started.  

1. ServiceNow Schema Map for Tables

If you want to see a portion of the data model, for example, the surroundings of an incident table, then you might make use of the embedded ServiceNow feature to display a schema map. The schema map displays the details of tables and their relationships in a visual manner. To generate a schema map:

1. Navigate to System Definition > Tables & Columns.
2. In the Table Names pane, select a table.
3. Click Schema map.
4. The schema map for the selected table opens in a separate tab or window.

You can learn more about the schema map more on the Wiki or in the new Product Documentation Portal.

2. Model by Nashco

There is a Canadian ServiceNow partner called Nashco and they are providing a simple data model as a document to help identify the relationships between the main entities and how different applications are extended. You can also subscribe to be notified when a new model is issued. Direct link to the latest model: ServiceNow-Data-Model-v3.4.pdf

3. Tables by Processes

Sometimes the best way to start is to start simple. So we are providing a very basic guide below which contains a list of tables organized by processes. If you need to produce reports in an incident management process just configure SnowMirror to replicate the tables from the list. Of course, if the ServiceNow instance is customized or if you have more than basic reporting requirements then you might need additional tables.