Database view beween cmdb_ci table with other tables

anvitha ash
Tera Contributor

‎09-15-2023 11:09 AM

Hi,

 

I am trying to build database view between "cmdb_ci" table with "cmdb_ci_business_app", "cmdb_ci_desktop_software", "cmdb_rel_ci", "cmdb_ci_server"

 

I am stuck with what needs to be the where clause condition. I don't have exposure to CMDB tables and database view

anvithaash_0-1694801044810.png

 

can someone help me here please 

 

0 Helpfuls
  • 1,142 Views
6 REPLIES 6

Jaspal Singh
Mega Patron
Mega Patron
In response to anvitha ash

‎09-16-2023 06:26 AM

Yes. That is correct.

0 Helpfuls

Denise Smith
Tera Contributor
In response to Jaspal Singh

‎04-23-2025 09:26 AM

Hi Jaspal> quick ? I need help as beginner for getting info for 2 tables. Then I can create a report and filter on what more is needed from this view:
I need a database view to look at these 2 tables. If the VM instance (cmdb_ci_vmware_instance) is showing install status as 'retired'> I wish to see the server table (cmdb_ci_server) install status that may not show retired and should be for Windows and Linux servers.
Can you show me the database view and where clauses i need? thanks so much!