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, selffrom pagerduty_tag;
select id, label, selffrom 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.selffrom pagerduty_tag as t left join distinct_tags as dt on t.id = dt.idwhere 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. | |
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. | |
sp_connection_name | text | =, !=, ~~, ~~*, !~~, !~~* | Steampipe connection name. |
sp_ctx | jsonb | Steampipe context in JSON form. | |
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