CMDB query builder to fetch outer join data

jomonmathew
Tera Contributor

‎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?

0 Helpfuls
  • 894 Views
5 REPLIES 5

jparman
Tera Guru
In response to Bhavani Shankar

‎11-25-2025 05:11 AM

@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

0 Helpfuls