turbot/onepassword
steampipe plugin install onepassword

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

NameTypeOperatorsDescription
_ctxjsonbSteampipe context in JSON form, e.g. connection_name.
categorytextThe category of the item.
created_attimestamp with time zoneDate and time when the item was created.
datetimestamp with time zoneThe medical record date.
dosagetextDosage specified in the medical record.
favoritebooleanWhether the item is marked as a favorite.
fieldsjsonbThe fields of the item.
filesjsonbThe files of the item.
healthcare_professionaltextThe healthcare professional of the medical record.
idtext=The UUID of the item.
last_edited_bytextUUID of the user that last edited the item.
locationtextLocation specified in the medical record.
medicationtextMedication specified in the medical record.
medication_notestextMedication notes specified in the medical record.
patienttextThe patient details are specified in the medical record.
reasontextThe reason specified in the medical record.
sectionsjsonbThe sections of the item.
tagsjsonbAn array of strings of the tags assigned to the item.
titletextThe title of the item.
trashedbooleanChecks if the item is trashed.
updated_attimestamp with time zoneDate and time when the item was last changed.
urlsjsonbArray of URL objects containing URLs for the item.
vault_idtext=The UUID of the vault the item is in.
versionbigintThe 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