turbot/oci_compliance

Query: identity_user_db_credential_age_90

Usage

powerpipe query oci_compliance.query.identity_user_db_credential_age_90

SQL

select
id as resource,
case
when time_created <= (current_date - interval '90' day) then 'alarm'
else 'ok'
end as status,
title || ' API key' || ' 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_db_credential;

Controls

The query is being used by the following controls: