Not using the remedy user tool advanced search. Two options I see: - Create a remedy report and use the group by and count function - Run a sql statement: select login_name, count(entryid) from people_form group by login_name having count(entryid) > 1
Axton Grams On Mon, Apr 27, 2009 at 6:21 PM, John Quinn <[email protected]> wrote: > ** 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"_ _______________________________________________________________________________ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor:[email protected] ARSlist: "Where the Answers Are"
