Control: SignalR Service should not use free tier SKU
Description
This control checks whether SignalR service uses paid SKU for its SLA.
Usage
Run the control in your terminal:
powerpipe control run azure_compliance.control.signalr_service_no_free_tier_sku
Snapshot and share results via Turbot Pipes:
powerpipe loginpowerpipe control run azure_compliance.control.signalr_service_no_free_tier_sku --share
SQL
This control uses a named query:
select a.id as resource, case when sku ->> 'tier' = 'Free' then 'alarm' else 'ok' end as status, a.name || ' is of ' || (sku ->>'tier' )|| ' tier.' as reason , a.resource_group as resource_group , sub.display_name as subscriptionfrom azure_signalr_service as a, azure_subscription as subwhere sub.subscription_id = a.subscription_id;