Find your people. Pick a challenge. Ship something real. The CreatorCon Hackathon is coming to the Community Pavilion for one epic night. Every skill level, every role welcome. Join us on May 5th and learn more here.

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