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
Login Frequency Query Report
The below report would help us find the last logged in time of the users in SCP 11.0 SELECT AaaUser.FIRST_NAME "Technician", MAX(AaaLogin.NAME) "LoginName", MAX(AaaContactInfo.EMAILID) "Email", MAX(AaaAccSession.USER_HOST) "IP ...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 expectedReject 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 ...