Table: onepassword_item_medical_record - Query OnePassword Medical Records using SQL

OnePassword is a password manager developed by AgileBits Inc. It provides a platform where users can store various passwords, software licenses, and other sensitive information in a virtual vault locked with a PBKDF2-guarded master password. OnePassword's Medical Records feature allows users to securely store and manage sensitive health information.

Table Usage Guide

The onepassword_item_medical_record table provides insights into Medical Records within OnePassword. As a security analyst, explore medical record-specific details through this table, including the record's title, type, and associated metadata. Utilize it to uncover information about medical records, such as the record's UUID, vault UUID, and the time the record was last modified.

Examples

Basic info

Explore the details of medical records, such as the date, dosage, and healthcare professional involved. This can be useful for gaining insights into patient care and medication management.

select
  id,
  title,
  date,
  dosage,
  healthcare_professional,
  location,
  medication,
  patient,
  reason
from
  onepassword_item_medical_record;

select
  id,
  title,
  date,
  dosage,
  healthcare_professional,
  location,
  medication,
  patient,
  reason
from
  onepassword_item_medical_record;

List medical records of a particular vault

Explore the medical records stored in a specific vault to gain insights into healthcare details like medication dosage, attending professional, and the reason for treatment. This can be useful for managing and reviewing personal health information in a secure manner.

select
  r.id,
  r.title,
  date,
  dosage,
  healthcare_professional,
  location,
  medication,
  patient,
  reason
from
  onepassword_item_medical_record as r,
  onepassword_vault as v
where
  r.vault_id = v.id
  and v.name = 'my-creds';

select
  r.id,
  r.title,
  date,
  dosage,
  healthcare_professional,
  location,
  medication,
  patient,
  reason
from
  onepassword_item_medical_record as r,
  onepassword_vault as v
where
  r.vault_id = v.id
  and v.name = 'my-creds';

Show medical records that have been tagged as `important`

Identify instances where medical records have been marked as important. This can be useful for prioritizing patient care and ensuring critical information is not overlooked.

select
  id,
  title,
  date,
  dosage,
  healthcare_professional,
  location,
  medication,
  patient,
  reason
from
  onepassword_item_medical_record
where
  tags @> '["important"]';

Error: The corresponding SQLite query is unavailable.

List medical records for a specific patient

Explore medical history for a particular patient, including details like medication dosages, healthcare professional interactions, and reasons for treatment. This can help in understanding the patient's health trajectory and making informed healthcare decisions.

select
  id,
  title,
  date,
  dosage,
  healthcare_professional,
  location,
  medication,
  patient,
  reason
from
  onepassword_item_medical_record
where
  patient like '%sid%';

select
  id,
  title,
  date,
  dosage,
  healthcare_professional,
  location,
  medication,
  patient,
  reason
from
  onepassword_item_medical_record
where
  patient like '%sid%';

List medical records that contain a certain medication

Explore medical records to identify instances where a specific medication, such as Aspirin, has been prescribed. This can be useful in tracking medication usage patterns or for patient health management.

select
  id,
  title,
  date,
  dosage,
  healthcare_professional,
  location,
  medication,
  patient,
  reason
from
  onepassword_item_medical_record
where
  medication like '%aspirin%';

select
  id,
  title,
  date,
  dosage,
  healthcare_professional,
  location,
  medication,
  patient,
  reason
from
  onepassword_item_medical_record
where
  medication like '%aspirin%';

Schema for onepassword_item_medical_record

Name	Type	Operators	Description
_ctx	jsonb		Steampipe context in JSON form, e.g. connection_name.
category	text		The category of the item.
created_at	timestamp with time zone		Date and time when the item was created.
date	timestamp with time zone		The medical record date.
dosage	text		Dosage specified in the medical record.
favorite	boolean		Whether the item is marked as a favorite.
fields	jsonb		The fields of the item.
files	jsonb		The files of the item.
healthcare_professional	text		The healthcare professional of the medical record.
id	text	=	The UUID of the item.
last_edited_by	text		UUID of the user that last edited the item.
location	text		Location specified in the medical record.
medication	text		Medication specified in the medical record.
medication_notes	text		Medication notes specified in the medical record.
patient	text		The patient details are specified in the medical record.
reason	text		The reason specified in the medical record.
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_medical_record