Create a Database view with cmdb_ci and cmdb_ci_business_App
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
07-28-2025 09:53 AM
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.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
07-28-2025 10:14 AM
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:
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
Regards,
Pradeep