We've updated the ServiceNow Community Code of Conduct, adding guidelines around AI usage, professionalism, and content violations. Read more

Referencing tables to remove records

Not applicable

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