Table: pagerduty_vendor - Query PagerDuty Vendors 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. The Vendor resource in PagerDuty represents the third-party services that are integrated with PagerDuty to create, update, and resolve incidents. It includes details such as vendor id, name, summary, and other relevant information.

Table Usage Guide

The pagerduty_vendor table provides insights into third-party services integrated with PagerDuty. As a DevOps engineer, explore vendor-specific details through this table, including vendor id, name, summary, and other relevant information. Utilize it to uncover information about vendors, such as their integration status with PagerDuty, and the services they offer.

Important Notes

It is recommended that queries specify name or id in order to limit results due to the large number of vendors.

Examples

Get AWS CloudWatch integration vendor

Explore the integration between your system and Amazon CloudWatch, a monitoring service for AWS resources and the applications you run on AWS. This query is useful for understanding the integration's details and potential alert configurations, which can aid in system management and troubleshooting.

select
  name,
  id,
  description,
  website_url,
  alert_creation_default
from
  pagerduty_vendor
where
  name = 'Amazon CloudWatch';

select
  name,
  id,
  description,
  website_url,
  alert_creation_default
from
  pagerduty_vendor
where
  name = 'Amazon CloudWatch';

Get count of services using AWS CloudTrail integration

This query helps you determine the number of services integrated with AWS CloudTrail in your PagerDuty account. It's useful for assessing the extent of your CloudTrail usage and ensuring all necessary services are properly connected for optimal incident management.

with cloudtrail_vendor as (
  select
    id as vendor_id,
    name as vendor_name
  from
    pagerduty_vendor
  where
    name = 'AWS CloudTrail'
),
service_integrations as (
  select
    service_id,
    name as integration_name,
    vendor ->> 'id' as vendor_id
  from
    pagerduty_service_integration
  where
    service_id in (
      select
        id
      from
        pagerduty_service
    )
)
select
  cv.vendor_name,
  count(si.service_id) as service_count
from
  cloudtrail_vendor as cv
  left join service_integrations as si on cv.vendor_id = si.vendor_id
group by
  cv.vendor_name,
  si.service_id;

with cloudtrail_vendor as (
  select
    id as vendor_id,
    name as vendor_name
  from
    pagerduty_vendor
  where
    name = 'AWS CloudTrail'
),
service_integrations as (
  select
    service_id,
    name as integration_name,
    json_extract(vendor, '$.id') as vendor_id
  from
    pagerduty_service_integration
  where
    service_id in (
      select
        id
      from
        pagerduty_service
    )
)
select
  cv.vendor_name,
  count(si.service_id) as service_count
from
  cloudtrail_vendor as cv
  left join service_integrations as si on cv.vendor_id = si.vendor_id
group by
  cv.vendor_name,
  si.service_id;

Schema for pagerduty_vendor

Name	Type	Operators	Description
_ctx	jsonb		Steampipe context in JSON form.
alert_creation_default	text		Specifies the default method for the alert creation.
alert_creation_editable	boolean		Indicates whether the default alert creation method can be editable, or not.
description	text		The description of the vendor.
generic_service_type	text		Specifies the generic service type.
html_url	text		The API show URL at which the object is accessible.
id	text	=	An unique identifier of the vendor.
integration_guide_url	text		Specifies the URL of an integration guide for this vendor.
is_pdcef	boolean		Indicates the PagerDuty Common Event Format(PD-CEF).
logo_url	text		Specifies the URL of a logo identifying the vendor.
long_name	text		The full name of the vendor.
name	text	=	The name of the vendor.
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.
thumbnail_url	text		Specifies the URL of a small thumbnail image identifying the vendor.
title	text		Title of the resource.
type	text		The type of object being created.
website_url	text		The description of the vendor.

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_vendor