All those responding are correct, use existing AR and CMDB functions when they are available and adequate.
But for analytical purposes some sql is helpful. Below is an sql query that compares the 'Name' value for all records that have a reconciled record in each data set. The query can be enhanced to include a larger subset of output fields. It could also incorporate outer joins to show records that do not have a corresponding reconciled partner. select a.name, t.name from BMC_CORE_BMC_BaseElement a join BMC_CORE_BMC_BaseElement t on a.ReconciliationIdentity = t.ReconciliationIdentity and a.datasetid = 'BMC.ASSET' and t.datasetid = 'BMC.IMPORT.TOPO' Hope this helps. -----Original Message----- From: Action Request System discussion list(ARSList) [mailto:arsl...@arslist.org] On Behalf Of Pat Zandi Sent: Friday, January 15, 2010 6:52 AM To: arslist@ARSLIST.ORG Subject: Re: Table for BMC.IMPORT.TOPO No Sent from my iPhone On Jan 15, 2010, at 3:48 AM, Peter Romain <p.romain.arsl...@parsolutions.co.uk > wrote: > Have you looked into using the BMC Drift Management Tool? > > > >> Yes, I believe that is what I was thinking about. I haven't used it >> myself, but wanted to point out that there is comparison >> functionality >> built into the CMDB that you may want to look into if you weren't >> aware >> that it was there. >> >> Lyle >> >> From: Action Request System discussion list(ARSList) >> [mailto:arsl...@arslist.org] On Behalf Of Kathy Morris >> Sent: Thursday, January 14, 2010 4:36 PM >> To: arslist@ARSLIST.ORG >> Subject: Re: Table for BMC.IMPORT.TOPO >> >> ** >> Are you referring to running a job that does a comparison? >> >> In a message dated 1/14/2010 4:29:59 P.M. Eastern Standard Time, >> tayl...@ldschurch.org writes: >> ** >> There are not separate tables for each of the database - all >> datasets are >> stored in the same table in the database. The only thing that >> distinguishes the data in one dataset and another is a field that >> indicates which dataset a given record belongs to. >> >> The CMDB already contains the ability to run a comparison between >> datasets >> off the CMDB Console. Does that functionality not give you what >> you are >> looking for? >> >> Lyle >> >> From: Action Request System discussion list(ARSList) >> [mailto:arsl...@arslist.org] On Behalf Of Kathy Morris >> Sent: Thursday, January 14, 2010 2:25 PM >> To: arslist@ARSLIST.ORG >> Subject: Table for BMC.IMPORT.TOPO >> >> ** >> Hi All, >> >> I am trying to compare the data between BMC.IMPORT.TOPO and >> BMC.ASSET. >> I was going to try a comparison using Business Objects reports. >> How would you compare the results between these two datasets since >> are the >> same table BMC.ASSET. >> Does anyone know the name of the table that stores the data in the >> Discovery datastore? >> >> >> >> _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. >> >> _Platinum Sponsor: rmisoluti...@verizon.net ARSlist: "Where the >> Answers >> Are"_ >> _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" ________________________________________________________________________ _______ 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"
