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

Name	Type	Operators	Description
_ctx	jsonb		Steampipe context in JSON form, e.g. connection_name.
html_url	text		An URL at which the entity is uniquely displayed in the Web app.
id	text		An unique identifier of a tag.
label	text	=	The label of the tag.
self	text		The API show URL at which the object is accessible.
summary	text		A 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.
title	text		Title of the resource.
type	text		The 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