standard
turbot/azure_compliance

Trigger: Detect & correct Subscriptions without application insight configured

Detect subscriptions without application insight configured.

Query

with application_insights as (
select
subscription_id,
count(*) as no_application_insight
from
azure_application_insight
group by
subscription_id
)
select
sub.subscription_id as title,
sub._ctx ->> 'connection_name' as conn
from
azure_subscription sub
left join application_insights as i on i.subscription_id = sub.subscription_id
where
i.subscription_id is null;

Schedule

15m

Tags

category = Compliance
plugin = azure
service = Azure/Monitor