steampipe plugin install aws

Table: aws_securityhub_member - Query AWS Security Hub Members using SQL

The AWS Security Hub Members are a part of AWS Security Hub service that allows you to manage and improve the security of your AWS accounts. It aggregates, organizes, and prioritizes your security alerts, or findings, from multiple AWS services, such as Amazon GuardDuty, Amazon Inspector, and Amazon Macie, as well as from AWS Partner solutions. The Members feature specifically enables you to add accounts to and manage accounts in your Security Hub administrator account.

Table Usage Guide

The aws_securityhub_member table in Steampipe provides you with information about each member account within AWS Security Hub. This table allows you, as a DevOps engineer, to query member-specific details, including account ID, email, status, and the timestamp of the invitation. You can utilize this table to gather insights on member accounts, such as their invitation and verification status, the email associated with each account, and more. The schema outlines the various attributes of the Security Hub member for you, including the member account ID, email, status, invited at timestamp, and updated at timestamp.

Examples

Basic info

This query allows you to gain insights into the status and administrative details of member accounts within AWS Security Hub. It's useful for monitoring account activity and managing security settings.

select
member_account_id,
email,
administrator_id,
member_status,
updated_at
from
aws_securityhub_member;
select
member_account_id,
email,
administrator_id,
member_status,
updated_at
from
aws_securityhub_member;

List members which are enabled

Explore which members in your AWS Security Hub have their status enabled. This can be useful in maintaining security standards by ensuring only authorized members have access.

select
member_account_id,
email,
administrator_id,
member_status,
updated_at,
invited_at
from
aws_securityhub_member
where
member_status = 'Enabled';
select
member_account_id,
email,
administrator_id,
member_status,
updated_at,
invited_at
from
aws_securityhub_member
where
member_status = 'Enabled';

List members which are invited but did not accept

Discover the segments of your network where members have been invited but have yet to accept. This can be useful for tracking pending invitations and identifying potential issues with user engagement or notification delivery.

select
member_account_id,
email,
administrator_id,
member_status,
updated_at
from
aws_securityhub_member
where
member_status = 'Created';
select
member_account_id,
email,
administrator_id,
member_status,
updated_at
from
aws_securityhub_member
where
member_status = 'Created';

List members which were invited within the last 10 days

Determine the members who have been enabled and invited to your AWS Security Hub within the past ten days. This can help keep track of recent additions and manage your security operations effectively.

select
member_account_id,
email,
administrator_id,
member_status,
updated_at,
invited_at
from
aws_securityhub_member
where
member_status = 'Enabled'
and invited_at <= (now() - interval '10' day);
select
member_account_id,
email,
administrator_id,
member_status,
updated_at,
invited_at
from
aws_securityhub_member
where
member_status = 'Enabled'
and invited_at <= datetime('now', '-10 day');

Schema for aws_securityhub_member

NameTypeOperatorsDescription
_ctxjsonbSteampipe context in JSON form.
account_idtext=, !=, ~~, ~~*, !~~, !~~*The AWS Account ID in which the resource is located.
administrator_idtextThe Amazon Web Services account ID of the Security Hub administrator account associated with this member account.
emailtextThe email address of the member account.
invited_attimestamp with time zoneA timestamp for the date and time when the invitation was sent to the member account.
master_idtextThe Amazon Web Services account ID of the Security Hub administrator account associated with this member account.
member_account_idtextThe Amazon Web Services account ID of the member account.
member_statustextThe status of the relationship between the member account and its administrator account.
partitiontextThe AWS partition in which the resource is located (aws, aws-cn, or aws-us-gov).
regiontextThe AWS Region in which the resource is located.
sp_connection_nametext=, !=, ~~, ~~*, !~~, !~~*Steampipe connection name.
sp_ctxjsonbSteampipe context in JSON form.
titletextTitle of the resource.
updated_attimestamp with time zoneThe timestamp for the date and time when the member account was updated.

Export

This table is available as a standalone Exporter CLI. Steampipe exporters are stand-alone binaries that allow you to extract data using Steampipe plugins without a database.

You can download the tarball for your platform from the Releases page, but it is simplest to install them with the steampipe_export_installer.sh script:

/bin/sh -c "$(curl -fsSL https://steampipe.io/install/export.sh)" -- aws

You can pass the configuration to the command with the --config argument:

steampipe_export_aws --config '<your_config>' aws_securityhub_member