Rick, Reconciliation IDs are the unique identifiers of a thing.
Within a single dataset, it is NOT PERMITTED to have duplicate reconciliation IDs (and if you had that, there was a version of the CMDB where the unique index to prevent that was not in place). You can have two items with the same reconciliation ID, but in different datasets. That means it is the same object, just in a discovery and a production dataset for example. So, if you had your items with the same reconciliation ID, we consider them the exact same object. As the foreign key is that reconciliation ID, that is why connecting to one connected to all and disconnecting from one disconnected from all. Glad you found the issue in your case, but remember that the reconciliation ID is that unique identity of each thing (instance ID, another guid on the record is the unique instance of the thing so two things that are really the same object in different datasets will have the same reconciliation ID but unique instance IDs). Doug From: Action Request System discussion list(ARSList) [mailto:arslist@ARSLIST.ORG] On Behalf Of Rick Cook Sent: Tuesday, July 30, 2013 1:45 PM To: arslist@ARSLIST.ORG Subject: Re: Used By Relationships updating multiple CIs at once - SOLVED ** The answer was to manually change the Reconciliation ID to make them unique. Then I was able to do what I needed. Thanks for pointing me in the right direction! Rick On Jul 30, 2013 8:54 AM, "Rick Cook" <remedyr...@gmail.com<mailto:remedyr...@gmail.com>> wrote: All records were created in, and still reside only in, the BMC.Asset Dataset. The Reconciliation ID is not NULL, but is actually the same (non-Null) value for all of the records in the AST:AssetJoinASTPeople form relating to each of the product/version combinations. How do I get different Reconciliation IDs for the records - are they like GUIDs, which regenerate automatically if removed? Rick On Tue, Jul 30, 2013 at 2:25 AM, Vyom Labs Support <itsm.supp...@vyomlabs.com<mailto:itsm.supp...@vyomlabs.com>> wrote: ** Hi Rick, For v7.6.04 SP1, When we create CI's from Asset console the reconciliation Id's gets generated for that CI. Which is different for all CI's created from AM console. But when we create CI from respective class(form) from user tool other than for BMC.ASSET dataset Reconciliation Id doesn't get generated for those CI's. The given issue is occurred due to same reconciliation Id for multiple CI from one class created for particular organization. >From above information I will suggest that if you want only one CI should >relate to People with 'used by' association create CI's directly into ASSET dataset. However providing different recon Id for each CI will resolve this issue, it will create same issue when perform reconciliation Identity job for CI's in different dataset. -- Regards, Nilesh Janjire Vyom Labs Pvt. Ltd. BSM Solutions & Services || ITIL Consulting & Training Web Site: www.vyomlabs.com<http://www.vyomlabs.com> Follow Vyom Labs http://twitter.com/#!/vyomlabs<http://twitter.com/#%21/vyomlabs> || http://www.linkedin.com/company/vyom-labs -----Original Message----- From: Action Request System discussion list(ARSList) [mailto:arslist@ARSLIST.ORG<mailto:arslist@ARSLIST.ORG>] On Behalf Of Rick Cook Sent: Friday, July 26, 2013 10:03 PM To: arslist@ARSLIST.ORG<mailto:arslist@ARSLIST.ORG> Subject: Used By Relationships updating multiple CIs at once I have about a dozen new CIs in the Hardware Package class (two HW packages, each with multiple versions), and I want to associate Companies to them as individual associations. The only real differences between the CIs are the Name, Model/Version, and Short Description. They have the same Product Categories. So I go to the People tab on the CI, answer the dialogs to associate the CI as a "Used By" by the Company/Organization, and it all works. Except that it also associates all of the other CIs in that class (and perhaps others, I haven't checked yet) with the same relationship to the same company. Deleting the relationship from one also deletes it from all of the records. What I want is to be able to relate these one at a time. I don't see a way to do that, though I thought that was the way it functioned. I did verify that the Filter in play is NOT doing a table walk, so it isn't related to that. The logs show the Filter is firing one time, updating one record. What am I doing that is causing what I'm seeing, and how can I make the relationship for only one record at a time? ARS/ITSM 7.6.04 SP1 Rick Cook _______________________________________________________________________________ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org<http://www.arslist.org> "Where the Answers Are, and have been for 20 years" _ARSlist: "Where the Answers Are" and have been for 20 years_ _ARSlist: "Where the Answers Are" and have been for 20 years_ _______________________________________________________________________________ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org "Where the Answers Are, and have been for 20 years"