Change login name

avatar

Hello.

Is there a way to change the login name of a existing user from sAMAccountName to UPN?

Thanks
Max

All Comments (15)

avatar

Hello,

What data source type are you using?

Best regards,

Érica Poirier

avatar

Hello Erica.

We use Devolutions Password Server with AD integration.
It would be great changing the login name of the existing users which were added via sAMAccountName.

Thanks
Max

avatar

Hello,

Thank you for the information.

It is somehow possible to modify the username directly in the database but the user will loose all his private vaults entries and user specific settings. The user needs to export this information and then import it back after renaming the account.

In fact, with a Devolutions Password Server data source, no matter how the account name is saved in the database, the user should be able to login using either the SAM Account, the NetBios or UPN username format.

Let me know if you still need to modify the username format and I will send you the procedure in a private message.


Best regards,

Érica Poirier

avatar

Hi,

can you please confirm this is still an issue.
When renaming the user in AD (changing samaccount and UPN), new user is createad in the database and there is no way to get that old user back (with private vault and settings)?

Best regards,
Rok

avatar

Hi Rok,

Could you please contact us at ticket@devolutions.net, there is probably something we can do to help you on that matter.

Best regards,

Érica Poirier

avatar

Hi Erica,

thank you for quick response, I fixed it with a little SQL hacks ;-)

Best regards,
Rok B

avatar

Hi Rok,

Glad you have found a method to update the user account. Would you send me in a private message the SQL statement you have used to be sure that nothing in missing in the user account?

Best regards,

Érica Poirier

avatar

Can the SQL query be shared?

Best regards,

Kaj Graficom

avatar

Hello Kaj,

What type of data source are you using? Can you also confirm you want to modify the format from domain\user to user@domain.xx?
We will send you the appropriate script after, but if you prefer, you can open a case with us by emailing service@devolutions.net

Best regards,

Richard Boisvert

avatar

Hi Richard,

I'm in the same predicament, i would like to cleanup our Users without having to delete them first.
We have currently a mix of sAMAccountName / userPrincipalName im Updating to a version where we can finally use Powershell to Script. But do you have an SQL Script that will not Purge all Private Vaults and Settings from the Users?

Datasource: DVLS Version 2020.3.22.0 / Database Version: 669

Best Regards
Damian

avatar

Hello Damian,

In the 2022.3 version of Devolutions Server, there is now a migration tool that allows you to migrate accounts, but it will most likely not help you with your scenario.

I will send you the SQL script via PM, please make sure to perform a backup of your database, just in case.

Best regards,

Richard Boisvert

avatar

Hi Richard,

Thank you for your Message, do you mean once we Updated to the newest Version we would be able to use the Migrate Accounts Tool for this Purpose ? Because we will Update next Tuesday to the new Version and if it would make more sense we could also just cleanup after the Upgrade and use this Path.

Best Regards
Damian

avatar

But not in SQL datasource?

Best regards,

Kaj Graficom

avatar
But not in SQL datasource?


We do have DVLS and MS SQL as Database Server.

But as we will Update coming week it might make sense to just Update first and then use the Official Migration tool if available for this Purpose.

avatar

Hello,

@Kaj the migration tool is only available in DVLS web interface. It's intended to migrate the accounts to another authentication method without loosing the user vault and specific settings.

forum image

@Damian, if your goal is to cleanup the user's account name is to standardize their formats, the Migration feature won't help you. Then the SQL query my colleague sent you will be the method to use.

Best regards,

Érica Poirier