Home > Forum > General > Changings UPN in AD

Changings UPN in AD
0

23.02.2022
21:15
Bo Jamison

We were recently purchased by another company and our AD structure will be changing to some degree. We had to add a new UPN in AD as we are going to synch up with their Azure AD and move into their 0365.

So the old UPN "accountname@oldupn.us" will be "accountname@newupn.us".

The issue is, ALL open webcon tasks are tied to the previous UPN and those do not carry over to the new UPN. So all task assignments, record creators, etc... are lost. Is there a way to correct this?

Hope that made sense!

Reply  
23.02.2022
21:49
MVP
Daniel Krüger (Cosmo Consult)

Hi Bo,

I used the stored procedure dbo.ReplaceLogins in the past for this kind of task. Or at least a similar one.
For an unknown reason to me the last name is quite often part of the account name. If someone changes his last name, for example due to a marriage, it causes a whole lot of trouble. :)

You can take a look at stored procedure how many table need to be updated.

I'm not sure whether there's a better alternative, but this worked fine.

Best regards,
Daniel

Reply  
Solution (1) Helpful (1) Wrong answer (0)
Menu
Czerwone Maki 87
30-392 Krakow, Poland
office@webcon.com
+48 12 443 13 90