Table: fastly_ip_range - Query Fastly IP Ranges using SQL

Fastly is a cloud computing services provider that offers a content delivery network, edge computing, cloud security, and streaming and video delivery services. Fastly's IP ranges are used by their content delivery network to serve content to end users. These IP ranges are critical in understanding the network configuration and ensuring optimal content delivery.

Table Usage Guide

The fastly_ip_range table provides insights into the IP ranges used by Fastly's content delivery network. As a network engineer, explore the start and end of each IP range through this table, which can help in understanding the network configuration and optimizing content delivery. Utilize it to uncover information about the network, such as the allocation of IP ranges and the reach of the content delivery network.

Examples

Basic info

Explore which IP ranges are being used and their corresponding versions in your Fastly network. This can help optimize network performance and security by ensuring you're using the most up-to-date IP versions.

select
  cidr,
  version
from
  fastly_ip_range;

select
  cidr,
  version
from
  fastly_ip_range;

List IP ranges within a particular CIDR range

Explore which IP ranges fall within a specific CIDR range to better manage and monitor network traffic and security. This is particularly useful in identifying potential network vulnerabilities and planning for network expansion.

select
  cidr,
  version
from
  fastly_ip_range
where
  cidr << '199.0.0.0/8';

Error: SQLite does not support CIDR operations.

Show IPv6 ranges

Explore the segments of your network that are using IPv6. This can help identify areas for potential upgrades or troubleshooting.

select
  cidr,
  version
from
  fastly_ip_range
where
  version = 6;

select
  cidr,
  version
from
  fastly_ip_range
where
  version = 6;

Schema for fastly_ip_range

Name	Type	Operators	Description
_ctx	jsonb		Steampipe context in JSON form.
cidr	cidr		IP range.
service_id	text	=, !=, ~~, ~~, !~~, !~~	Alphanumeric string identifying the service.
sp_connection_name	text	=, !=, ~~, ~~, !~~, !~~	Steampipe connection name.
sp_ctx	jsonb		Steampipe context in JSON form.
version	bigint		IP version for the range.

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

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

steampipe_export_fastly --config '<your_config>' fastly_ip_range