I agree with those telling you to use SQL, and if you want to perform an update via Remedy, create a view of that SQL and put a View Form on top and use an Escalation to perform the updates. However, you are getting into some tricky areas though. If they are truly duplicates, you should at some point delete one and make sure that you leave the "correct" one, e.g. the one that has things related to it. Also, can't the import process be set to update matching requests instead of blindly creating new ones? I populate my people data via an integration I built with Active Directory so I haven't tried doing what you are. ________________________________ From: Action Request System discussion list(ARSList) [[email protected]] On Behalf Of John Quinn [[email protected]] Sent: Monday, April 27, 2009 6:21 PM To: [email protected] Subject: Searching for Duplicate Values
** 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.<http://windowslive.com/online/skydrive?ocid=TXT_TAGLM_WL_skydrive_042009> _Platinum Sponsor: [email protected] ARSlist: "Where the Answers Are"_ Private and confidential as detailed here: http://www.sug.com/disclaimers/default.htm#Mail . If you cannot access the link, please e-mail sender. _______________________________________________________________________________ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor:[email protected] ARSlist: "Where the Answers Are"
