turbot/azure_insights

Query: load_balancer_probe

Usage

powerpipe query azure_insights.query.load_balancer_probe

Steampipe Tables

SQL

select
p ->> 'name' as "Name",
p -> 'properties' ->> 'intervalInSeconds' as "Interval In Seconds",
p -> 'properties' ->> 'numberOfProbes' as "Number Of Probes",
p -> 'properties' ->> 'port' as "Port",
p -> 'properties' ->> 'protocol' as "Protocol",
p ->> 'id' as "ID"
from
azure_lb,
jsonb_array_elements(probes) as p
where
lower(id) = $1;

Dashboards

The query is used in the dashboards: