Need to bulk change Email Addresses

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','<whereclause>','DefaultEmailAddress','<new value>',@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.

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','<whereclause>','DefaultEmailAddress','<new value>',@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.