2 Replies Latest reply on Feb 5, 2020 12:12 PM by Vikas Mishra

    Can we relate Existing IPEndpoint Record having relationship with Computer System Record with New Computer System Records in CMDB Asset Management?

    Vikas Mishra
      Share This:

      We have a Staging Form where we have 4 fields of IP Address separately.

       

      In Pentaho Spoon

      We are able to create Computer System and 4 IPEndpoint(PV4,SV4,PV6,SV6) Records for the same.

      We also created Relationships for 4 IPEndpoint Records in BMC.CORE:BMC_HostedAccessPoint(IP Relationships)

      And after that we have unrelated (Mark as Deleted =Yes) those records from BMC.CORE:BMC_HostedAccessPoint when Status = Disposed.

       

      And when we update one of the IP Address field in Staging Form ,New Record of IP gets created in BMC.CORE:BMC_IPEndpoint Form and New Relationship is  formed with BMC.CORE:BMC_HostedAccessPoint. And Old Relationships for IP Address is  deleted with OLD IP Status as Delete Status(with the help of MAD(Mark as Deleted)).

       

      In Spoon Can we relate Existing IPEndpoint Record having relationship with Computer System Record with New Computer System Records by deleting Old Computer System Record  as we have done for IP?

        • 1. Re: Can we relate Existing IPEndpoint Record having relationship with Computer System Record with New Computer System Records in CMDB Asset Management?
          Vikas Mishra

          In Pentaho Spoon

          We are able to create Computer System and 4 IPEndpoint(PV4,SV4,PV6,SV6) Records for the same.

          We also created Relationships for 4 IPEndpoint Records in BMC.CORE:BMC_HostedAccessPoint(IP Relationships)

          And after that we have unrelated (Mark as Deleted =Yes) those records from BMC.CORE:BMC_HostedAccessPoint when Status = Disposed.

           

          And when we update one of the IP Address field in Staging Form ,New Record of IP gets created in BMC.CORE:BMC_IPEndpoint Form and New Relationship is  formed with BMC.CORE:BMC_HostedAccessPoint. And Old Relationships for IP Address is  deleted with OLD IP Status as Delete Status(with the help of MAD(Mark as Deleted)).

           

          In Spoon Can we relate Existing IPEndpoint Record having relationship with Old Computer System Record with the New Computer System Records by deleting Old Computer System Record  as we have done for IP?

           

           

           

          When we are trying to delete the Old Relationships for Computer System Record,We are recieving below Error in Spoon . Please confirm the solution for the below Error:-

           

           

          Error:-Error(120039)The operation violates the cardinality constraint of the relationship.

          Appended: 1-Many cardinality will be violated. Cannot create relationship instance because right endpoint is already in another relationship. Relationship Instance Id: OI-

          • 2. Re: Can we relate Existing IPEndpoint Record having relationship with Computer System Record with New Computer System Records in CMDB Asset Management?
            Vikas Mishra

            In Pentaho Spoon

            We are able to create Computer System and 4 IPEndpoint(PV4,SV4,PV6,SV6) Records for the same.

            We also created Relationships for 4 IPEndpoint Records in BMC.CORE:BMC_HostedAccessPoint(IP Relationships)

            And after that we have unrelated (Mark as Deleted =Yes) those records from BMC.CORE:BMC_HostedAccessPoint when Status = Disposed.

             

            And when we update one of the IP Address field in Staging Form ,New Record of IP gets created in BMC.CORE:BMC_IPEndpoint Form and New Relationship is  formed with BMC.CORE:BMC_HostedAccessPoint. And Old Relationships for IP Address is  deleted with OLD IP Status as Delete Status(with the help of MAD(Mark as Deleted)).

             

            In Spoon Can we relate Existing IPEndpoint Record having relationship with Old Computer System Record with the New Computer System Records by deleting Old Computer System Record  as we have done for IP?