Hi, I want to make sure I'm understanding you correctly. Does your tool look for all character fields (or fields that can contain text) and search for the old login name and replace it with the new login name within the entire text?
If that's the case, that sounds quite scary to me. I can image that it would be relatively easy to replace text unintentionally because someone's username happens to match something else. For example, if someone change their login from Smith to Jones (perhaps they got married), that would mean that all references to Smith in, say, Incident descriptions, summaries, etc., would need to be changed. In fact, it could be quite incorrect to change them. You would end up changing things like "Mary Smith called to report..." to "Mary Jones called to report...". Am I getting that right? Lyle -----Original Message----- From: Action Request System discussion list(ARSList) [mailto:arsl...@arslist.org] On Behalf Of Misi Mladoniczky Sent: Thursday, August 27, 2009 2:11 AM To: arslist@ARSLIST.ORG Subject: Re: Login id change.... 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" 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. _______________________________________________________________________________ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor:rmisoluti...@verizon.net ARSlist: "Where the Answers Are"
