query to find the unapproved contacts -> PGSQL
Below is the query to find the unapproved contacts -> PGSQL-> can be used from version 11
SELECT aaauser.User_id AS "User ID",
aaauser.first_name "First name",
aaauser.last_name "Last name",
hd.id "Portal ID",
hd.displayname "Portal Name",
sduser.status FROM PortalUsers ptu
LEFT JOIN SDUser sduser ON ptu.USERID=sduser.USERID
LEFT JOIN AaaUser aaauser ON sduser.USERID=aaauser.USER_ID
Left Join helpdeskdetails hd on ptu.helpdeskid = hd.id where sduser.status = 'UNAPPROVED'
aaauser.first_name "First name",
aaauser.last_name "Last name",
hd.id "Portal ID",
hd.displayname "Portal Name",
sduser.status FROM PortalUsers ptu
LEFT JOIN SDUser sduser ON ptu.USERID=sduser.USERID
LEFT JOIN AaaUser aaauser ON sduser.USERID=aaauser.USER_ID
Left Join helpdeskdetails hd on ptu.helpdeskid = hd.id where sduser.status = 'UNAPPROVED'
New to ADSelfService Plus?
Related Articles
Steps to Import accounts / contacts through schedule csv from SCP 11001 build
This is applicable only from 11001 builds. How to do? # Based on the Globalconfig table entry with category as 'CSVUserImportSchedule', this can be turned ON/OFF. By default this is turned OFF. Query to enable the feature - update Globalconfig set ...List of contacts logged into the system
Mysql select aas.session_id "SessionID", aal.name "User Name",aau.FIRST_NAME "Contact Name",org.NAME "Account Name", aas.user_host "User Host", aas.application_host "Application Host", longtodate(aas.opentime) "Start Time", longtodate(aas.closetime) ...Custom Script to enable "remove login" option for contacts in SCP 8.1
Use case: To disable login for contacts in bulk from Contacts module. The attached CustomScripts.js can be moved to SupportCenter/custom/scripts directory. Browser cache needs to be cleared for the script to work as expectedWorkaround for Contacts tab not visible for support reps (post 11.0 version)
Post 11.0, the contacts tab will not be shown at the top for support reps. As a workaround follow these steps 1. Goto Admin -> ZOHO Creator apps 2. Click on Add Links -> Provide Link Name as Contacts -> URL as ...Reject unregistered users mail and notify them
Usecase : Organizations dont want to handle/fetch unregistered contacts mails into the application. They also want to notify the end user when they send email stating The Request raised by you is rejected. Kindly send mail from the registered email ...