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
