Rant & Rave: Password reset - how to find admins when they do not show up in 'only show admin users'

• Rant&Rave
• User Management (V2)

• Failed log in attempts
• Unable to find the admin user
• Admin user option blank

Identified the admin users on the account.

If the list of admins comes up empty when 'only show admin users' is ticked, untick this and look for the profile which includes the 'admin' flag profile like below. Admins are under this profile.

or you can run this script in the database to find out the administrators

SELECT suc.user_id, suc.username, suc.system_status, pm.project_id FROM system_user_credential suc

LEFT JOIN system_configuration_user_features uf USING(user_id)

LEFT JOIN system_configuration_user_project_features upf USING(user_id)

LEFT JOIN system_user_project_mapping pm USING(user_id)

WHERE (uf.feature_id = 182 OR upf.feature_id = 182) AND suc.system_status != '-1' AND pm.project_id =xxxx;

The client's account was disabled due to multiple attempts to log in

https://upland.zendesk.com/agent/tickets/713242