List few Major tables in CMDB Management

[Raji10]

Hi All,

I'm trying to loop through some major cmdb tables to replace an existing group with the new group, can anyone please list down the major tables in cmdb such as cmdb_ci, cmdb_rel_ci etc.

As when I try to look for the tables related to cmdb, there are around 4250 in number, but I suppose only few tables are managed in the routine management.

Thanks & Regards,

Rajalakshmi.

[Chavan AP]

oh okay  refer below :

[Chavan AP]

i think this would be major CI tables

[AbhishekGardade · Accepted solution]

The configuration management database are following important table:

• The Base Configuration Item [cmdb] table, which is the core CMDB table for non IT CIs.
• The Configuration Item [cmdb_ci] core table, which stores the basic attributes of all the CIs. The admin, itil, or asset user role is required to access this table.
• The CI Relationship [cmdb_rel_ci] table, which defines all relationships between CIs.

The Configuration Item table is extended to other tables, such as Database [cmdb_ci_database] and Computer [cmdb_ci_computer]. The Computer table is extended to the Server [cmdb_ci_server] table, which is extended to the UNIX Server [cmdb_ci_unix_server] table, and so on.

Please mark as Correct Answer and Helpful, if applicable.
Thanks!
Abhishek Gardade
Hexaware Technologies