User database export

zbien
zbien
Community Member

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

Comments

  • 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'
    done
    

    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.

    Ben

  • zbien
    zbien
    Community Member

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

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

    Ben

This discussion has been closed.