Check 2FA status in mongodb

Community Support
1

Hey there,

i would like to Check in my Rocket.Chat App whether our users have the 2FA activated or deactived.
Heres the Problem:
i dont have the Enterprise Plan so i cant force user roles to use 2FA.

image
image785×477 14.7 KB

Can i see this information anywhere else in the App ?
Is there a possibility to find such informations in any database?

Thank you for your help

2

i found the solution by myself:

  1. Access to the database. docker exec -it << nameOfDB >> mongosh
  2. show dbs (use the right database)
  3. Find all users which has TOTP acitvated:
    db.users.find(
    { “services.totp”: { $exists: true } },
    { username: 1, “services.totp”: 1 }
    ).pretty()

OR
list all users with any TOTP-Status:
db.users.find(
{},
{
username: 1,
“services.totp”: 1,
}
).pretty()