11 Replies Latest reply on Sep 15, 2020 4:34 AM by Tej D

    Need suggestions regarding Purge of Asset dataset Relations!

    Tej D
      Share This:

      Dear Team,

       

      We have several relationships that were created by ADDM earlier and reconciled to Asset dataset (around 20k records). We do not see ADDM dataset relations anymore but, they still exist in Asset dataset. Please let me know on the below as to how to handle them:

       

      1.Asset dataset relationships exists without MAD being set and their ADDM relations are already deleted. We need to purge them.

      2.Asset dataset relationships exists with MAD being set and their ADDM relations are already deleted. We need to purge them too. I already have a Recon job with purge activity that has a qualification rule for BaseElement and BaseRelationship to delete all the CIs where the MAD is set and Deleted Date is older than a week . But, this is not actually purging the relations.

       

      Kindly let me know what is the best possible way to clean this up in CMDB Asset dataset.

       

      AR Server: 9.1.03

      OS: Red Hat Linux

      Oracle Database (11g)

       

      Regards,

      Tej D