steampipe plugin install sentry

Table: sentry_project - Query Sentry Projects using SQL

Sentry is an open-source error tracking tool that helps developers monitor and fix crashes in real time. It provides complete visibility into your stack, enabling you to detect and fix issues as soon as they occur. Sentry supports all major languages and frameworks, and integrates with your existing workflow to identify, respond to, and resolve production software issues.

Table Usage Guide

The sentry_project table provides insights into projects within Sentry. As a developer or DevOps engineer, explore project-specific details through this table, including project id, name, platform, slug, and other related information. Utilize it to manage and monitor your projects, understand their configuration, and quickly identify and resolve issues.

Examples

Basic info

Discover the segments that have access and are public within a certain platform. This is useful in assessing the status and understanding the accessibility of projects within a given platform.

select
id,
name,
status,
slug,
has_access,
is_public,
platform
from
sentry_project;
select
id,
name,
status,
slug,
has_access,
is_public,
platform
from
sentry_project;

List public projects

Explore which projects are publicly accessible, enabling you to identify potential security risks or areas for collaboration.

select
id,
name,
status,
slug,
has_access,
is_public,
platform
from
sentry_project
where
is_public;
select
id,
name,
status,
slug,
has_access,
is_public,
platform
from
sentry_project
where
is_public = 1;

List go based projects

Explore which projects are based on the 'Go' programming language. This is useful to identify and manage projects that are using this specific platform.

select
id,
name,
status,
slug,
has_access,
is_public,
platform
from
sentry_project
where
platform = 'go';
select
id,
name,
status,
slug,
has_access,
is_public,
platform
from
sentry_project
where
platform = 'go';

List projects of a particular organization

Determine the areas in which a specific organization has projects. This can be useful to gain insights into the project status, access details, and platform usage within the organization.

select
id,
name,
status,
slug,
has_access,
is_public,
platform
from
sentry_project
where
organization_slug = 'myorg';
select
id,
name,
status,
slug,
has_access,
is_public,
platform
from
sentry_project
where
organization_slug = 'myorg';

List internal projects

Discover the segments that are classified as internal projects within your organizational structure. This allows you to assess the elements within your organization that are not public-facing, aiding in strategic planning and resource allocation.

select
id,
name,
status,
slug,
has_access,
is_public,
platform
from
sentry_project
where
is_internal;
select
id,
name,
status,
slug,
has_access,
is_public,
platform
from
sentry_project
where
is_internal = 1;

List teams of a particular project

Determine the teams associated with a specific project to understand their roles and contributions. This is useful for project management and resource allocation.

select
id,
name,
t ->> 'id' as team_id,
t ->> 'name' as team_name,
t ->> 'slug' as team_slug
from
sentry_project,
jsonb_array_elements(teams) as t
where
slug = 'myproj';
select
id,
name,
json_extract(t.value, '$.id') as team_id,
json_extract(t.value, '$.name') as team_name,
json_extract(t.value, '$.slug') as team_slug
from
sentry_project,
json_each(teams) as t
where
slug = 'myproj';

Schema for sentry_project

NameTypeOperatorsDescription
_ctxjsonbSteampipe context in JSON form, e.g. connection_name.
allowed_domainsjsonbThe allowed domains of the project.
avatarjsonbRepresents an avatar.
colortextThe project color.
data_scrubbertextThe project data scrubber.
data_scrubber_defaultstextThe project default data scrubber.
date_createdtimestamp with time zoneThe creation timestamp of the project.
digest_max_delaybigintThe maximum amount of time (in seconds) to wait between scheduling digests for delivery.
digest_min_delaybigintThe minimum amount of time (in seconds) to wait between scheduling digests for delivery after the initial scheduling.
featuresjsonbThe features of the project.
filtersjsonbThe project filters.
fingerprinting_rulestextThe fingerprinting rules of the project.
first_eventtimestamp with time zoneThe first event timestamp.
grouping_enhancementstextThe grouping enhancements of the project.
has_accessbooleanCheck if the project has access.
idtextThe ID of the project.
is_bookmarkedbooleanCheck if the project is bookmarked.
is_internalbooleanCheck if the project is internal.
is_memberbooleanCheck if the project is member.
is_publicbooleanCheck if the project is public.
nametextThe name of the project.
optionsjsonbThe project options.
organizationjsonbThe organization to which the project belongs to.
organization_slugtext=The slug of the organization the project belongs to.
platformtextThe optional platform for this project.
processing_issuesbigintThe number of processing issues of the project.
resolve_agebigintHours in which an issue is automatically resolve if not seen after this amount of time.
safe_fieldsjsonbThe project safe fields.
scrape_java_scriptbooleanCheck if the project has scrape java script enabled.
scrub_ip_addressesbooleanCheck if the project has scrub IP addresses enabled.
security_tokentextThe security token of the project.
security_token_headertextThe security token header of the project.
sensitive_fieldsjsonbThe project sensitive fields.
slugtext=The slug of the project.
statustextThe status of the project.
subject_prefixtextThe subject prefix of the project.
subject_templatetextThe subject template of the project.
teamsjsonbThe project teams.
titletextTitle of the resource.
verify_sslbooleanCheck if the project is verified with SSL.

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_project