Re: Reconciliation - Identification Stage
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:arsl...@arslist.org] On Behalf Of Frank Caruso Sent: Tuesday, August 11, 2009 3:35 AM To: arslist@ARSLIST.ORG 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:rmisoluti...@verizon.net 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:rmisoluti...@verizon.net ARSlist: "Where the Answers Are"
Re: Reconciliation - Identification Stage
I guess my issue is that I do not have a GOLD set yet. I have many different sources for data that will become the GOLD set but need to first identify and then merge them. On Tue, Aug 11, 2009 at 8:02 PM, Lyle Taylor wrote: > 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:arsl...@arslist.org] On Behalf Of Frank Caruso > Sent: Tuesday, August 11, 2009 3:35 AM > To: arslist@ARSLIST.ORG > 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:rmisoluti...@verizon.net 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:rmisoluti...@verizon.net ARSlist: "Where the Answers Are" > ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor:rmisoluti...@verizon.net ARSlist: "Where the Answers Are"
Re: Reconciliation - Identification Stage
I see. In that case, you'll need to pick one dataset that you will auto-identify instances in. You don't have to auto-identify all of them, if you don't want to, but then you will need to find a way to filter the ones you do want to identify that doesn't depend on the contents of another dataset, or simply auto-identify them all, if you think they all will eventually go into Gold. Once you have auto-identified items in that dataset (which will give them a recon ID other than zero), you can then identify the items in that dataset with other datasets, applying that same recon ID to the instances in the other datasets. Then you can merge them all into Gold. Lyle -Original Message- From: Action Request System discussion list(ARSList) [mailto:arsl...@arslist.org] On Behalf Of Frank Caruso Sent: Wednesday, August 12, 2009 12:52 AM To: arslist@ARSLIST.ORG Subject: Re: Reconciliation - Identification Stage I guess my issue is that I do not have a GOLD set yet. I have many different sources for data that will become the GOLD set but need to first identify and then merge them. On Tue, Aug 11, 2009 at 8:02 PM, Lyle Taylor wrote: > 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:arsl...@arslist.org] On Behalf Of Frank Caruso > Sent: Tuesday, August 11, 2009 3:35 AM > To: arslist@ARSLIST.ORG > 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:rmisoluti...@verizon.net 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:rmisoluti...@verizon.net ARSlist: "Where the Answers Are" > ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor:rmisoluti...@verizon.net ARSlist: "Where the Answers Are" ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor:rmisoluti...@verizon.net ARSlist: "Where the Answers Are"
SOLVED: Re: Reconciliation - Identification Stage
Everything is working fine now that I have auto identified the GOLD copy. Thank you for you help. On Wed, Aug 12, 2009 at 8:15 PM, Lyle Taylor wrote: > I see. In that case, you'll need to pick one dataset that you will > auto-identify instances in. You don't have to auto-identify all of them, if > you don't want to, but then you will need to find a way to filter the ones > you do want to identify that doesn't depend on the contents of another > dataset, or simply auto-identify them all, if you think they all will > eventually go into Gold. Once you have auto-identified items in that dataset > (which will give them a recon ID other than zero), you can then identify the > items in that dataset with other datasets, applying that same recon ID to the > instances in the other datasets. Then you can merge them all into Gold. > > Lyle > > -Original Message- > From: Action Request System discussion list(ARSList) > [mailto:arsl...@arslist.org] On Behalf Of Frank Caruso > Sent: Wednesday, August 12, 2009 12:52 AM > To: arslist@ARSLIST.ORG > Subject: Re: Reconciliation - Identification Stage > > I guess my issue is that I do not have a GOLD set yet. I have many > different sources for data that will become the GOLD set but need to > first identify and then merge them. > > On Tue, Aug 11, 2009 at 8:02 PM, Lyle Taylor wrote: >> 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:arsl...@arslist.org] On Behalf Of Frank Caruso >> Sent: Tuesday, August 11, 2009 3:35 AM >> To: arslist@ARSLIST.ORG >> 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:rmisoluti...@verizon.net 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 des