Forum Discussion

Anonymous's avatar
Anonymous
2 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 Version: Not Provided
Extension Version: Not Provided
OS Version: Not Provided
Browser: Not Provided

cli

3 Replies

  • Anonymous's avatar
    Anonymous
    2 years ago

    Glad you could make progress, @TungLe!

  • Anonymous's avatar
    Anonymous
    2 years ago

    Thank you. Please close the ticket as I have solved it.

  • Anonymous's avatar
    Anonymous
    2 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!