200

sdm

sdm_norm_publisher=spl_publisher && sdm_norm_product=spl_norm_product && sdm_norm_version=spl_norm_version

cmdb_sam_sw_install

primary_key,

installed_on

300

si

si_primary_key = sdm_primary_key

cmdb_ci_computer

sys_id, location,

company,

400

scomp

scomp_sys_id=si_installed_on

End Database Result - Screenshot 2

Shoutout to @Brad Bowman for the information on setting up the hard table join.