Skip to main content

netflows_top_locations

Creates, updates, deletes, gets or lists a netflows_top_locations resource.

Overview

Namenetflows_top_locations
TypeResource
Idcloudflare.radar.netflows_top_locations

Fields

The following fields are returned by SELECT queries:

Successful response.

NameDatatypeDescription
metaobjectMetadata for the results.
top_0array

Methods

The following methods are available for this resource:

NameAccessible byRequired ParamsOptional ParamsDescription
listselectlimit, name, dateRange, dateStart, dateEnd, asn, location, continent, geoId, formatRetrieves the top locations by network traffic (NetFlows).

Parameters

Parameters can be passed in the WHERE clause of a query. Check the Methods section to see which parameters are required or optional for each operation.

NameDatatypeDescription
asnarrayFilters results by Autonomous System. Specify one or more Autonomous System Numbers (ASNs) as a comma-separated list. Prefix with - to exclude ASNs from results. For example, -174, 3356 excludes results from AS174, but includes results from AS3356.
continentarrayFilters results by continent. Specify a comma-separated list of alpha-2 codes. Prefix with - to exclude continents from results. For example, -EU,NA excludes results from EU, but includes results from NA.
dateEndarrayEnd of the date range (inclusive).
dateRangearrayFilters results by date range. For example, use 7d and 7dcontrol to compare this week with the previous week. Use this parameter or set specific start and end dates (dateStart and dateEnd parameters).
dateStartarrayStart of the date range.
formatstringFormat in which results will be returned.
geoIdarrayFilters results by Geolocation. Specify a comma-separated list of GeoNames IDs. Prefix with - to exclude geoIds from results. For example, -2267056,360689 excludes results from the 2267056 (Lisbon), but includes results from 5128638 (New York).
limitintegerLimits the number of objects returned in the response.
locationarrayFilters results by location. Specify a comma-separated list of alpha-2 codes. Prefix with - to exclude locations from results. For example, -US,PT excludes results from the US, but includes results from PT.
namearrayArray of names used to label the series in the response.

SELECT examples

Retrieves the top locations by network traffic (NetFlows).

SELECT
meta,
top_0
FROM cloudflare.radar.netflows_top_locations
WHERE limit = '{{ limit }}'
AND name = '{{ name }}'
AND dateRange = '{{ dateRange }}'
AND dateStart = '{{ dateStart }}'
AND dateEnd = '{{ dateEnd }}'
AND asn = '{{ asn }}'
AND location = '{{ location }}'
AND continent = '{{ continent }}'
AND geoId = '{{ geoId }}'
AND format = '{{ format }}'
;