turbot/azure_insights

Query: network_network_interfaces_for_compute_virtual_machine_scale_set

Usage

powerpipe query azure_insights.query.network_network_interfaces_for_compute_virtual_machine_scale_set

SQL

with nic_list as (
select
n ->> 'name' as nic_name
from
azure_compute_virtual_machine_scale_set as s,
jsonb_array_elements(
virtual_machine_network_profile -> 'networkInterfaceConfigurations'
) n
where
lower(s.id) = $1
)
select
lower(nic.id) as network_interface_id
from
azure_compute_virtual_machine_scale_set_network_interface as nic
where
nic.name = (
select
nic_name
from
nic_list
)
and lower(
split_part(nic.virtual_machine ->> 'id', '/virtualMachines', 1)
) = $1
limit
1