turbot/ibm_insights

Query: ibm_kms_key_state_details

Usage

powerpipe query ibm_insights.query.ibm_kms_key_state_details

Steampipe Tables

SQL

select
'State' as label,
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 value,
case
when state in ('1', '0') then 'ok'
else 'alert'
end as "type"
from
ibm_kms_key
where
state <> '5'
and crn = $1;

Params

ArgsNameDefaultDescriptionVariable
$1crn

    Dashboards

    The query is used in the dashboards: