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