Getting Duplicate entries for Software Lifecycle Report

[Pranita2]

Hello all,

I am trying to create a report for Software Lifecycle Report and have configured below but getting duplicate records.

Can anyone please let me know if there are any issue in the tables and queries due to which duplicates are generated in result.

Have also attached the Database view for the reference.

Any quick help is much appreciated.

sam_sw_product_lifecycle

100

spl

cmdb_sam_sw_discovery_model

200

sdm

sdm_norm_product=spl_norm_product && sdm_norm_version=spl_norm_version

cmdb_sam_sw_install

300

si

si_primary_key = sdm_primary_key && sdm_norm_type == 'Licensable'

cmdb_ci_computer

400

scomp

scomp_sys_id=si_installed_on