Forum Discussion

Anitta's avatar
Anitta
New Contributor
9 months ago
Solved

How do I export only Vault and password metadata

We have a use case where we want to export the following fields: vault uid, vault name,  password uid, password name Users assigned to vaults We DONOT want to export the password in plaintext t...
discussion
  • Anitta's avatar
    Anitta
    9 months ago

    So I don't know if anyone will ever need to do this because after looking through various options, we found a way to get a onetime dump of information we needed using a token of a service account that has rights on all the vaults of interest and the following commands

    export OP_SERVICE_ACCOUNT_TOKEN=<Service account token>
op item list --format json| jq -r '["password_id","password_name","vault_id", "vault_name"], (.[] |[.id, .title, .vault."id", .vault."name"]) | @csv' > items.csv

    And then we uploaded the returned information into a datatable which we can use in rules and queries in Chronicle.

    We then deleted the token and service account because it was too permissive

1P_Dave's avatar
1P_Dave
Icon for Moderator rankModerator
9 months ago

Hello Anitta! 👋

Thank you for the question! It's not possible to selectively export that information using the 1Password app's export tool. The export tool is mostly meant to create an export of your login credentials, and other data, in case you decide to leave 1Password in the future and migrate to another password manager. 

Depending on your needs, it sounds like the reporting tools in 1Password Business might fit your needs more: Create reports in 1Password Business

If the reporting tools don't work for your needs then can you tell me a little more about your use case?

-Dave