I have published a free utility written that has similar capabilities to Misi's RRR|LoginConv using the Java API and posted the write-up and download here:
http://soleauthority.net/login-converter-utility-for-mass-updating-login-ids/ It hasn't gone through exhaustive testing as of yet but I would welcome anybody testing it and providing feedback for further improvements. Here is a quick list of capabilities it provides: - High performance updates from an old LoginID to a new LoginID utilizing merge action that bypasses workflow - Single update or define multiple Login ID updates for a single pass - Updates all Character Fields (regardless of size) - Match exact - (optional) Match surrounded by single/double quotes - (optional) Match surrounded by separators such as white-space, comma, period, pipe, semi-colon or colon - (optional) Updates all Status History entries - (optional) Updates all Diary Field entries And here is a list of nice features above and beyond the core capability: - Two progress bars show displaying progress by the currently processing form and the overall end to end process. - Ability to control the speed by way of a delay slider that will slow down or speed up the processing dynamically - Ability to pause / resume the processing - Ability to cancel in-flight updates (doesn’t not roll back, just stops wherever it happens to be) - Ability to toggle on/off the scope/matching capabilities - Ability to specify all forms to be checked or a specific form only - Ability to ‘simulate’ the run without actually make any changes - Detailed output provided on forms processed and matches found 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"
