Which users are not being authenticated through LDAP?

Products

• CA Harvest Software Change Manager
• CA Harvest Software Change Manager - OpenMake Meister

Issue/Introduction

We have external authentication LDAP and we have few other non-ldap users. How can check what option is set currently?

Environment

Release : 13.0

Component : CA Harvest Software Change Manager

Resolution

There are 2 ways to do this

a. In the Administrator Tool go to Reports -> Users. It gives you a list of all users and will show what the external authentication flag is set to.

b. This SQL will give you a list of all users where the external authentication flag is set to “No”:

SELECT
HARUSER.USERNAME,
HARUSER.REALNAME
FROM HARUSER
INNER JOIN HARUSERDATA ON HARUSER.USROBJID = HARUSERDATA.USROBJID
WHERE HARUSERDATA.ACCOUNTEXTERNAL = 'N'