Hi,
The rrrLoginConv tool performs the change on everything in the system,
including:
- Exact Matches on any char-fields smaller than 255 chars (size configurable)
- Quoted user names in fields such as the 60xxx fields for dynamic
permissions (can be skipped)
- Status-History entries (can be skipped)
- Diary-Entries (can be skipped)
It takes a list of any number of user names to convert.
You can perform a dry-run first to see in which fields it finds matches to
convert.
It does NOT change Modify Date or Modified By.
Best Regards - Misi, RRR AB, http://www.rrr.se
Products from RRR Scandinavia (Best R.O.I. Award at WWRUG10):
* 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.
> Yes, Data Wizard considers existing tickets, and field id 2 and 4.
> However,
> it does not recognize any custom fields. It runs perfect on 1:1 basis.
>
>
>
> http://www.remedycloud.com
>
>
>
> From: Joe Martin D'Souza [mailto:[email protected]]
> Sent: Tuesday, June 14, 2011 4:04 PM
> Subject: Re: Bulk Change of login ID
>
>
>
> **
>
>
>
> Does the Data wizard consider existing tickets and the values of field 2,
> 4,
> and other login name type fields even if they are custom?
>
>
>
> If not you may have to write a DB script to get this done.. I had done it
> using a DB script to mass change login names in a system a few years ago
> long before the dawn of these nifty utilities that are now being bundled
> over the past couple of years or so...
>
>
>
> Joe
>
>
>
> From: Boyd, Rebecca <mailto:[email protected]>
>
> Sent: Tuesday, June 14, 2011 8:23 AM
>
> Newsgroups: public.remedy.arsystem.general
>
> To: [email protected]
>
> Subject: Re: Bulk Change of login ID
>
>
>
> ** I've used the DLD:SYS:DataWizAction form to bulk update login names.
> Open
> it up & look at it. If you've 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.
>
> 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.
>
> HTH,
>
> Rebecca
>
>
>
>
>
>
>
>
> On Tue, Jun 14, 2011 at 7:09 AM, Michael Burton
> <[email protected]> wrote:
>
> **
>
> Morning,
>
> Just wondering if anyone has experience of a bulk update of people's login
> ID's. Basically we configured our system to use people's email addresses
> as
> their User Name. The obvious advantage of this is that your are guaranteed
> a
> unique entry for each employee. Authentication takes place against our AD
> servers.
>
> So we are now in the position that due to a company purchase, we are going
> to have to change everybody's email address, and as such, regardless of
> short term work arounds we might be able to put in place, each users login
> ID will need to change too.
>
> I've had a dig on support.bmc.com and found questions about using DMT, but
> it's not designed to do it.
>
> It would seem that the best option is to use the Data Wizard Console, but
> that only works on a 1:1 basis, but it does do the job and updates
> everything rather than just the CTM:People form and/or the User form. Is
> it
> just a case of bite the bullet and crack on with it via the DWC?
>
> Cheers
> -
> Mike
>
>
>
> _attend WWRUG11 www.wwrug.com ARSlist: "Where the Answers Are"_
>
>
>
>
> --
> Rebecca Boyd
> Application Administrator
> Wake Forest University
>
> _attend WWRUG11 www.wwrug.com ARSlist: "Where the Answers Are"_
>
> _attend WWRUG11 www.wwrug.com ARSlist: "Where the Answers Are"_
>
>
> _______________________________________________________________________________
> UNSUBSCRIBE or access ARSlist Archives at www.arslist.org
> attend wwrug11 www.wwrug.com ARSList: "Where the Answers Are"
>
_______________________________________________________________________________
UNSUBSCRIBE or access ARSlist Archives at www.arslist.org
attend wwrug11 www.wwrug.com ARSList: "Where the Answers Are"
