XF 1.5 How many users have two factor authentication active?

[Mouth]

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]

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.

 

[Mike]

The criteria is a standard option. Otherwise, you need to look at xf_user_option.use_tfa in the DB.

 

[Mouth]

Thanks.
FYI, for anyone else wanting a list/count of users with 2FA active ...

select username from xf_user inner join xf_user_option on xf_user.user_id = xf_user_option.user_id where use_tfa = 1;