turbot/ibm_compliance

Query: iam_user_with_valid_phone

Usage

powerpipe query ibm_compliance.query.iam_user_with_valid_phone

Steampipe Tables

SQL

select
iam_id as resource,
case
when phonenumber is not null and alt_phonenumber != '' then 'ok'
else 'alarm'
end as status,
case
when phonenumber is not null and alt_phonenumber != '' then first_name || ' ' || last_name || ' has phone number configured.'
else first_name || ' ' || last_name || ' has no phone number configured.'
end as reason,
account_id
from
ibm_iam_user;

Controls

The query is being used by the following controls: