Referencing tables to remove records

Andrew_TND
Mega Sage
Mega Sage

Hello all, what's the best method to deal with this scenario.

I have an integration with Intune which imports the data into a staging table and a transformer which moves the data to the appropriate table.

My question is, for example if a piece of software in Intune has been removed and longer appears on the import how can I automate something which does a comparison between the cmdb_software_instance and the import set and removes the records no longer present?

0 REPLIES 0