samples
turbot/flowpipe-samples/deactivate-expired-aws-iam-access-keys-with-approval

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_name
from
aws_iam_access_key
where
create_date < now() - interval '90 days'
and status = 'Active';

Schedule

* * * * *