turbot/oci_insights

Query: objectstorage_bucket_object_lifecycle_policy

Usage

powerpipe query oci_insights.query.objectstorage_bucket_object_lifecycle_policy

Steampipe Tables

SQL

select
i ->> 'name' as "Name",
i ->> 'isEnabled' as "Enabled",
object_lifecycle_policy ->> 'timeCreated' as "Time Created",
i ->> 'action' as "Action",
i ->> 'target' as "Target",
i ->> 'timeAmount' as "Time Amount",
i ->> 'timeUnit' as "Time Unit"
from
oci_objectstorage_bucket,
jsonb_array_elements(object_lifecycle_policy -> 'items') as i
where
id = $1 and jsonb_typeof(object_lifecycle_policy -> 'items') = 'array';

Dashboards

The query is used in the dashboards: