List few Major tables in CMDB Management

Raji10 · ‎10-21-2019

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.

AbhishekGardade · ‎10-21-2019

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

Thank you,
Abhishek Gardade

View solution in original post

AbhishekGardade · ‎10-21-2019

Check out this thread for table names

https://community.servicenow.com/community?id=community_question&sys_id=e6ed33f9dbb13300a39a0b55ca96...

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

Thank you,
Abhishek Gardade

Chavan AP · ‎10-21-2019

ServiceNow adds new classes in every major release. Each CMDB class is stored as a table. If you want a complete list of all CMDB classes in your version, open the table: sys_db_object and query all names that start with "cmdb_ci". In London, it will return around 755 tables and you can export that to a spreadsheet or a report.

For a complete list of the attributes for each Class, you can open the table sys_dictionary and filter all rows where the "table" field contains "cmdb_ci". It will list each attribute of those CMDB classes (tables). You can export this to a spreadsheet as well.

Glad I could help! If this solved your issue, please mark it as ✅ Helpful and ✅ Accept as Solution so others can benefit too.*****Chavan A.P. | Technical Architect | Certified Professional*****

Chavan AP · ‎10-21-2019

Type one of these commands in the search box of the navigation bar.

ServiceNow tables:
sys_db_object.list

ServiceNow attributes:
sys_dictionary.list

Glad I could help! If this solved your issue, please mark it as ✅ Helpful and ✅ Accept as Solution so others can benefit too.*****Chavan A.P. | Technical Architect | Certified Professional*****

Raji10 · ‎10-21-2019

Hi Ajay,

Yes, I used tables and dictionary to get all the cmdb related tables. My question was to get a list of only major tables in CMDB to play with.

Thank you