I've got the bulk of the framework already developed using the Java API for this that I would just need to finish. Right now it will update loginIDs based on exact match of any character field (regardless of size) but extending it out to do inline replace across fields where it 'contains' the loginID rather then being an exact match only isn't that much additional work (and also diaries & status-history). I'd also need to add a parser so that you can pass it in a list of login IDs to check/update similar to RRR|LoginConv. All the other stuff your tool does would be gravy but not critical to the core usecase and could be added over time.
I figure I'll have time to spend on it between now and BMC Engage so I'll hopefully have the utility posted on my site (http://www.soleauthority.net) before then. If anybody is interested in being a guinea pig and have a DEV system they don't mind backing up / restoring as needed that has a lot of actual data (e.g. year or more of buildup), you can contact me offlist. Cheers, On Mon, Sep 29, 2014 at 3:01 PM, Misi Mladoniczky <[email protected]> wrote: > Hi, > > The RRR|LoginConv worked just fine, but it is written in ARSperl which has > kind not been recently updated. So there is a problem when getting the > field > list from some forms in ITSM (not data, just info about the fields)... > > I am looking for a sponsor to be able to rewrite it in C or Java. Please > let > me know if that could be you. It is not a big program, and might take > around > 40 hours or so to re-write. > > Using the API, as RRR|LoginConv does, takes considerable time to complete. > But > by prioritizing the order in which forms and records are converted, you > should > be able to do the important stuff during a weekend. Then the tool can > munch on > to convert historical data in a more leisurely manner. > > RRR|LoginConv exchanges text fields up to 254 characters in length. It does > fix the lists in the 112 and 60xxx fields, as well as Status-History and > Diary-fields. If it finds a quoted match in a char-field, that will be > exchanged as well. > > It performs one read and one write per record, regardless of the number of > fields/logins that is converted on that record, and you should be able to > run > several in parallel to speed things up. > > Best Regards - Misi, RRR AB, http://www.rrr.se (ARSList MVP 2011) > > Ask the Remedy Licensing Experts (Best R.O.I. Award at WWRUG10/11/12/13): > * RRR|License - Not enough Remedy licenses? Save money by optimizing. > * RRR|Log - Performance issues or elusive bugs? Analyze your Remedy logs. > Find these products, and many free tools and utilities, at http://rrr.se. > > > I would recommend > > > > https://rrr.se/cgi/tools/main?tool=rrrLoginConv > > > > On Mon, Sep 29, 2014 at 11:02 AM, Frank Caruso <[email protected]> > > 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" > >> > > > > > _______________________________________________________________________________ > > UNSUBSCRIBE or access ARSlist Archives at www.arslist.org > > "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" > -- :wq cuga _______________________________________________________________________________ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org "Where the Answers Are, and have been for 20 years"
