turbot/azure_insights

Query: network_interface_attached_virtual_machine

Usage

powerpipe query azure_insights.query.network_interface_attached_virtual_machine

SQL

select
vm.name as "Name",
lower(vm.id) as "ID"
from
azure_network_interface as ni
left join azure_compute_virtual_machine as vm on lower(vm.id) = lower(ni.virtual_machine_id)
where
vm.id is not null
and lower(ni.id) = $1
and ni.subscription_id = split_part($1, '/', 3);

Dashboards

The query is used in the dashboards: