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]

Dear Earl,

This is functional, but if you have opportunity try out that share app I sent on your personal dev, its really very useful.

Best Regards

Anil

[Earl L]

Anil,

I'm not interested in comparing two CI's. I'm wanting to compare and analyze the structure of two different CI tables. Very different things. But if I ever do need to compare CIs I'll keep this in mind.

Earl

[VaranAwesomenow]

makes sense,

cheers

Anil