Need to bulk change Email Addresses

Question

Is there or what is the best way to bulk change Email Addresses from @prod.com to @test.com in a Identity Manager 6.1 UAT system?

Barry Jackson · Accepted Answer

Hi Blane, If the AD accounts are linked to Employee accounts and the template on ADSAccount.Mail gets it's value from Person.DefaultEmailAddress then you should be able to get away with just changing Person.DefaultEmailAddress. The easiest way to do this in bulk in V6 is to use vid_InsertForHandleObject_0. A single update would look like this: exec vid_InsertForHandleObject_0 'update','person','','DefaultEmailAddress','',@procid=12345 You could generate all the updates with a statement like this: select 'exec vid_InsertForHandleObject_0 ''update'',''person'',''uid_person='''''+p.uid_person+''''''',''defaultemailaddress'','''+REPLACE(p.defaultemailaddress,'prod.com','test.com')+''',@procid=12345' from Person p where isnull(p.defaultemailaddress,'')<>'' You can then copy/paste the statements into another query window and run them individually as a test or as a whole. HTH, Barry.