CMDB query builder to fetch outer join data

[jomonmathew]

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?

[jparman]

---

@Bhavani Shankar wrote:

@jparman, can you give more details about the requirement?

---

i want to create a list report in servicenow

Table 1: cmdb_sam_sw_install
Filter: Display name = Adobe Systems Creative Cloud
Columns to display in report:

1. Display name
2. Assigned to
3. Last Used

Table 2: samp_sw_subscription
Filter: Display name = Adobe Systems Creative Cloud
Columns to display in report:

1. Display name
2. User
3. Last Activity

I want to join this table on User = Assigned to. But I also want to show if the User is in samp_sw_subscription and Assigned to is not in cmdb_sam_sw_install.

I want this data in just 1 list report