Removing Directory Servers, unused by users.

Products

• CA Release Automation - Release Operations Center (Nolio)

Issue/Introduction

Both LDAP and AD directory servers have been configured in the ROC.
How to identify unused AD servers and confirm that users have not been configured with these and do not need these in order to login.
So these Directory Servers can then be removed from the ROC.

Environment

Nolio Release Automation: All supported versions

Resolution

1. In "Administration -> User Management" check what is shown for the different users in the "Source" column.
2. Check these columns in the user table: ldap_authenticated,  ldap_host, directory_server_id
3. Identify the id of the different directory servers:
   select * from [dbo].[directory_server]
4. Check if any users have been configured with this id as shown in directory_server_id:
   select distinct directory_server_id, count (*) as Users from users
group by directory_server_id

If a user is configured with a directory server that has been removed from the ROC, then there may a problem for this user to login.