We have external authentication LDAP and we have few other non-ldap users. How can check what option is set currently?
Release : 13.0
Component : CA Harvest Software Change Manager
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”:
INNER JOIN HARUSERDATA ON HARUSER.USROBJID = HARUSERDATA.USROBJID
WHERE HARUSERDATA.ACCOUNTEXTERNAL = 'N'