1 2 Previous Next 24 Replies Latest reply on Oct 11, 2017 2:30 AM by Raj Hiremath Go to original post
      • 15. Re: Relationship Reconciliation ? (ID Rules)
        Raj Hiremath

        No issues Marek, we can work on this till we are very clear on we get the intended results.

         

        So, here, what you are saying is, apart from the relationships whose end points are in BMC.ASSET, there can be other CIs as well, which you don’t want to reconcile.

        Is this correct understanding?

        • 16. Re: Relationship Reconciliation ? (ID Rules)
          Marek Ceizel

          Hi Raj,

           

          Exactly. So I have in one Dataset:

          - New CI's (whichever Class) which I don't want to reconcile (at least not in my reconciliation run).

          - Dependency Relationships (where the InstanceID's used are from BMC Asset).

           

          Now I want to create reconciliation and reconcile ONLY the Dependency Relationships. So I don't want to reconcile any CI's from the Dataset, only the dependencies.

          If I would not be able to define ID Rule for Dependency and I don't want to reconcile any other CI's, then I cannot create Identification step as this cannot be empty.

           

           

          Thanks a lot

          regards

          Marek

          • 17. Re: Relationship Reconciliation ? (ID Rules)
            Mauro Ciuti

            Hi Marek,

             

            From what you say, your relationships are in some dataset you created but they're have the source and destination from the CIs in BMC.ASSET.

             

            If that's the case, you can do something like the following (VERY DANGEROUS, MAKE A BACKUP OF THE DATABASE):

             

            1) Query the BMC.CORE:BMC_Dependency form for 'DatasetId'=YOURDATASET.

            2) Change the datasetId to BMC.ASSET (try first with one record, if it works use "ModifyAll")

            3) Verify that the relationships are showing up correctly (Atrium Explorer or Asset Management)

            4) Verify that the ReconciliationIds and InstanceIds from the source and destination are correct. If the REID are incorrect you might need to set those relationships first to 0 on the source and destination before changing the dataset.

             

            Make sure you test carefully and have a backup because there are many scenarios were this procedure can go wrong

             

            Regards,

             

            Mauro

            1 of 1 people found this helpful
            • 18. Re: Relationship Reconciliation ? (ID Rules)
              Marek Ceizel

              Hi Mauro,

               

              This is quite interesting tip, however I would like to follow the proper procedure - so reconciliation. Need just to find out If we still need to have the possibility to define ID Rules for Relationships (as this was removed in SP4).

               

              thanks a lot

               

              best regards

              Marek

              • 19. Re: Relationship Reconciliation ? (ID Rules)
                Mauro Ciuti

                Hi Marek,

                 

                Unfortunately, the current state should never happen since you have relationships in one dataset relating CIs from another dataset.

                 

                Since your external system is creating the Relationships I can recommend the following:

                 

                1) Use a Copy Dataset activity to copy BMC.ASSET CIs to your import dataset using the filter BMC_BaseElement so that only CIs are copied.

                2) Change the WS of the external system to lookup the Source/DestinationId in BMC.ASSET, but get the ReconciliationIds of both and look them up in your dataset.

                3) Create the relationship in the import dataset (through the WS) but using the InstanceId of the source and destination on that same dataset.

                4) Create a REJOB which Identifies BMC_Dependency and merges only those.

                 

                The idea is to bring the CIs in the import dataset and have the WS create the proper relationship using the CIs in the same dataset.

                 

                Hope this helps and I didn't make things more complicated.

                 

                Regards,

                 

                Mauro

                1 of 1 people found this helpful
                • 20. Re: Relationship Reconciliation ? (ID Rules)
                  Marek Ceizel

                  Hi Mauro,

                   

                  Let's make it a little bit shorter.

                  Now you can define ID Rules for Relationships and I have no problem with my solution. In SP4 I cannot and I have problem.

                  Of course I thank you for all the tips. I will keep that in mind when I will make some future solutions. This one works pretty well now

                   

                  Raj Hiremath, can you please take a look on my last answer to you so we can close this discussion.

                   

                   

                   

                  best regards

                  Marek

                  • 21. Re: Relationship Reconciliation ? (ID Rules)
                    Mauro Ciuti

                    Hi Marek,

                     

                    I don't want to make this too long but:

                     

                    The Standard Identification Rules are used for defining how a CI is identified.

                    I think that the Qualification (both in Identification and Merge) is what you are really looking for...

                     

                    It allows you to "filter" the CIs/Relationships in the same way a Remedy form query works and only those results will be processed.

                    So creating a Qualification in RE on both activities for Class BMC_Dependency where 'Name' != $\NULL$

                    1 of 1 people found this helpful
                    • 22. Re: Relationship Reconciliation ? (ID Rules)
                      Raj Hiremath

                      I agree with Mauro, can you please try the job with this qualification?

                      • 23. Re: Relationship Reconciliation ? (ID Rules)
                        Marek Ceizel

                        Hi Mauro,

                         

                        Now you wrote the important thing

                        Actually the previous idea : (Copy Dataset activity to copy BMC.ASSET CIs to your import dataset) would not be acceptable as this will be really extensive job. I run the recon each 30 minutes and cannot imagine I have to run a copy job each time (our BMC Asset has hundreds thousands of entries).

                         

                        However the last explanation opened my eyes. Hey man it is there whole time! So I can use the Standard ID Rules and then in Qualification filter only my Relations.

                         

                        Thank you very much and sorry

                        Raj, thanks either! So it is enough to have the Relationships available only in Qualifications.

                         

                         

                        best regards

                        Marek

                        • 24. Re: Relationship Reconciliation ? (ID Rules)
                          Raj Hiremath

                          Thanks Marek, glad that we reached conclusion on this.

                           

                          I will ensure that we have relationships shown up in new CMDB UI for qualifications.

                           

                           

                          -Raj

                          1 of 1 people found this helpful
                          1 2 Previous Next