I might suggest reading in the documentation about the Authentication Alias, if you haven't already. Using that might be an alternative to changing out all of the values.
Don't forget you also have Login ID in pending Change approvals and such. Those records can be tricky to transition. Rick Cook On Mon, Sep 29, 2014 at 10:55 AM, Rick Westbrock <rwestbr...@24hourfit.com> wrote: > ** > > This utility for finding strings anywhere in the database might help you > show how difficult that task would be: > > *Simple Utility for finding strings in database:* > https://communities.bmc.com/docs/DOC-33105 > > > > It won’t change the data for you but if you enter run it twice (once for a > login ID and once for a corporate ID) you may be surprised at how many > places such data might be squirreled away. I would run it against a > non-production server if at all possible though since I don’t know what > kind of performance hit it might cause. > > > > -Rick > > > > > > *From:* Action Request System discussion list(ARSList) [mailto: > arslist@ARSLIST.ORG] *On Behalf Of *LJ LongWing > *Sent:* Monday, September 29, 2014 10:11 AM > *To:* arslist@ARSLIST.ORG > *Subject:* Re: Hude Login ID Conversion > > > > ** > > I would recommend > > > > https://rrr.se/cgi/tools/main?tool=rrrLoginConv > > > > On Mon, Sep 29, 2014 at 11:02 AM, Frank Caruso <caruso.fr...@gmail.com> > wrote: > > ITSM 764 sp2, Oracle, Weblogic > > We have been asked to determine the difficulty/feasibility in converting > all Login IDs and Corporate IDs to new values. The unique values currently > used must be eliminated from "every" field in the application: Submitter, > Last Modified By, contained within a notes/description field and all custom > forms. We have over 1 million HPD records and millions of other ancillary > tables; audit, work log, assignments, searches, etc. I looked at the Data > Wizard Console (DWC) and it does allow Login IDs to be changed; it appears > to search across 408 tables in ITSM. But it does not handle corporate id, > can only be run for a single ID, does not search inside text fields and > does not handle custom forms. It also looks like a process that will take a > very long time to run. > > Looking for any thoughts on performing such a task; maybe some tricks > other have come up? > > Thank you. > > Frank Caruso > > > _______________________________________________________________________________ > UNSUBSCRIBE or access ARSlist Archives at www.arslist.org > "Where the Answers Are, and have been for 20 years" > > > > _ARSlist: "Where the Answers Are" and have been for 20 years_ > _ARSlist: "Where the Answers Are" and have been for 20 years_ _______________________________________________________________________________ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org "Where the Answers Are, and have been for 20 years"
