standard
turbot/azure_thrifty

Detect & correct SQL Databases exceeding max age

Overview

SQL Databases 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 pipeline allows you to specify a collection of SQL Databases and then either send notifications or attempt to perform a predefined corrective action upon the collection.

Getting Started

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

  • sql_database_exceeding_max_age_trigger_enabled should be set to true as the default is false.
  • sql_database_exceeding_max_age_trigger_schedule should be set to your desired running schedule
  • sql_database_exceeding_max_age_default_action should be set to your desired action (i.e. "notify" for notifications or "delete_sql_database" to delete the SQL database).

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

Query

select
concat(
db.id,
' [',
db.resource_group,
'/',
db.subscription_id,
']'
) as title,
db.name,
db.resource_group,
db.subscription_id,
db.server_name as server_name,
db.sp_connection_name as conn
from
azure_sql_database as db,
azure_subscription as sub
where
date_part('day', now() - creation_date) > 90
and sub.subscription_id = db.subscription_id;

Schedule

15m

Tags

category = Cost
class = unused
plugin = azure
service = Azure/SQL