turbot/oci_insights

Query: blockstorage_block_volume_attached_instances

Usage

powerpipe query oci_insights.query.blockstorage_block_volume_attached_instances

SQL

select
i.id as "Instance ID",
i.display_name as "Instance Name",
i.lifecycle_state as "Lifecycle State",
a.time_created as "Attachment Time"
from
oci_core_volume_attachment as a
left join oci_core_instance as i on a.instance_id = i.id
where
a.volume_id = $1;

Dashboards

The query is used in the dashboards: