Table: onepassword_item_identity - Query 1Password Identity Items using SQL

1Password is a password manager developed by AgileBits Inc. It provides a secure and convenient way to store and manage various types of sensitive information including passwords, identities, and secure notes. An Identity Item in 1Password represents personal information about a user, such as their name, address, phone number, and more.

Table Usage Guide

The onepassword_item_identity table provides insights into Identity Items within 1Password. As a security analyst, explore Identity Item-specific details through this table, including the associated vault, category, and the personal details stored in the item. Utilize it to uncover information about the stored identities, such as the associated tags, the time of creation and modification, and the verification of personal details.

Examples

Basic info

Explore which employees belong to a specific department within your company, gaining insights into their job titles and occupations. This can help in understanding the distribution of roles and responsibilities within each department.

select
  id,
  title,
  first_name,
  last_name,
  birth_date,
  company,
  department,
  gender,
  job_title,
  occupation
from
  onepassword_item_identity;

select
  id,
  title,
  first_name,
  last_name,
  birth_date,
  company,
  department,
  gender,
  job_title,
  occupation
from
  onepassword_item_identity;

List identities of a particular vault

Explore the profiles stored in a specific secure vault to gain insights into the identities it contains. This can be useful for auditing purposes, ensuring that only the appropriate identities are stored in a particular vault.

select
  i.id,
  i.title,
  first_name,
  last_name,
  birth_date,
  company,
  department,
  gender,
  job_title,
  occupation
from
  onepassword_item_identity as i,
  onepassword_vault as v
where
  i.vault_id = v.id
  and v.name = 'my-creds';

select
  i.id,
  i.title,
  first_name,
  last_name,
  birth_date,
  company,
  department,
  gender,
  job_title,
  occupation
from
  onepassword_item_identity as i,
  onepassword_vault as v
where
  i.vault_id = v.id
  and v.name = 'my-creds';

Show identities that contain a specific tag

Explore which identities are associated with a specific tag in order to manage and organize your data more effectively. This can be beneficial in scenarios such as identifying all employees associated with a specific project or department.

select
  id,
  title,
  first_name,
  last_name,
  birth_date,
  company,
  department,
  gender,
  job_title,
  occupation
from
  onepassword_item_identity
where
  tags @> '["chat-company"]';

Error: The corresponding SQLite query is unavailable.

List identities whose birth date is before a certain date

Discover the identities that were born before a specific date. This can be useful for demographic analysis or to identify potential age-related factors in your data.

select
  id,
  title,
  first_name,
  last_name,
  company,
  department,
  gender,
  job_title,
  occupation
from
  onepassword_item_identity
where
  birth_date < '1990-01-01';

select
  id,
  title,
  first_name,
  last_name,
  company,
  department,
  gender,
  job_title,
  occupation
from
  onepassword_item_identity
where
  birth_date < '1990-01-01';

Show identities with the job title software engineer

Explore which identities in your database are associated with the job title 'software engineer'. This can be useful for identifying potential candidates for internal job postings or for understanding the distribution of roles within your organization.

select
  id,
  title,
  first_name,
  last_name,
  birth_date,
  company,
  department,
  gender,
  occupation
from
  onepassword_item_identity
where
  job_title = 'software engineer';

select
  id,
  title,
  first_name,
  last_name,
  birth_date,
  company,
  department,
  gender,
  occupation
from
  onepassword_item_identity
where
  job_title = 'software engineer';

Get the number of identities for each occupation

Explore the distribution of identities across different occupations. This can provide insights into the diversity of roles within your organization.

select
  occupation,
  count(*)
from
  onepassword_item_identity
group by
  occupation;

select
  occupation,
  count(*)
from
  onepassword_item_identity
group by
  occupation;

Schema for onepassword_item_identity

Name	Type	Operators	Description
_ctx	jsonb		Steampipe context in JSON form, e.g. connection_name.
birth_date	timestamp with time zone		The birth date of the identity.
category	text		The category of the item.
company	text		The company of the identity.
created_at	timestamp with time zone		Date and time when the item was created.
department	text		The department of the identity.
favorite	boolean		Whether the item is marked as a favorite.
fields	jsonb		The fields of the item.
files	jsonb		The files of the item.
first_name	text		The first name of the identity.
gender	text		The gender of the identity.
id	text	=	The UUID of the item.
initial	text		The initial of the identity.
job_title	text		The job title of the identity.
last_edited_by	text		UUID of the user that last edited the item.
last_name	text		The last name of the identity.
occupation	text		The occupation of the identity.
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.
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_identity