sample
turbot/flowpipe-samples/deactivate-expired-aws-iam-access-keys-with-approval
Get Involved
Version
Trigger: List Expired IAM Access Keys
List IAM access keys older than 90 days.
Query
select access_key_id, user_name, account_id, _ctx ->> 'connection_name' as conn_namefrom aws_iam_access_keywhere create_date < now() - interval '90 days' and status = 'Active';
Schedule
* * * * *