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<mailto: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<http://www.arslist.org> "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"
