Automatically delete obsolete CI in Integrationhub ETL integration

[Paul72]

Hi everyone, I am working on a integrationhub ETL integration with BigFix to import software records into cmdb_sam_sw_install table, one requirement is that customer wants those obsolete software install records to be deleted automatically, I first thought to have a scheduled job to delete records whose last_discovered is older than 7 days, but it turns out the last_discovered field is not in cmdb_sam_sw_install table, which means while integrationHub ETL use IRE to process the CIs, it will not populate that field in cmdb_sam_sw_install... 

Any thoughts on this? if I have to add a custom u_last_discovered field to the table, I will also have to make some changes somewhere in IRE to populate this field, which doesn't sound feasible right now..

[#2]

Paul,

I would suggest you download the Service Graph Connector for Microsoft SCCM to view how it handles deleted software.  There is a specific data source for software removal.  It will query to get all currently installed software on a device from SCCM, then query that device in the CMDB to see what software is currently in the CMDB for it, find the difference using sys_object_source, and remove any differences.

This is done via a transform map and not through the IH-ETL as the IH-ETL goes through IRE which doesn't handle deletes.

[Paul72]

Thank you for the info! but at this time IH-ETL is a must, cant get rid of that unfortunately...

[senon]

I have the same requirement.
Have you made any progress on this issue?
If so, could you let me know?