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

Chuck Tomasi · ‎08-16-2016

Hi Luke,

Can you clarify what you mean by "what tables we are using"? Also, is there a business reason behind this or just for general curiosity?

lukesmitty · ‎08-16-2016

Hi Chuck. A business partner came to me with this question and they are writing reports. The schema maps would help them with dot walking. They don't have access to view the schema maps like a Sys Admin does so they were wondering if I could provide them a list of the tables we're using in the system along with the schema maps. There are over 2K tables in ServiceNow and I don't know how to tell which ones we're using. I know a lot of them in my head 😃 but not all of them and the only option I'm aware of for retrieving schema maps are from the tables and clicking the option to show them.

The business partner also mentioned ACE report which appears to be a ServiceNow report about issues in the system not necessarily the tables we're using. It seems they found some information about ACE reports on the Wiki.

Thanks,
Luke

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

lukesmitty · ‎08-16-2016

Thanks Chuck. I will follow up with the BP and see what they are trying to report on.

Thanks,
Luke