Table: onepassword_item_secure_note - Query 1Password Secure Notes using SQL

1Password is a password manager developed by AgileBits Inc. It provides a place for users to store various types of sensitive information, including web logins, credit card information, and secure notes. A Secure Note in 1Password is a safe and convenient way to store and keep track of important information, such as server details, emergency instructions, or plans for world domination.

Table Usage Guide

The onepassword_item_secure_note table provides insights into Secure Notes within 1Password. As a Security Analyst, explore note-specific details through this table, including the note's title, vault ID, and associated metadata. Utilize it to uncover information about Secure Notes, such as those with specific tags, the notes belonging to a specific vault, and the verification of note details.

Examples

Basic info

Explore which secure notes in your 1Password vault have been updated recently. This allows you to keep track of changes and ensure your information is up-to-date.

select
  id,
  title,
  vault_id,
  created_at,
  notes_plain,
  tags,
  updated_at,
  version
from
  onepassword_item_secure_note;

select
  id,
  title,
  vault_id,
  created_at,
  notes_plain,
  tags,
  updated_at,
  version
from
  onepassword_item_secure_note;

List secure notes of a particular vault

Explore secure notes within a specific vault to review and manage your sensitive information more effectively. This can be particularly useful for maintaining data integrity and ensuring the correct information is stored in the right vault.

select
  s.id,
  s.title,
  notes_plain,
  s.created_at,
  s.updated_at,
  favorite
from
  onepassword_item_secure_note as s,
  onepassword_vault as v
where
  s.vault_id = v.id
  and v.name = 'my-creds';

select
  s.id,
  s.title,
  notes_plain,
  s.created_at,
  s.updated_at,
  favorite
from
  onepassword_item_secure_note as s,
  onepassword_vault as v
where
  s.vault_id = v.id
  and v.name = 'my-creds';

select
  s.id,
  s.title,
  notes_plain,
  s.created_at,
  s.updated_at,
  favorite
from
  onepassword_item_secure_note as s
  join onepassword_vault as v on s.vault_id = v.id
where
  v.name = 'my-creds';

Show secure notes that contain a specific tag

Explore secure notes that are associated with a specific tag. This could be useful for quickly identifying all notes related to a particular topic or category, such as those tagged for use with Amazon.

select
  id,
  title,
  vault_id,
  created_at,
  notes_plain,
  tags,
  updated_at,
  version
from
  onepassword_item_secure_note
where
  tags @> '["amazon-use"]';

Error: The corresponding SQLite query is unavailable.

List secure notes that are marked as favourite

Discover the segments that consist of secure notes marked as favourites, allowing you to easily track and manage your most important notes. This is useful for prioritizing and accessing your key information quickly and efficiently.

select
  id,
  title,
  vault_id,
  created_at,
  notes_plain,
  tags,
  updated_at,
  version
from
  onepassword_item_secure_note
where
  favorite;

select
  id,
  title,
  vault_id,
  created_at,
  notes_plain,
  tags,
  updated_at,
  version
from
  onepassword_item_secure_note
where
  favorite = 1;

Schema for onepassword_item_secure_note

Name	Type	Operators	Description
_ctx	jsonb		Steampipe context in JSON form.
category	text		The category of the item.
created_at	timestamp with time zone		Date and time when the item was created.
favorite	boolean		Whether the item is marked as a favorite.
fields	jsonb		The secure note fields.
files	jsonb		The secure note files.
id	text	=	The UUID of the item.
last_edited_by	text		UUID of the user that last edited the item.
notes_plain	text		The name of the notes plain.
sections	jsonb		The secure note sections.
sp_connection_name	text	=, !=, ~~, ~~, !~~, !~~	Steampipe connection name.
sp_ctx	jsonb		Steampipe context in JSON form.
tags	jsonb		An array of strings of the tags assigned to the item.
title	text		The title of the item.
trashed	boolean		Checks if the item is trashed.
updated_at	timestamp with time zone		Date and time when the item was last changed.
urls	jsonb		Array of URL objects containing URLs for the item.
vault_id	text	=	The UUID of the vault the item is in.
version	bigint		The version of the item.

Export

This table is available as a standalone Exporter CLI. Steampipe exporters are stand-alone binaries that allow you to extract data using Steampipe plugins without a database.

You can download the tarball for your platform from the Releases page, but it is simplest to install them with the steampipe_export_installer.sh script:

/bin/sh -c "$(curl -fsSL https://steampipe.io/install/export.sh)" -- onepassword

You can pass the configuration to the command with the --config argument:

steampipe_export_onepassword --config '<your_config>' onepassword_item_secure_note