turbot/oci_insights

Query: blockstorage_block_volume_backup_policy_schedules

Usage

powerpipe query oci_insights.query.blockstorage_block_volume_backup_policy_schedules

SQL

select
s ->> 'period' as "Period",
s ->> 'timeZone' as "Time Zone",
s ->> 'hourOfDay' as "Hour Of Day",
s ->> 'backupType' as "Backup Type",
s ->> 'dayOfMonth' as "Day Of Month",
s ->> 'offsetType' as "Offset Type",
s ->> 'offsetSeconds' as "Offset Seconds",
s ->> 'retentionSeconds' as "Retention Seconds"
from
oci_core_volume as v,
oci_core_volume_backup_policy as p,
jsonb_array_elements(schedules) as s
where
p.id = v.volume_backup_policy_id
and v.id = $1
union
select
s ->> 'period' as "Period",
s ->> 'timeZone' as "Time Zone",
s ->> 'hourOfDay' as "Hour Of Day",
s ->> 'backupType' as "Backup Type",
s ->> 'dayOfMonth' as "Day Of Month",
s ->> 'offsetType' as "Offset Type",
s ->> 'offsetSeconds' as "Offset Seconds",
s ->> 'retentionSeconds' as "Retention Seconds"
from
oci_core_volume as v,
oci_core_volume_default_backup_policy as p,
jsonb_array_elements(schedules) as s
where
p.id = v.volume_backup_policy_id
and v.id = $1;

Dashboards

The query is used in the dashboards: