Hi,

As part of data cleanup and consistency, we need to write an enrichment rule to ensure two CIs have only 1 single relationship between them and the existing old relationship should be deleted.

As of now, some Node CIs have more than one relationship with the Asset CI type via the 'Connection' relationship

ie.. Asset   <cardinality 2 - * >  to  ->  Node     returning result.

Though it is easy to write query to identify such CIs but struggling to write an enrichment rule where it can delete all but 1 relationship based on the 'create time'

So, if there are more than 2 relationship between Asset and Node, the oldest relationships should be deleted.

Please could someone assist a way of achieving the intended outcome.

Thanks

Shishir.