Join the #BuildWithBuildAgent Challenge! Get recognized, earn exclusive swag, and inspire the ServiceNow Community with what you can build using Build Agent.  Join the Challenge.

SAM Software Duplicates

Andreas
Tera Contributor

Hello everyone,
I might want to adjust the data source for SCCM-SG-SCCM Software and SCCM-SG-SCCM Removed Software, as not all installations are found in the add_remove_programs table. Therefore, I would like to modify the SQL query. However, I want to avoid duplicates during the import process.
Could someone explain the logic or where it is checked whether a software installation of the program and the computer already exists in the cmdb_sam_sw_install table, and whether a new entry should be created or not?
Thank you in advance.😄

0 REPLIES 0