Which users are not being authenticated through LDAP?

book

Article ID: 205502

calendar_today

Updated On:

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'