Hi, RRR|LoginConv works on all fields, not only 2 and 4.
Any exact match will be converted. It will also convert Status-History and Diary-fields as well as any exact occurrence enclosed in single or double quotes. If you must convert a lot of user names, RRR|LoginConv will do this in one pass based on a configuration file. Best Regards - Misi, RRR AB, http://rrr.se > I use a stored procedure in the DB that looks in arschema for forms of > type > 'regular'....and loop through those forms doing update statements where c2 > or c4 = smith, set appropriately to SMITH > > _____ > > From: Action Request System discussion list(ARSList) > [mailto:arsl...@arslist.org] On Behalf Of copits.rich...@bwc.state.oh.us > Sent: Wednesday, August 26, 2009 12:29 PM > To: arslist@ARSLIST.ORG > Subject: Login id change.... > > > ** > > We have a user who had a login ID in AD of (For example.) "Smith" . When > they logged into Remedy 7.5 > > and were validated by LDAP they would do various transactions/events using > the "Smith" username. Now > > the AD username has been changed to "SMITH" so they have to use this to > login to Remedy. Is there any way > > of renaming the "Smith" records in the database to the new username of > "SMITH"? Any guidance or suggestions > > are welcome and appreciated. > > > Portions of this message may be confidential under an exemption to Ohio's > public records law or under a legal privilege. If you have received this > message in error or due to an unauthorized transmission or interception, > please delete all copies from your system without disclosing, copying, or > transmitting this message. _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" > > -- > This message was scanned by ESVA and is believed to be clean. > > _______________________________________________________________________________ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor:rmisoluti...@verizon.net ARSlist: "Where the Answers Are"