1. 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?

Discussion in 'XenForo Questions and Support' started by Mouth, Jul 12, 2016.

  1. Mouth

    Mouth Well-Known Member

    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?
     
  2. teletubbi

    teletubbi Active Member

    I have this option .
    Thought first it came from the Addon user criteria from waindigo. So disabled it.
    But this option is still there.
     
  3. Mike

    Mike XenForo Developer Staff Member

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

    Mouth Well-Known Member

    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;
     

Share This Page