How to export the user list from 1Password

Options
TungLe
TungLe
Community Member
edited July 2023 in CLI

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

Comments

  • Horia.Culea_1P
    Horia.Culea_1P
    Options

    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!

  • TungLe
    TungLe
    Community Member
    Options

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

  • ArunV1P
    ArunV1P
    Options

    Glad you could make progress, @TungLe!

This discussion has been closed.