Remediate AWS CIS v3.0 and v4.0 with Flowpipe's interactive wizard →
Flowpipe Hub 
Hub
standard
turbot/aws_thrifty
Overview
94
Pipelines
31
Triggers
139
VariablesGitHub

Overview

SecretsManager secrets have an inherent monthly cost, therefore secrets which are no longer accessed / used should be removed to prevent further charges.

This query trigger detects unused secrets 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

  • secretsmanager_secrets_if_unused_trigger_enabled should be set to true as the default is false.
  • secretsmanager_secrets_if_unused_trigger_schedule should be set to your desired running schedule
  • secretsmanager_secrets_if_unused_default_action should be set to your desired action (i.e. "notify" for notifications or "delete_secret" to delete the secret).

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(name, ' [', region, '/', account_id, ']') as title,
  name,
  region,
  sp_connection_name as conn
from
  aws_secretsmanager_secret
where
  date_part('day', now() - last_accessed_date) > 90 :: int

Schedule

15m

Tags

category = Cost
class = unused
plugin = aws
service = AWS/Secrets Manager