turbot/tailpipe-mod-azure-activity-log-detections

Detection: Automation Account Runbook Deleted

Overview

Detect when an Azure Automation Account runbook was deleted. Runbooks are critical for automating tasks, and their deletion can disrupt workflows or indicate unauthorized actions. Monitoring these deletions ensures the integrity and continuity of automation processes.

References:

Usage

Run the detection in your terminal:

powerpipe detection run azure_activity_log_detections.detection.automation_account_runbook_deleted

Snapshot and share results via Turbot Pipes:

powerpipe login
powerpipe detection run azure_activity_log_detections.detection.automation_account_runbook_deleted --share

SQL

This detection uses a named query:

select
tp_timestamp as timestamp,
operation_name as operation,
resource_id as resource,
caller as actor,
tp_index::varchar as subscription_id,
resource_group_name as resource_group,
tp_id as source_id,
status as event_status,
*
from
azure_activity_log
where
operation_name = 'Microsoft.Automation/automationAccounts/runbooks/delete'
and status = 'Succeeded'
order by
timestamp desc;

Tags