Compare columns in cmdb_ci_* tables

[Earl L]

As all of you CMDBers know, there are many, many tables in the CMDB, that all have names starting with cmdb_ci_*. This is the typical parent/child table scenario that we see in lots of other places within the SN platform. I realize that these are probably not the same as me creating a custom table that extends the base cmdb_ci table, but I don't think that's relevant. Please read on.

The question is: is there a built-in tool, anywhere in the platform, that will do a quick comparison of the columns that are in one table vs. another table?

With so many cmdb_ci_* tables in the platform, I'd like to get an idea of just how some of these tables differ, and help point us in the direction of which ones to use and leverage now vs. those that we can probably save for a rainy day.

[VaranAwesomenow]

there is a servicenow share app. (CMDB - CI Comparer)

ServiceNow Share

[Earl L · Accepted solution]

Duh! just looked at the schema map and it looks like it will show me exactly what I want.

[LaurentChicoine]

To quickly see the columns that are specific to a table I usually use the dictionary (sys_dictionary.list) and create a filter Table = cmdb_ci_*.

However this does not compare tables, simply shows specific to that table related to the fields of it's extended table.

[Earl L]

For example, here's a screenshot of the IP network table hierarchy.