CMDB query builder to fetch outer join data
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎07-17-2023 06:04 AM
I am trying to build a cmdb query using cmdb query builder to have report of application to server to esx server. I am getting report. But the problem is that it is not fetching data if the server to esx server relationship is not existing. Also I have more level up with business service is parent of application.
if report on 4 levels there is so many data missing if there is relationship missing in the chain. Can you suggest how to get outer join in this case?
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎07-17-2023 06:59 AM
Hi @jomonmathew ,
If you need to join multiple tables for a report, the best solution is to use database view.
Please follow the link to create one :
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎03-30-2024 02:41 PM
Was a solution ever determined for this? I'm having the same issue and database views are not an option due to the complexity of the query and the load time that would be involved. Can we perform left outer joins with CMDB query builder?
