Guest Johnny Posted October 4, 2016 Report Share Posted October 4, 2016 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 Quote Link to post Share on other sites
support 214 Posted October 5, 2016 Report Share Posted October 5, 2016 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: Hopefully this only takes 10 - 15 minutes of your time:) Johhny 1 Quote Link to post Share on other sites
Johhny 0 Posted October 5, 2016 Report Share Posted October 5, 2016 Hi, That will work for me. A nice little scripting job for a Friday afternoon :-) Thanks :-) Quote Link to post Share on other sites
support 214 Posted October 5, 2016 Report Share Posted October 5, 2016 Great way to spend a Friday afternoon:) Good luck! Regards, Support Quote Link to post Share on other sites
Recommended Posts
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.