turbot/pagerduty
steampipe plugin install pagerduty

Table: pagerduty_tag - Query PagerDuty Tags using SQL

PagerDuty is an incident management platform that provides reliable notifications, automatic escalations, on-call scheduling, and other functionality to help teams detect and fix infrastructure problems quickly. Its Tags feature allows users to categorize and filter incidents, services, and teams using custom labels. This aids in organizing resources, prioritizing incidents, and streamlining workflows.

Table Usage Guide

The pagerduty_tag table provides insights into Tags within PagerDuty's incident management platform. As an operations engineer, explore tag-specific details through this table, including associated services, teams, and incidents. Utilize it to uncover information about tags, such as those most frequently used, their associated resources, and the effectiveness of your tagging strategy.

Examples

Basic info

Explore which PagerDuty tags are being used. This can help in managing and organizing your PagerDuty services and incidents more effectively.

select
id,
label,
self
from
pagerduty_tag;
select
id,
label,
self
from
pagerduty_tag;

List unused tags

Identify the tags that are currently not associated with any users, teams, or escalation policies in PagerDuty. This can help streamline your tagging system by removing or reassigning unused tags.

with associated_tags as (
select
t ->> 'id' as id
from
pagerduty_user,
jsonb_array_elements(tags) as t
union
select
t ->> 'id' as id
from
pagerduty_team,
jsonb_array_elements(tags) as t
union
select
t ->> 'id' as id
from
pagerduty_escalation_policy,
jsonb_array_elements(tags) as t
),
distinct_tags as (
select
distinct id
from
associated_tags
)
select
t.id,
t.label,
t.self
from
pagerduty_tag as t
left join distinct_tags as dt on t.id = dt.id
where
dt.id is null;
Error: The corresponding SQLite query is unavailable.

Schema for pagerduty_tag

NameTypeOperatorsDescription
_ctxjsonbSteampipe context in JSON form.
html_urltextAn URL at which the entity is uniquely displayed in the Web app.
idtextAn unique identifier of a tag.
labeltext=The label of the tag.
selftextThe API show URL at which the object is accessible.
sp_connection_nametext=, !=, ~~, ~~*, !~~, !~~*Steampipe connection name.
sp_ctxjsonbSteampipe context in JSON form.
summarytextA short-form, server-generated string that provides succinct, important information about an object suitable for primary labeling of an entity in a client. In many cases, this will be identical to name, though it is not intended to be an identifier.
titletextTitle of the resource.
typetextThe type of object being created.

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

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

steampipe_export_pagerduty --config '<your_config>' pagerduty_tag