Base table in cmdb

[pranjalsrvs]

Of the Ci tables, which is a base table of the CMDB hierarchy?

a) ECMDB

b) Cmdb_rel_ci 

c) Cmdb_ci

d) cmdb

e) Ecmdb_rel_ci

f) Ecmdb_ci

please explain

[WillieW]

goto a list of sys_db_object, query on name, 'is one of', and put in the list, review the 'Extends table' value.

[GlideFather]

Hi @pranjalsrvs,

correct answer is d) CMDB

Because base table is OOTB table with no parents, and cmdb table is extended with cmdb_ci  and others.

cmdb_rel_ci is abotu relationships and ecmdb with the "e" in the beginning doesn't exist.

Similarly, it's for [task[ table.

Refer to this:

ServiceNow 101 : Core table vs Base table vs Custom Table vs Parent table vs Extended table¨

Thank you for accepting my response as solution

[SD_Chandan]

As per Question 

d CMDB 

for configuration item - cmdb_ci

[Nikhil Bajaj9]

Hi @pranjalsrvs ,

Correct answer is:- Base table for CMDB is cmdb but for CI Class Manager [CMDB Hierarchy - Base table is cmdb_ci]

• cmdb_ci:

This table represents the core Configuration Item (CI) and stores the basic attributes of all CIs within the CMDB. 

• Other options:

• cmdb_rel_ci: This table stores relationships between CIs, referencing the cmdb_ci table to establish connections. 

• ECMDB/Ecmdb_rel_ci/Ecmdb_ci: These terms are not typically considered as the base table of the CMDB hierarchy. ECMDB might refer to an extended CMDB or a specific implementation of it, and the other related tables likely deal with specific relationships within the extended CMDB. 

Key point: The cmdb_ci table is the foundational table for all other CI-related data in the CMDB.