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🙂
Hi,
Yes, but for a report you can access the extended variables anyway. Like here I'm using cmdb_ci table but show the OS version from Computer table.
If you still want a database view you need to connect the tables using the sys_id. That's the only record that will be unique enough.
Regards,
Niklas
