Create a Database view with cmdb_ci and cmdb_ci_business_App

HrishabhKumar
Kilo Sage

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 @HrishabhKumar ,

 

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

 

 

"If this response was useful, please select 'Accept as Solution' and mark it as 'Helpful.' This helps me provide better answers and assists the community ".

Regards,
Pradeep