query to find the unapproved contacts -> PGSQL

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'

                    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) ...
                      • 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 ...
                      • 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 expected
                      • 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 ...