Table: onepassword_item_credit_card - Query OnePassword Credit Card Items using SQL

OnePassword is a password manager developed by AgileBits Inc. It provides a place for users to store various passwords, software licenses, and other sensitive information in a virtual vault that is locked with a PBKDF2-guarded master password. The onepassword_item_credit_card resource in OnePassword represents the credit card items stored by users in their OnePassword vaults.

Table Usage Guide

The onepassword_item_credit_card table provides insights into credit card items within OnePassword. As a Security Analyst, explore credit card-specific details through this table, including card numbers, cardholder names, and expiry dates. Utilize it to uncover information about saved credit cards, such as the type of cards stored, the frequency of certain card types, and the verification of card details.

Examples

Basic info

Discover the segments that hold your credit card information for a quick review or update. This can be particularly useful for keeping track of card expirations or identifying your most frequently used cards.

select
  id,
  title,
  card_holder,
  credit_card_number,
  expiry_date,
  created_at,
  favorite
from
  onepassword_item_credit_card;

select
  id,
  title,
  card_holder,
  credit_card_number,
  expiry_date,
  created_at,
  favorite
from
  onepassword_item_credit_card;

List credit cards of a particular vault

Explore which credit cards are stored in a specific vault to manage and review your financial information efficiently. This can be particularly useful for organizing your personal finance or auditing corporate expense accounts.

select
  c.id,
  c.title,
  card_holder,
  credit_card_number,
  expiry_date,
  c.created_at,
  favorite
from
  onepassword_item_credit_card as c,
  onepassword_vault as v
where
  c.vault_id = v.id
  and v.name = 'my-creds';

select
  c.id,
  c.title,
  card_holder,
  credit_card_number,
  expiry_date,
  c.created_at,
  favorite
from
  onepassword_item_credit_card as c,
  onepassword_vault as v
where
  c.vault_id = v.id
  and v.name = 'my-creds';

select
  c.id,
  c.title,
  card_holder,
  credit_card_number,
  expiry_date,
  c.created_at,
  favorite
from
  onepassword_item_credit_card as c
  join onepassword_vault as v on c.vault_id = v.id
where
  v.name = 'my-creds';

Show credit cards that contain a specific tag

Explore which credit cards are associated with a specific tag, such as 'Amazon-use'. This can help in organizing and identifying credit cards that are used for specific platforms or purposes.

select
  id,
  title,
  card_holder,
  credit_card_number,
  expiry_date,
  created_at,
  favorite
from
  onepassword_item_credit_card
where
  tags @> '["amazon-use"]';

Error: The corresponding SQLite query is unavailable.

List expired credit cards

Explore which credit cards have expired to ensure secure and valid transactions. This is crucial to prevent any financial discrepancies or fraudulent activities.

select
  id,
  title,
  card_holder,
  credit_card_number,
  expiry_date,
  created_at,
  favorite
from
  onepassword_item_credit_card
where
  expiry_date < now();

select
  id,
  title,
  card_holder,
  credit_card_number,
  expiry_date,
  created_at,
  favorite
from
  onepassword_item_credit_card
where
  expiry_date < datetime('now');

List credit cards marked as favourite

Discover the segments that have marked their credit cards as favourite. This can assist in understanding user preferences and habits, potentially informing business strategies or marketing efforts.

select
  id,
  title,
  card_holder,
  credit_card_number,
  expiry_date,
  created_at,
  favorite
from
  onepassword_item_credit_card
where
  favorite;

select
  id,
  title,
  card_holder,
  credit_card_number,
  expiry_date,
  created_at,
  favorite
from
  onepassword_item_credit_card
where
  favorite = 1;

Schema for onepassword_item_credit_card

Name	Type	Operators	Description
_ctx	jsonb		Steampipe context in JSON form, e.g. connection_name.
card_holder	text		The card holder’s name for the credit card.
category	text		The category of the item.
created_at	timestamp with time zone		Date and time when the item was created.
credit_card_number	text		The credit card number.
expiry_date	timestamp with time zone		The expiry date of the credit card.
favorite	boolean		Whether the item is marked as a favorite.
fields	jsonb		The fields of the item.
files	jsonb		The files of the item.
id	text	=	The UUID of the item.
last_edited_by	text		UUID of the user that last edited the item.
sections	jsonb		The sections of the item.
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.
type	text		The type of the credit card.
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.
valid_from	timestamp with time zone		The valid from date of the credit card.
vault_id	text	=	The UUID of the vault the item is in.
verification_number	text		The cvv number of the credit card.
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_credit_card