The Zurich release has arrived! Interested in new features and functionalities? Click here for more

Entity Relationship DIagram

Juan Vasquez1
Kilo Explorer

Good Afternoon,

I'm very new to ServiceNow. We are using perspectium to import tables into a local database. The problem I'm having is when the tables arrive they come without referential integrity. I can't generate a schema view from the application because I don't have the correct priveleges. I just need to see what the relationships are between the tables so that I can provide better guidance to analysts on how to obtain data for reporting.  I can't find the diagram anywhere. Also, if anyone has experience creating a dimensional model from servicenow tables, that would be really great. Just need to be pointed into the right direction.

 

Thanks

2 REPLIES 2

Omkar Mone
Mega Sage

Hi 

Navigate to Tables Module from Application Navigator . Select the table which you want from there. 

And the refer this Image :- 

find_real_file.png

 

Click this Show Schema Map in Related Links :- 

 

find_real_file.png

 

 

 

You would be able to see everything associated with the table.

 

Mark correct if it helps.

 

Regards,

Omkar Mone

www.dxsherpa.com

ben_nuttin
Kilo Contributor

Also, if you want a more tabular version of this information, you can go into System > Dictionary and look up any entry where the Type is "Reference". For example, for the incident table:

find_real_file.png