Brent, There is the Reconciliation Engine, which might be an option, though that only cleans the data you have. If your feeds are the problem, RE might not be able to fix that completely. It will also take some time to configure properly to do what you want, too, if it's even possible. I would estimate that you would need a minimum of a week, and probably more, to clean the data this way.
One quicker, though more drastic, option you might consider would be to correct the feed duplication issues, then have them feed into a new dataset that would be kept as clean. Then remove the other datasets and point everything to the new one. I haven't tried that, and I'm leaving out a lot of details, but it seems as though it would work. You might lose the Asset history that way, unless you account for that somehow. Rick On Fri, Jun 27, 2008 at 11:56 AM, Remedy <[EMAIL PROTECTED]> wrote: > I have just started a new contract with a client that is running > ARSystem/AIE 7.1.00 Patch 002 and CMDB 2.0.1 patch 004. > > They are receiving discovery data from a number of sources (including > Marimba) which are being brought into the system via EIE/AIE and then > Reconciled into the CMDB. > > The short version of the story is that the AIE mappings and the CMDB > Reconciliation jobs were configured incorrectly and the system is full > of duplication (anywhere from 2 to 600 copies each). This is for CI's > and dependencies/relationships. One of the identity rules used look > like this: ( 'Name' = $Name' AND 'InstanceId' = $InstanceId$ ). > Discovered and undiscovered CI's will have different reconciliation > Identity numbers. > > We are trying to figure out how to remove all the duplication in the > production system. We were thinking of using AIE to pull the data from > our Production system, into our QA environment and then reconcile this > data against an empty bmc.asset. In theory this sounds like it word > work, however, will the reconciliation look at and identify the > duplicates within the same dataset before merging it into asset? > > Another avenue that is being discussed is uring SQL on the backside to > remove duplication. Not the avenue I would take due to corrupting the > system. > > I talked with someone who use to work for BMC for a number of years > and they had mentioned that there was a tool out there that could help > remove duplication, but it was not the easiest tool to work with. Does > anyone know of, or heard of this tool? > > I am looking for any suggestions on how we could go about removing the > current duplication. We have gone back and reworked the AIE Mappings > and corrected most of the Reconciliation job rules to stop any further > problems from showing up. > > Thanks in advance, > > Brent... > > > _______________________________________________________________________________ > UNSUBSCRIBE or access ARSlist Archives at www.arslist.org > Platinum Sponsor: www.rmsportal.com ARSlist: "Where the Answers Are" > _______________________________________________________________________________ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor: www.rmsportal.com ARSlist: "Where the Answers Are"
