Database view beween cmdb_ci table with other tables
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
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
can someone help me here please

- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
09-16-2023 06:26 AM
Yes. That is correct.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
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!