Detect & correct Compute disks exceeding max age

Overview

Compute disk can be quite costly to retain, it is also likely that after a certain point in time they're no longer required and should be cleaned up to prevent further costs.

This query trigger detects compute disks exceeding max age and then either sends a notification or attempts to perform a predefined corrective action.

Getting Started

By default, this trigger is disabled, however it can be configured by setting the below variables

compute_disks_exceeding_max_size_trigger_enabled should be set to true as the default is false.
string should be set to your desired running schedule
compute_disks_exceeding_max_size_default_action should be set to your desired action (i.e. "notify" for notifications or "snapshot_and_delete_disk" to snapshot and delete the disk).

Then starting the server:

flowpipe server

or if you've set the variables in a .fpvars file:

flowpipe server --var-file=/path/to/your.fpvars

Pipeline

Correct Compute disks exceeding max size

Query

select
  concat(
    disk.id,
    ' [',
    '/',
    disk.resource_group,
    '/',
    disk.subscription_id,
    ']'
  ) as title,
  disk.id as resource,
  disk.name,
  disk.subscription_id,
  disk.resource_group,
  disk.name || to_char(current_date, 'YYYYMMDD') as snapshot_name,
  disk.disk_size_gb,
  disk.sp_connection_name as conn
from
  azure_compute_disk as disk,
  azure_subscription as sub
where
  disk.disk_size_gb >= 90
  and sub.subscription_id = disk.subscription_id;

Schedule