turbot/steampipe-mod-alicloud-insights

Dashboard: AliCloud KMS CMK Lifecycle Report

This report answers the following questions:

  • Is automatic rotation enabled on my keys?
  • How many keys are pending for deletion?
This dashboard contains 2 cards and 1 table.

Usage

Install the mod:

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

Start the Powerpipe server:

steampipe service start
powerpipe server

Open http://localhost:9033 in your browser and select AliCloud KMS CMK Lifecycle Report dashboard.

You could also snapshot and share results via Turbot Pipes:

powerpipe login
powerpipe dashboard run alicloud_insights.dashboard.kms_key_lifecycle_report --share

Queries

This dashboard uses the the following queries:
select
k.key_id as "Key ID",
k.automatic_rotation as "Key Rotation",
k.key_state as "Key State",
k.delete_date as "Deletion Date",
a.title as "Account",
k.account_id as "Account ID",
k.region as "Region",
k.arn as "ARN"
from
alicloud_kms_key as k,
alicloud_account as a
where
k.account_id = a.account_id
order by
k.key_id;

Tags