Items can only be matched between datasets where the item in the master dataset already has a reconciliation ID. So, if the ID is zero in both datasets, the items will never match. The usual process is that you will auto-identify the records (or some portion of them based on criteria that you set in a qualification group) in the master dataset, and then you will run an identification activity with the other dataset to see which items in the second dataset match the items that you have already identified in the first dataset.
If neither of the datasets that you are talking about is the gold dataset (BMC.ASSET), it would be good to first run an identification activity between gold and one or both of the secondary datasets. That way, you match up any discovery items that already match gold. Then you can auto-identify items in one of the secondary datasets to identify new items that will eventually get merged into gold. Then, lastly, you can run an identification activity between the two secondary datasets to find all items that match between them, and merge the final results into gold if you want. Does that make sense? Lyle -----Original Message----- From: Action Request System discussion list(ARSList) [mailto:[email protected]] On Behalf Of Frank Caruso Sent: Tuesday, August 11, 2009 3:35 AM To: [email protected] Subject: Reconciliation - Identification Stage ARS 7.1p5 SQL Server 2005 CMDB 2.1 p4 Have two datasets that were created from two different discovery sources. Each has several BMC Computer records. The reconciliation ID in both is set to 0 as neither has never been reconciled with another source. I created an identification activity to compare the two datasets matching on the Name. I set one of the datasets as the master in the activity. When I run the activity the second data set (non master) records gets assigned reconciliation IDs but the master dataset records do not. It is my understanding that the identification activity would match records in the two datasets and give them the same reconciliation id. If I then take the identification job and reverse the roles of each dataset and rerun the job the records on both sides will get reconciliation ids that match. So it looks like you can do this sort of comparison but only when one dataset already has been reconciled? Does this make sense or am I missing something. TIA Frank _______________________________________________________________________________ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor:[email protected] ARSlist: "Where the Answers Are" NOTICE: This email message is for the sole use of the intended recipient(s) and may contain confidential and privileged information. Any unauthorized review, use, disclosure or distribution is prohibited. If you are not the intended recipient, please contact the sender by reply email and destroy all copies of the original message. _______________________________________________________________________________ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor:[email protected] ARSlist: "Where the Answers Are"
