Control: 5.2.9 Ensure that Activity Log Alert exists for Create or Update Public IP Address rule

Description

Create an activity log alert for the Create or Update Public IP Addresses rule.

Monitoring for Create or Update Public IP Address events gives insight into network access changes and may reduce the time it takes to detect suspicious activity.

Remediation

From Azure Portal

Navigate to the Monitor blade.
Select Alerts.
Select Create.
Select Alert rule.
Under Filter by subscription, choose a subscription.
Under Filter by resource type, select Public IP addresses.
Under Filter by location, select All.
From the results, select the subscription.
Select Done.
Select the Condition tab.
Under Signal name, click Create or Update Public Ip Address (Microsoft.Network/publicIPAddresses).
Select the Actions tab.
To use an existing action group, click Select action groups. To create a new action group, click Create action group. Fill out the appropriate details for the selection.
Select the Details tab.
Select a Resource group, provide an Alert rule name and an optional Alert rule description.
Click Review + create.
Click Create.

From Azure CLI

az monitor activity-log alert create --resource-group "<resource group name>" --condition category=Administrative and operationName=Microsoft.Network/publicIPAddresses/write and level=<verbose | information | warning | error | critical>--scope
"/subscriptions/<subscription ID>" --name "<activity log rule name>" -- subscription <subscription id> --action-group <action group ID> --location global

From PowerShell

Create the Conditions object.

$conditions = @()
$conditions += New-AzActivityLogAlertAlertRuleAnyOfOrLeafConditionObject - Equal Administrative -Field category
$conditions += New-AzActivityLogAlertAlertRuleAnyOfOrLeafConditionObject - Equal Microsoft.Network/publicIPAddresses/write -Field operationName
$conditions += New-AzActivityLogAlertAlertRuleAnyOfOrLeafConditionObject - Equal Verbose -Field level

Retrieve the Action Group information and store in a variable, then create the Actions object.

$actionGroup = Get-AzActionGroup -ResourceGroupName <resource group name> -Name <action group name>
$actionObject = New-AzActivityLogAlertActionGroupObject -Id $actionGroup.Id

Create the Scope object

$scope = "/subscriptions/<subscription ID>"

Create the Activity Log Alert Rule for Microsoft.Sql/servers/firewallRules/delete

New-AzActivityLogAlert -Name "<activity log alert rule name>" - ResourceGroupName "<resource group name>" -Condition $conditions -Scope $scope -Location global -Action $actionObject -Subscription <subscription ID> -Enabled $true

Default Value

By default, no monitoring alerts are created or active.

Usage

Run the control in your terminal:

powerpipe control run azure_compliance.control.cis_v200_5_2_9

Snapshot and share results via Turbot Pipes:

powerpipe login
powerpipe control run azure_compliance.control.cis_v200_5_2_9 --share

SQL

This control uses a named query:

with alert_rule as
(
  select
    alert.id as alert_id,
    alert.name as alert_name,
    alert.enabled,
    alert.location,
    alert.subscription_id
  from
    azure_log_alert as alert,
    jsonb_array_elements_text(scopes) as sc
  where
    alert.location = 'global'
    and alert.enabled
    and sc = '/subscriptions/' || alert.subscription_id
    and
    (
      ( alert.condition -> 'allOf' @> '[{"equals":"Administrative","field":"category"}]'
        and alert.condition -> 'allOf' @> '[{"field": "operationName", "equals": "Microsoft.Network/publicIPAddresses/write"}]'
      )
      or
      (
        alert.condition -> 'allOf' @> '[{"equals":"Administrative","field":"category"}]'
        and alert.condition -> 'allOf' @> '[{"field": "resourceType", "equals": "microsoft.network/publicipaddresses"}]'
        and jsonb_array_length(alert.condition -> 'allOf') = 2
      )
    )
    limit 1
)
select
  sub.subscription_id as resource,
  case
    when count(a.subscription_id) > 0 then 'ok'
    else 'alarm'
  end as status,
  case
    when count(a.subscription_id) > 0 then 'Activity Log Alert exists for Create or Update Public IP Address rule.'
    else 'Activity Log Alert does not exists for Create or Update Public IP Address rule.'
  end as reason
  
  , sub.display_name as subscription
from
  azure_subscription sub
  left join alert_rule a on sub.subscription_id = a.subscription_id
group by
  sub._ctx,
  sub.subscription_id,
  sub.display_name;