I'll recommend that use a SQL statement to find de duplicate data, also if you want to delete the duplicate records you can use a script on your database (with the risks of mannipuling data by SQL)
The query to find duplicate records is something like select <record data 1>, <record data 2> from <table with duplicates> t1 where ( select count(*) from <table with duplicates> t2 where t2.dest_id = t1.dest_id ) > 1 go Hugo Ruesga perotsystems® US 972.577.7000 MX +52 (33) 3332.3868 P Please consider the environment before printing this email The information contained in and transferred with this electronic message is intended only for the recipient(s) designated above, it is protected by law and it may contain information which is privileged and confidential. If you are not the intended recipient, please do not read, copy, or use it, and do not disclose it to others. Please notify the sender of the delivery error by replying to this message, and then delete it from your system. Thank you. Date: Mon, 27 Apr 2009 23:21:05 +0000 From: [email protected] Subject: Searching for Duplicate Values To: [email protected] ** Hi Listers! I have a need to find duplicate values on the People record (ITSM 7.0.1). In particular, I'm looking to find last names that are the same. We are uploading new records using the Data Management Tool and the new accounts will be used to replace the old. I can't delete the old records, so I plan to set the Profile Status of the old records to 'Offline'. Does anyone know of a search string that I can use in Advanced Search to locate those duplicate values? Thanks! John Quinn Pegasus Solutions ITSM Development Windows Live™ SkyDrive™: Get 25 GB of free online storage. Check it out. _Platinum Sponsor: [email protected] ARSlist: "Where the Answers Are"_ _________________________________________________________________ Por seguridad, no compartas tu contraseña con nadie www.windowslive-hotmail.com/protectyourself/es/default.htm _______________________________________________________________________________ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor:[email protected] ARSlist: "Where the Answers Are"
