XF 1.5 How many users have two factor authentication active?

Mouth

Well-known member
#1
Looking to find out how many users, preferably as a percentage, have two factor authentication action?
Cannot see a method in ACP, either through User Search or Statistics.
Also thought of a user group promotion (although a poor solution) but appears even that doesn't have the option to promote based on two factor authentication.

Is there a way to achieve this, or is it SQL query only?
 

teletubbi

Well-known member
#2
Also thought of a user group promotion (although a poor solution) but appears even that doesn't have the option to promote based on two factor authentication.
I have this option .
Thought first it came from the Addon user criteria from waindigo. So disabled it.
But this option is still there.
 

Mouth

Well-known member
#4
Thanks.
FYI, for anyone else wanting a list/count of users with 2FA active ...
Code:
select username from xf_user inner join xf_user_option on xf_user.user_id = xf_user_option.user_id where use_tfa = 1;
 
Top