<iframe src="https://www.googletagmanager.com/ns.html?id=GTM-M74D8PB" height="0" width="0" style="display:none;visibility:hidden">
Loading
Skip to NavigationSkip to Main Content
0D54z00009dRsyMCASOkta Classic EngineMulti-Factor AuthenticationAnswered2025-09-13T09:01:51.000Z2023-09-05T17:57:50.000Z2023-10-12T15:26:29.000Z

EricO.42542 (Customer) asked a question.

Can I create a report of all employees and who does not have okta verify device enrolled

I found after 10 months a user who had not setup okta verify. We have office365 federated to okta, so I thought everyone who access emails,teams,onedrive would require okta mfa. But it appears anyone running thick client before federation did not get prompted for okta verify until password expired. I want to a way to identify any other employees.


  • MatthewH.10249 (State of Iowa)

    Yes you are correct. Sorry, I forgot to say that I would export a list all users via Okta Rockstar plugin and put both datasets in a spreadsheet and use VLOOKUP to compare and get list of ones that don't have Okta Verify.

    Selected as Best
  • MatthewH.10249 (State of Iowa)

    Check out the "MFA Enrollment by User" report found under "Reports->Reports->Multifactor Authentication" section in the Okta Admin Console.

  • EricO.42542 (Customer)

    That shows all users who have okta verify, but not what users are in okta and have not setup okta verify. (I Believe)

    • MatthewH.10249 (State of Iowa)

      Yes you are correct. Sorry, I forgot to say that I would export a list all users via Okta Rockstar plugin and put both datasets in a spreadsheet and use VLOOKUP to compare and get list of ones that don't have Okta Verify.

      Selected as Best
      • MarkP.53423 (Customer)

        I don't see that Rockstar exports any MFA related data...?

      • MatthewH.10249 (State of Iowa)

        Correct, the Rockstar export does not have MFA data but does show all users. Using a spreadsheet you can diff the users from the Rockstar export with the users from the "MFA Enrollment by User" report and the users that don't match would be ones that don't have MFA setup.

  • EricO.42542 (Customer)

    Ahh, thank you. I did not know about Rockstar plugin. Very useful.

  • a0n5s (a0n5s)

    @EricO.42542 (Customer)​ maybe this best practise is set Okta verify as require in the Authenticator. So all user must setup Okta verify when they login. If it is optional, the user still can ignore it.

  • EricO.42542 (Customer)

    I do have okta verify as required, the issue is I am only syncing the AD groups that had office employees. We have shared stations and supervisors who use teams now and not included, It would take an effort to handle all exceptions if I wanted to easily sync all groups.

  • wh7np (wh7np)

    You should be able to get this information with the MFA Enrollment by User report.

     

    If you specify in the filter criteria Authenticator Type / does not include / Okta Verify you will get a list of all users that have at least one authenticator enrollment (e.g. Password), but do not have an OV enrollment.

     

    Image is not available
     

    The edge case here would be users that have no authenticators enrolled at all, which I believe may happen with staged users. If you want to be super duper sure, you can join compare the list of users from the User Accounts report (all users in your directory), with a list of users from the MFA Enrollment by User report where Authenticator Type / includes / Okta Verify (all users with OV enrolled). For example, you could do this with a vlookup or a countIf statement in excel or google sheets. Any users that appear in the User Accounts report but not the MFA report would be those w/o an OV enrollment.

    Expand Post
This question is closed.
Loading
Can I create a report of all employees and who does not have okta verify device enrolled