I've used the DLD:SYS:DataWizAction form to bulk update login names. Open it up & look at it. If you've already used the Data Wizard Console to make any changes, you can search & see the records.
Here is what I did: Exported the users that needed changing from CTM:People. Created a csv file. Imported the csv file into DLD:SYS:DataWizAction. Then - & this is where it gets funky - I used a program called AutoHotKey to run through the everything I'd imported into DLD:SYS:DataWizAction & update the records. The reason I used AutoHotKey is because I could make it wait for the update action to complete before moving on to the next record. A colleague recommended this & help me set it up. You may be able to do the same thing with an escalation if you can make it update only one record at a time. Even if you don't use AutoHotKey it will be much faster if you import all of the records into DLD:SYS:DataWizAction. Also, BMC recommends escalations be disabled before updating login IDs but I don't always do this if the ID is pretty new & doesn't have many or any records associated with it. HTH, Rebecca On Mon, Jan 16, 2012 at 12:53 PM, Sanford, Claire < claire.sanf...@memorialhermann.org> wrote: > I'm going to piggy back on this one.... > > Out of 600 support people I need to modify 176 of their Login IDs. Using > the Data Wizard is tedious and very time consuming. Any ideas on a quick, > complete and easy way to modify the Login Ids of these people. > > There are no tickets to be updated, just Assignment, User, Group, People > etc. forms and such > > > -----Original Message----- > From: Action Request System discussion list(ARSList) [mailto: > arslist@ARSLIST.ORG] On Behalf Of Shellman, David > Sent: Thursday, November 11, 2010 10:20 AM > To: arslist@ARSLIST.ORG > Subject: Re: Modify login id > > Actually it was intended to be a question. Noticed I used a period > instead of a question mark as it was being sent. > > Thanks for the answer. > > Dave > > -----Original Message----- > From: Action Request System discussion list(ARSList) [mailto: > arslist@ARSLIST.ORG] On Behalf Of Misi Mladoniczky > Sent: Thursday, November 11, 2010 10:14 AM > To: arslist@ARSLIST.ORG > Subject: Re: Modify login id > > Hi, > > I guess this was not really a question, but yes, absolutely! > > Best Regards - Misi, RRR AB, http://www.rrr.se > > > Misi, > > > > Since this uses ARMergeEntry this would also work with the server set > with > > Submitter Mode locked. > > > > Dave > > > > -----Original Message----- > > From: Action Request System discussion list(ARSList) > > [mailto:arslist@ARSLIST.ORG] On Behalf Of Misi Mladoniczky > > Sent: Thursday, November 11, 2010 3:14 AM > > To: arslist@ARSLIST.ORG > > Subject: Re: Modify login id > > > > Hi, > > > > It is in the RRR|Commands section and is called RRR|LoginConv: > > https://www.rrr.se/cgi/tools/main#rrrLoginConv > > > > It basically go through all regular forms and update those records that > > needs to be changed. > > > > It does not care which application or version is used, as it performs an > > exact match in all your fields, including diary-fields and > status-history. > > > > It does not change Modify-Date or Modify-By, as the API-call ARMergeEntry > > is used (same as Import Tool). > > > > Best Regards - Misi, RRR AB, http://www.rrr.se > > > > Products from RRR Scandinavia (Best R.O.I. Award at WWRUG10): > > > >> Didn't Misi have a login converter tool to do this? http://www.rrr.se > >> (although I'm not seeing it in the list of product right now.) > >> > >> Thad > >> > >> On Wed, Nov 10, 2010 at 12:17 PM, Larry Barnes > >> <larry.bar...@thecreek.com>wrote: > >> > >>> ** > >>> I'm wondering if anyone out there has a simple way of modifying a login > >>> id for a user and any of their tickets they have created, or been > assigned. > >>> > >>> We have users that are given a login id one way if they are a > contractor > >>> and a different way if they are an employee. The problem is some > contractors > >>> eventually become employees. We want to be able to modify the > employee's current People, > >>> User form records and at the same time modify any tickets associated > with their > >>> old login id and link them with their new login id. > >>> > >>> I was thinking of creating workflow and a form, for input, but this may > >>> need to be a SQL script. I'm just curious if anyone else has done this > >>> and is willing to share. > >>> > >>> We are running on a windows server with ARS 7.5.00 patch 002 with ITSM > >>> 7.0.03 patch 009 > >>> > >>> Thanks, > >>> > >>> Larry B. > > > _______________________________________________________________________________ > UNSUBSCRIBE or access ARSlist Archives at www.arslist.org > attend wwrug12 www.wwrug12.com ARSList: "Where the Answers Are" > -- Rebecca Boyd Application Administrator Wake Forest University _______________________________________________________________________________ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org attend wwrug12 www.wwrug12.com ARSList: "Where the Answers Are"
