User database export


Is there a way to export the full list of users we have in 1Password? I am trying to get the "lastAuthAt" parameter for all of our accounts.
When I try to list users the parameter is not visible.
I can see it when I do "op get user" but I have to specify the precise name for which I want to get it.

1Password Version: Not Provided
Extension Version: Not Provided
OS Version: Not Provided
Sync Type: Not Provided


  • BenBen AWS Team

    Team Member

    Hi @zbien

    I believe I've written a script that may help with this. This script will print each user in your account in the format:

    email | lastAuthAt

    for currentuser in $(op list users | jq -r '.[] | .email'); do
        op get user $currentuser | jq -r '.email + " | " + .lastAuthAt'

    This requires jq be installed on the system. It may be a little slow to run, particularly if you have a lot of users on your system. Please let me know if that helps.


  • Hi @Ben
    This is exactly what I needed. Thank you very much for your help

  • BenBen AWS Team

    Team Member

    You're very welcome @zbien. If we can be of further assistance, please don't hesitate to contact us. :)


Leave a Comment

BoldItalicStrikethroughOrdered listUnordered list
Align leftAlign centerAlign rightToggle HTML viewToggle full pageToggle lights
Drop image/file