Mass update user authentication

Products

• iDash Workload Automation

Issue/Introduction

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.

Environment

Release:
Component: AEIDSH

Resolution

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.