Skip to main content

ct

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

Overview

Namect
TypeResource
Idcloudflare.radar.ct

Fields

The following fields are returned by SELECT queries:

Successful response.

NameDatatypeDescription
metaobjectMetadata for the results.

Methods

The following methods are available for this resource:

NameAccessible byRequired ParamsOptional ParamsDescription
listselectaggInterval, name, dateRange, dateStart, dateEnd, ca, caOwner, duration, entryType, expirationStatus, hasIps, hasWildcards, log, logApi, logOperator, publicKeyAlgorithm, signatureAlgorithm, tld, validationLevel, uniqueEntries, formatRetrieves certificate volume 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
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.
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.
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 certificate volume over time.

SELECT
meta
FROM cloudflare.radar.ct
WHERE aggInterval = '{{ aggInterval }}'
AND name = '{{ name }}'
AND dateRange = '{{ dateRange }}'
AND dateStart = '{{ dateStart }}'
AND dateEnd = '{{ dateEnd }}'
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 tld = '{{ tld }}'
AND validationLevel = '{{ validationLevel }}'
AND uniqueEntries = '{{ uniqueEntries }}'
AND format = '{{ format }}'
;