turbot/ibm_insights

Query: ibm_kms_key_by_state

Usage

powerpipe query ibm_insights.query.ibm_kms_key_by_state

Steampipe Tables

SQL

select
case
when state = '0' then 'Pre-activation'
when state = '1' then 'Enabled'
when state = '2' then 'Disabled'
when state = '3' then 'Deactivated'
when state = '5' then 'Deleted'
else state
end as state_code,
count(*)
from
ibm_kms_key
group by
state_code;

Dashboards

The query is used in the dashboards: