User database export

zbien

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

Ben

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

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

Ben

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

Ben