turbot/oci_compliance

Query: identity_auth_token_age_90

Usage

powerpipe query oci_compliance.query.identity_auth_token_age_90

Steampipe Tables

SQL

select
user_id as resource,
case
when lifecycle_state = 'ACTIVE'
and (date(current_timestamp) - date(time_created)) >= 90 then 'alarm'
else 'ok'
end as status,
user_name || ' auth token created ' || to_char(time_created, 'DD-Mon-YYYY') || ' (' || extract(
day
from
current_timestamp - time_created
) || ' days).' as reason,
tenant_name as tenant
from
oci_identity_auth_token;

Controls

The query is being used by the following controls: