turbot/azure_insights

Query: source_compute_disks_for_compute_disk

Usage

powerpipe query azure_insights.query.source_compute_disks_for_compute_disk

Steampipe Tables

SQL

select
lower(d2.id) as compute_disk_id
from
azure_compute_disk as d1
left join azure_compute_disk d2 on d1.creation_data_source_resource_id = d2.id
where
lower(d1.id) = $1
and lower(d2.id) is not null
and d2.subscription_id = split_part($1, '/', 3);