Is there a way to determine what tables we are using and if so can we get the schema maps for the tables?

lukesmitty · ‎08-16-2016

Is there a way to determine what tables we are using and if so can we get the schema maps for the tables? I know I can go to individual tables and click "Show Schema Map" but I was wondering if there are any other options. Thanks.

Chuck Tomasi · ‎08-16-2016

Hi Luke,

Thanks for the clarification. As odd as it may seem, this is not a common request and as such, we have built a lot of traditional DBA tools to assess which tables are being used. If a table is audited, you could get some evidence from sys_audit or sys_history_line. There are going to be a lot of system tables (like those just mentioned) that are there to maintain the system and nobody really cares about.

Rather than throwing them 2000 tables, it would be helpful to know what they are reporting on. Let's drive the inputs based on the outputs. After all, who's going to read a report on how many times the browser requested an object?

As for ACE, you can make a request via your ServiceNow implementation team to have an ACE report run. It looks to see how your implementation is doing against the known best practices and flags any bad practices that could be a performance, usability, or maintainability risk.

Contact Us - ServiceNow

View solution in original post

Pradeep Sharma · ‎08-16-2016

Hi Luke,

I don't think there is a way to check schema map for all tables in one go. You need to navigate to individual table to get to schema map.

Schema Map for Tables - ServiceNow Wiki

johnram · ‎09-22-2017

The ServiceNow Wiki content is no longer supported. Updated information about this topic is located here: Schema Map for Tables

Visit http://docs.servicenow.com for the latest product documentation

Uncle Rob · ‎08-16-2016

I'm going to assume you want to know what tables you're using to for some kind of internal licensing check.

If that's the case, lets narrow our scope to just task types, since that's all that really governs license spend (with a couple exceptions)

I'd run a report on base Task, over the past year, then group your results by the Task Type. That will show you what task tables you use, which shouldn't be too hard to link up to the different license types ServiceNow sells.

JC Moller · ‎09-23-2016

Hi,

Nashco Consulting has put together a top level document of the ServiceNow data model.

Download it here:

http://www.nashcosolutions.com/professional-services/#_SNDM

- Jan