turbot/steampipe-mod-ibm-compliance

Control: 1.10 Ensure contact email is valid

Description

In order to receive emails and account alerts related to an IBM Cloud account, a valid email address should always be on record with IBM Cloud. If you lose access to an email address, you should update your email address on record to ensure continuity of correspondence.

Remediation

From Console

  1. Log in to IBM Cloud.
  2. Click Avatar icon > Profile.
  3. Click the Edit link in the Contact information section
  4. Update your email to the correct email address.

Usage

Run the control in your terminal:

powerpipe control run ibm_compliance.control.cis_v100_1_10

Snapshot and share results via Turbot Pipes:

powerpipe login
powerpipe control run ibm_compliance.control.cis_v100_1_10 --share

SQL

This control uses a named query:

select
iam_id as resource,
case
when email !~ '^[A-Za-z0-9._%-]+@[A-Za-z0-9.-]+[.][A-Za-z]+$' and email is null then 'alarm'
else 'ok'
end as status,
case
when email !~ '^[A-Za-z0-9._%-]+@[A-Za-z0-9.-]+[.][A-Za-z]+$' and email is null then first_name || ' ' || last_name || ' has valid email.'
else first_name || ' ' || last_name || ' has valid email.'
end as reason,
account_id
from
ibm_iam_user;

Tags