Forum Discussion

Anonymous's avatar
Anonymous
3 years ago

How to export the user list from 1Password

Hi everyone, Can someone show me how to export all users within our 1Password to the csv file for audit purpose ? I can't find any docx about this. Thank you in advance !!! 1Password Ver...
CLI
Anonymous's avatar
Anonymous
3 years ago

Hey TungLe!

There is no native option to do this with the CLI. You could use op user list --format json, and then some jq magic, such as:

op user list --format json | jq -r '(map(keys) | add | unique) as $cols | map(. as $row | $cols | map($row[.])) as $rows | $cols, $rows[] | @csv'

to achieve this.

Let me know if this helps!