Mass update user authentication

Document ID : KB000101605
Last Modified Date : 15/06/2018
Show Technical Document Details
We upgraded to 12.0.4 from 11.4. All of the users have idash as the default authentication. We need to change this to ldap. How can this be done without going through the admin tool gui? We have over 850 accounts to update.
The below SQL query executed against the iDash database will switch the user definitions to be configured with AD, except for idashAdm user which should continue to use the iDash authentication. update idash_config set value='auth.type.ldap' where type='user' and tag='idash.user.authentication.type' and ID !='idashAdm' and deleted=0 You should also enable the Active Directory authentication in Admin Tool - Security - GUI Authentication panel.