• This site uses cookies. By continuing to use this site, you are agreeing to our use of cookies. Learn more.

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;