Hi All,

Using below SQL query , we will be able to retrieve the UserID and User Domain Authentication from QCSITEADMIN_DB.


SELECT LOWER(qcsiteadmin_db.users.user_name),qcsiteadmin_db.users_auth_data.uad_value
FROM QCSITEADMIN_DB.USERS
LEFT OUTER JOIN QCSITEADMIN_DB.USERS_AUTH_DATA
ON QCSITEADMIN_DB.USERS.USER_ID = QCSITEADMIN_DB.USERS_AUTH_DATA.UAD_USER_ID
WHERE qcsiteadmin_db.users_auth_data.uad_key='LDAP_USER_DN'


How to get this same data using Site Admin OTA API?

Regards,Srihari