Table: onepassword_item_software_license - Query 1Password Software Licenses using SQL

1Password is a password manager developed by AgileBits Inc. It provides a secure and convenient way to store and manage passwords, software licenses, and other sensitive information. 1Password's Software License feature enables users to securely store and manage all their software licenses in one place.

Table Usage Guide

The onepassword_item_software_license table provides insights into Software Licenses within 1Password. As an IT administrator, explore license-specific details through this table, including item details, vault details, and category details. Utilize it to manage and track all software licenses, ensuring compliance and preventing unauthorized usage.

Examples

Basic info

Analyze the settings to understand the status and details of your software licenses, including their creation and last update dates, and whether they are marked as favorites. This can help in managing and tracking your licenses effectively.

select
  id,
  title,
  license_key,
  created_at,
  updated_at,
  favorite
from
  onepassword_item_software_license;

select
  id,
  title,
  license_key,
  created_at,
  updated_at,
  favorite
from
  onepassword_item_software_license;

List software licenses of a particular vault

Explore the software licenses stored in a specific vault to manage and keep track of your software assets effectively. This is particularly useful for auditing purposes and ensuring compliance with software licensing agreements.

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

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

Show software licenses that contain a specific tag

Discover the segments that have a specific tag within your software licenses. This can be particularly useful when you want to categorize and manage your licenses based on certain criteria or attributes.

select
  id,
  title,
  license_key,
  created_at,
  updated_at,
  favorite,
  tags
from
  onepassword_item_software_license
where
  tags @> '["amazon-use"]';

Error: The corresponding SQLite query is unavailable.

List software licenses that are marked as favourite

Explore which software licenses are marked as favourites to better manage your software assets. This helps in quickly identifying your most important licenses and ensuring they are up-to-date.

select
  id,
  title,
  license_key,
  created_at,
  updated_at,
  favorite,
  tags
from
  onepassword_item_software_license
where
  favorite;

select
  id,
  title,
  license_key,
  created_at,
  updated_at,
  favorite,
  tags
from
  onepassword_item_software_license
where
  favorite = 1;

Schema for onepassword_item_software_license

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 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.
license_key	text		The license key name.
sections	jsonb		The sections of the item.
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_software_license