Jump to content

Bulk update email addresses


Guest Johnny

Recommended Posts

Guest Johnny

Hi,

 

Is it possible to bulk update email addresses in the system?

 

We use Admin accounts to access the system, and these have no email address connected to them.

We have about 200 users in the system, and I would like to take a list of users and update the email addresses with a script. Is this possible?

 

Best regards,

Johnny

Link to post
Share on other sites

Hi Johnny,

 

Unfortunately there's no real easy way to script this, as our API does not support the modifications to the User Accounts area in the main Passwordstate console.  It is possible to use something like Powershell to loop through some data and update SQL accordingly, but this may take some time to script up.  

 

The quickest thing we could suggest at this stage, would be to edit the dbo.UserAccounts table manually using SQL, as this would be quicker than updating directly through our UI.  To do this, right click the table, and select Edit Top 200 rows and update the email field accordingly:

 

2016-10-05_11-04-24.png

 

 

Hopefully this only takes 10 - 15 minutes of your time:)

Link to post
Share on other sites

Join the conversation

You can post now and register later. If you have an account, sign in now to post with your account.

Guest
Reply to this topic...

×   Pasted as rich text.   Paste as plain text instead

  Only 75 emoji are allowed.

×   Your link has been automatically embedded.   Display as a link instead

×   Your previous content has been restored.   Clear editor

×   You cannot paste images directly. Upload or insert images from URL.

Loading...
×
×
  • Create New...