CMDB query builder

[anvitha ash]

Hello, 

I am a beginner to CMDB, need some help in building database view for CMDB base table(cmdb_ci) and other tables which is extending to base table. Here I am not sure what's going to be the common field with base table to all the extended tables. need to create database view for  cmdb_ci table with all the highlighted tables below 

can someone help  with this🙏

thanks in advance🙂

[Niklas Peterson]

Hi,

The "tables" in your image are all extended from the cmdb_ci table. Why would you need a database view combining child tables?

Regards,
Niklas

[anvitha ash]

Hello @Niklas Peterson ,

Thanks for responding back

Actually in the child tables we have 3 fields which is not available in parent table cmdb_ci.

while building the query builder we took CMDB classes as "configuration item". Now the problem is all the child tables which is extending the cmdb_ci we are getting all those fields . But, in child table we have 3 more fields which is not been extended from parent table and those fields are not visible in the query builder. so, we are creating database view 

[Niklas Peterson]

Hi,

OK, but the database view is a not CMDB class and will not be possible to select in the CMDB Query builder?

Regards,
Niklas

[anvitha ash]

Yes, but atleast we can create report

Want could be the common field in all those tables