Skip to main content

ct_timeseries_groups

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

Overview

Namect_timeseries_groups
TypeResource
Idcloudflare.radar.ct_timeseries_groups

Fields

The following fields are returned by SELECT queries:

Successful response.

NameDatatypeDescription
metaobjectMetadata for the results.
serie_0object

Methods

The following methods are available for this resource:

NameAccessible byRequired ParamsOptional ParamsDescription
getselectdimensionaggInterval, name, dateRange, dateStart, dateEnd, limitPerGroup, ca, caOwner, duration, entryType, expirationStatus, hasIps, hasWildcards, log, logApi, logOperator, publicKeyAlgorithm, signatureAlgorithm, validationLevel, tld, normalization, uniqueEntries, formatRetrieves the distribution of certificates grouped by the specified dimension over time.

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
dimensionstringSpecifies the certificate attribute by which to group the results.
aggIntervalstringAggregation interval of the results (e.g., in 15 minutes or 1 hour intervals). Refer to Aggregation intervals.
caarrayFilters results by certificate authority.
caOwnerarrayFilters results by certificate authority owner.
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.
durationarrayFilters results by certificate duration.
entryTypearrayFilters results by entry type (certificate vs. pre-certificate).
expirationStatusarrayFilters results by expiration status (expired vs. valid).
formatstringFormat in which results will be returned.
hasIpsarrayFilters results based on whether the certificates are bound to specific IP addresses.
hasWildcardsarrayFilters results based on whether the certificates contain wildcard domains.
limitPerGroupintegerLimits the number of objects per group to the top items within the specified time range. When item count exceeds the limit, extra items appear grouped under an "other" category.
logarrayFilters results by certificate log.
logApiarrayFilters results by certificate log API (RFC6962 vs. static).
logOperatorarrayFilters results by certificate log operator.
namearrayArray of names used to label the series in the response.
normalizationstringNormalization method applied to the results. Refer to Normalization methods.
publicKeyAlgorithmarrayFilters results by public key algorithm.
signatureAlgorithmarrayFilters results by signature algorithm.
tldarrayFilters results by top-level domain.
uniqueEntriesarraySpecifies whether to filter out duplicate certificates and pre-certificates. Set to true for unique entries only.
validationLevelarrayFilters results by validation level.

SELECT examples

Retrieves the distribution of certificates grouped by the specified dimension over time.

SELECT
meta,
serie_0
FROM cloudflare.radar.ct_timeseries_groups
WHERE dimension = '{{ dimension }}' -- required
AND aggInterval = '{{ aggInterval }}'
AND name = '{{ name }}'
AND dateRange = '{{ dateRange }}'
AND dateStart = '{{ dateStart }}'
AND dateEnd = '{{ dateEnd }}'
AND limitPerGroup = '{{ limitPerGroup }}'
AND ca = '{{ ca }}'
AND caOwner = '{{ caOwner }}'
AND duration = '{{ duration }}'
AND entryType = '{{ entryType }}'
AND expirationStatus = '{{ expirationStatus }}'
AND hasIps = '{{ hasIps }}'
AND hasWildcards = '{{ hasWildcards }}'
AND log = '{{ log }}'
AND logApi = '{{ logApi }}'
AND logOperator = '{{ logOperator }}'
AND publicKeyAlgorithm = '{{ publicKeyAlgorithm }}'
AND signatureAlgorithm = '{{ signatureAlgorithm }}'
AND validationLevel = '{{ validationLevel }}'
AND tld = '{{ tld }}'
AND normalization = '{{ normalization }}'
AND uniqueEntries = '{{ uniqueEntries }}'
AND format = '{{ format }}'
;