turbot/steampipe-mod-oci-insights

Dashboard: OCI Block Storage Block Volume Unattached Report

This report answers the following questions:

  • Which block volumes are attached to an instance?
This dashboard contains 1 card and 1 table.

Usage

Install the mod:

mkdir dashboards
cd dashboards
powerpipe mod init
powerpipe mod install github.com/turbot/steampipe-mod-oci-insights

Start the Powerpipe server:

steampipe service start
powerpipe server

Open http://localhost:9033 in your browser and select OCI Block Storage Block Volume Unattached Report dashboard.

You could also snapshot and share results via Turbot Pipes:

powerpipe login
powerpipe dashboard run oci_insights.dashboard.blockstorage_block_volume_unattached_report --share

Queries

This dashboard uses the the following queries:
select
count(*) as value,
'Unattached' as label,
case count(*) when 0 then 'ok' else 'alert' end as type
from
oci_core_volume
where
id not in (
select
volume_id
from
oci_core_volume_attachment
) and lifecycle_state <> 'TERMINATED';

Tags