Create a Database view with cmdb_ci and cmdb_ci_business_App

Not applicable

I want to create a database view combining two tables:

1) cmdb_ci

2) cmdb_ci_business_app

 

There is a field called "BXYZ" on business application. (not on cmdb_ci)

Both table has a common field "ABC". (both table has ABC field)

 

I want to create a dependency view in which Name(CI field), Class(CI field) and BXYZ(Business app field) should appear.

How to do that, I'm not able to set the where clause.

1 REPLY 1

Pradeep Thipani
Mega Sage

Hi @Community Alums ,

 

You can create database views based on the fields and tables you needed.

 

Where clause: tableprefix1.fieldname1 = tableprefix2.fieldname2 or tableprefix1_fieldname1 = tableprefix2_fieldname2.

 

Sample example:

PradeepThipani_0-1753722717651.png

 

Please try using the reference I provided. If you're unable to proceed, kindly share the exact field name you're referring to so I can assist you further.

 

Thanks,

Pradeep