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, versionfrom fastly_ip_range;
select cidr, versionfrom 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, versionfrom fastly_ip_rangewhere 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, versionfrom fastly_ip_rangewhere version = 6;
select cidr, versionfrom fastly_ip_rangewhere 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