Table: sentry_organization - Query Sentry Organizations using SQL

Sentry is an open-source error tracking tool that helps developers monitor and fix crashes in real-time. The organization resource within Sentry represents a group of users and teams that have access to a set of projects. It provides details about the organization's name, slug, status, onboarding tasks, and more.

Table Usage Guide

The sentry_organization table provides insights into Organizations within Sentry. As a developer or Sentry administrator, you can explore organization-specific details through this table, including name, slug, status, and onboarding tasks. Utilize it to uncover information about organizations, such as their status and details about onboarding tasks, helping to manage and monitor the organizations within Sentry.

Examples

Basic info

Explore which organizations within Sentry have open memberships and require two-factor authentication to understand the security measures in place. This can help in assessing the default role assigned to members for better user management.

select
  id,
  name,
  is_default,
  require_2fa,
  open_membership,
  default_role
from
  sentry_organization;

select
  id,
  name,
  is_default,
  require_2fa,
  open_membership,
  default_role
from
  sentry_organization;

List organizations with 2FA disabled

Discover organizations that have not enabled two-factor authentication, a feature crucial for enhancing security measures and preventing unauthorized access. This query is particularly useful for security audits and compliance checks.

select
  id,
  name,
  is_default,
  require_2fa,
  open_membership,
  default_role
from
  sentry_organization
where
  not require_2fa;

select
  id,
  name,
  is_default,
  require_2fa,
  open_membership,
  default_role
from
  sentry_organization
where
  require_2fa = 0;

List organizations with open membership enabled

Explore which organizations have enabled open membership. This can be useful for assessing the security settings and understanding the access levels within each organization.

select
  id,
  name,
  is_default,
  require_2fa,
  open_membership,
  default_role
from
  sentry_organization
where
  open_membership;

select
  id,
  name,
  is_default,
  require_2fa,
  open_membership,
  default_role
from
  sentry_organization
where
  open_membership = 1;

List organizations with default role admin

Explore which organizations have been set with 'admin' as the default role. This is useful for assessing the security posture of your organizations, as having 'admin' as the default role could potentially open up vulnerabilities.

select
  id,
  name,
  is_default,
  require_2fa,
  open_membership,
  default_role
from
  sentry_organization
where
  default_role = 'admin';

select
  id,
  name,
  is_default,
  require_2fa,
  open_membership,
  default_role
from
  sentry_organization
where
  default_role = 'admin';

List inactive organizations

Explore which organizations are not currently active. This can be useful in identifying areas for potential re-engagement or cleanup.

select
  id,
  name,
  is_default,
  require_2fa,
  open_membership,
  default_role
from
  sentry_organization
where
  status ->> 'id' <> 'active';

select
  id,
  name,
  is_default,
  require_2fa,
  open_membership,
  default_role
from
  sentry_organization
where
  json_extract(status, '$.id') <> 'active';

List access details of a particular organization

Explore the access details of a specific organization to understand the permissions and roles associated with it. This can help in managing user access and ensuring appropriate security measures are in place.

select
  id,
  name,
  jsonb_pretty(access) as access
from
  sentry_organization
where
  slug = 'myorg';

select
  id,
  name,
  access
from
  sentry_organization
where
  slug = 'myorg';

Schema for sentry_organization

Name	Type	Operators	Description
_ctx	jsonb		Steampipe context in JSON form.
access	jsonb		The organization access.
alerts_member_write	boolean		Check if the organization has alerts member write enabled.
allow_join_requests	boolean		Check if the organization has allowed join requests.
allow_shared_issues	boolean		Check if the organization has allowed shared issues.
attachments_role	text		The organization attachments role.
available_roles	jsonb		Represents a Sentry organization's available role.
avatar	jsonb		Represents a Sentry organization's avatar.
data_scrubber	boolean		Check if the organization has data scrubber enabled.
data_scrubber_defaults	boolean		Check if the organization has data scrubber defaults enabled.
date_created	timestamp with time zone		The creation timestamp of the organization.
debug_files_role	text		The organization debug files role.
default_role	text		The default role of the organization.
enhanced_privacy	boolean		Check if the organization has enhanced privacy enabled.
events_member_admin	boolean		Check if the organization has events member admin access.
features	jsonb		The organization features.
id	text		The ID of the organization.
is_default	boolean		Check if the organization is the default.
is_early_adopter	boolean		Check if the organization has early adopter enabled.
name	text		The name of the organization.
open_membership	boolean		Check if the organization has open membership enabled.
pending_access_request	bigint		The number of the pending access requests.
quota	jsonb		Represents a Sentry organization's quota.
relay_pii_config	text		The relay pii config.
require_2fa	boolean		Check if the organization has 2FA enabled.
require_email_verification	boolean		Check if the organization requires email verification.
role	text		The organization role.
safe_fields	jsonb		The organization safe fields.
scrape_java_script	boolean		Check if the organization scrapes java script.
scrub_ip_addresses	boolean		Check if the organization scrubs IP addresses.
sensitive_fields	jsonb		The organization sensitive fields.
slug	text	=	The slug of the organization.
sp_connection_name	text	=, !=, ~~, ~~, !~~, !~~	Steampipe connection name.
sp_ctx	jsonb		Steampipe context in JSON form.
status	jsonb		Represents a Sentry organization's status.
store_crash_reports	text		The store crash reports.
title	text		Title of the resource.

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

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

steampipe_export_sentry --config '<your_config>' sentry_organization