Table: fly_organization_member - Query Fly.io Organization Members using SQL

Fly.io is a deployment platform that automates the work of managing and orchestrating containers. It provides a global application runtime for developers to deploy and run application code in any language, using datacenters closer to users for better performance. An Organization Member in Fly.io is an individual who has been granted access to an organization and may have different roles and permissions based on their assignment.

Table Usage Guide

The fly_organization_member table provides insights into Organization Members within Fly.io. As a DevOps engineer or IT administrator, you can use this table to understand the roles and permissions of each member within your organization. You can also use it to monitor and manage members' access to different resources, ensuring the security and efficiency of your organization's operations.

Examples

Basic info

Explore which roles each member holds within your organization, gaining insights into the distribution of responsibilities and hierarchical structure. This can be particularly useful for assessing the elements within your team and identifying areas for growth or reorganization.

select
  name,
  email,
  username,
  role,
  organization_id
from
  fly_organization_member;

select
  name,
  email,
  username,
  role,
  organization_id
from
  fly_organization_member;

List all admins in the organization

Explore which members in your organization hold administrative roles. This helps in understanding the distribution of administrative privileges and aids in managing user permissions effectively.

select
  name,
  email,
  username,
  role,
  organization_id
from
  fly_organization_member
where
  role = 'ADMIN';

select
  name,
  email,
  username,
  role,
  organization_id
from
  fly_organization_member
where
  role = 'ADMIN';

List all members with two-factor authentication disabled

Discover the members who have not enabled two-factor authentication. This is useful to identify potential security risks and ensure that all members are adhering to best practices for account protection.

select
  name,
  email,
  username,
  role,
  organization_id
from
  fly_organization_member
where
  not two_factor_protection;

select
  name,
  email,
  username,
  role,
  organization_id
from
  fly_organization_member
where
  two_factor_protection = 0;

List all members with restricted access

Identify members within an organization who have restricted access, providing insights into user roles and permissions for better access management.

select
  name,
  email,
  username,
  role,
  organization_id
from
  fly_organization_member
where
  trust = 'RESTRICTED';

select
  name,
  email,
  username,
  role,
  organization_id
from
  fly_organization_member
where
  trust = 'RESTRICTED';

Schema for fly_organization_member

Name	Type	Operators	Description
_ctx	jsonb		Steampipe context in JSON form.
avatar_url	text		The avatar URL of the member.
created_at	timestamp with time zone		The timestamp when the member was created.
email	text		The email address of the member.
feature_flags	jsonb		A list of feature flags.
has_node_proxy_apps	boolean		True, if the member has node proxy app.
id	text		A unique identifier of the member.
last_region	text		Specifies the region the member is recently accessed to.
name	text		The name of the member.
organization_id	text		The ID of the organization.
role	text		The role of the member in the organization.
sp_connection_name	text	=, !=, ~~, ~~, !~~, !~~	Steampipe connection name.
sp_ctx	jsonb		Steampipe context in JSON form.
trust	text		Specifies the trust level. Possible values are: UNKNOWN, RESTRICTED, BANNED, LOW, HIGH.
two_factor_protection	boolean		If true, two-factor authentication is enabled for the member.
username	text		The username of the member.

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)" -- fly

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

steampipe_export_fly --config '<your_config>' fly_organization_member