I belive it is cmdbdiag utility coming from cmdb 2.0.1 patch 004.. But still not pretty sure whether it will fix your duplication. Duplicate data needs to clean-up and thats the only option.
Yours Truly On 6/28/08, 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"
