Finance | Project Operations, Human Resources, ...

Update User Info with new email and SID

(0) Share

Report

Posted on by brianmaric

Hi, I need to run an update on the UserInfo Table.

We are changing domain names. Consequently, I am changing the Network Alias and the new Corresponding SID number for dynamics users.

Everything else is staying the same.

I am getting the SID like this:

 Newsid              = manager.getUserSid(newEmail,networkDomain);

I am getting the domain name like this:

networkDomain = Microsoft.Dynamics.ApplicationPlatform.Environment.EnvironmentFactory::GetApplicationEnvironment().get_Provisioning().get_AdminIdentityProvider();

This seems to work, but I want a sanity check and I'm not sure exactly the nature of this reference.

Can someone explain it?

Will this function in the UAT and PROD the same as it does in Dev?

I have the same question (0)

All responses (7)

Answers (0)

Suggested answer

André Arnaud de Cal... 300,982 Super User 2025 Season 2 on at

Like (0)

Report

Hi Brianmaric,

Is your question related to Dynamics 365 or Dynamics AX 2012 (or earlier versions)? If it is Dynamics 365, then you have to test the coding carefully as there might be some differences. For Dynamics AX 2012 or before, the coding should work the same.

If you are running Dynamics 365, you can also use Power Automate to change the domain: How to setup demo users in Microsoft Dynamics 365 for Finance and Operations - Dynamicspedia

Was this reply helpful? Yes No
Suggested answer

Mohamed Amine Mahmoudi 26,390 Super User 2025 Season 2 on at

Like (0)

Report

Hi brianmaric

in AX 2012 you can use this method

whoami /user

update userinfo set

Name = 'Mohamed Amine Mahmoudi',

NETWORKDOMAIN = 'YOURDOMAIN.local',

NETWORKALIAS = 'Username',

SID = 'S-1-5-21-1694458270-169399854-1149528589-12722'

where RECID = 5637144000

Was this reply helpful? Yes No
brianmaric on at

Like (0)

Report

I suppose that my question is:

Does this value change: https://sts.windows.net/

....when the tenet stays the same and the user email (Network Alias) changes from @abc.com to @cde.com

Was this reply helpful? Yes No
Suggested answer

André Arnaud de Cal... 300,982 Super User 2025 Season 2 on at

Like (0)

Report

Hi Brianmaric,

If the tenant remains at @abc.com and the users are on @cde.com, then you have to change the value in the Provider field.

You can then use e.g. sts.windows.net/cde.com

Was this reply helpful? Yes No
brianmaric on at

Like (0)

Report
networkDomain = Microsoft.Dynamics.ApplicationPlatform.Environment.EnvironmentFactory::GetApplicationEnvironment().get_Provisioning().get_AdminIdentityProvider();

but then this code should grab the new value...

Is that right?

Was this reply helpful? Yes No
brianmaric on at

Like (0)

Report

But if the tenant stays the same and the domain changes to @cde.com then the Provider field stays the same, right?

Was this reply helpful? Yes No
André Arnaud de Cal... 300,982 Super User 2025 Season 2 on at

Like (0)

Report

Hi Brianmaric,

I have no idea about the outcome of this code in your scenario as I don't know if the admin account is configured for abc.com or cde.com.

Was this reply helpful? Yes No