Control: Security Center should use the standard pricing tier
Description
The standard pricing tier provides advanced security capabilities, including threat detection for Azure and hybrid workloads, just-in-time (JIT) virtual machine (VM) access, and access and application controls.
Usage
Run the control in your terminal:
powerpipe control run terraform_azure_compliance.control.securitycenter_uses_standard_pricing_tier
Snapshot and share results via Turbot Pipes:
powerpipe loginpowerpipe control run terraform_azure_compliance.control.securitycenter_uses_standard_pricing_tier --share
SQL
This control uses a named query:
select address as resource, case when (attributes_std ->> 'tier') = 'Standard' then 'ok' else 'alarm' end status, split_part(address, '.', 2) || case when (attributes_std ->> 'tier') = 'Standard' then ' uses standard pricing tier' else ' not use standard pricing tier' end || '.' reason , path || ':' || start_linefrom terraform_resourcewhere type = 'azurerm_security_center_subscription_pricing';