How to retrieve UserID and User Domain Authentication String using Site Admin API

Question ID: 109567
0
0

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

Marked as spam
Posted by (Questions: 28, Answers: 21)
Asked on May 29, 2020 8:04 am
7 views