Re: Hude Login ID Conversion
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 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 > > 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" > > > > > _
Re: Hude Login ID Conversion
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 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 > > 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"
Re: Hude Login ID Conversion
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 > 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"
Re: Hude Login ID Conversion
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 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 > 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"
Re: Hude Login ID Conversion
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 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"
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 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"
Hude Login ID Conversion
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"