ct_summary

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

Overview

Name	ct_summary
Type	Resource
Id	cloudflare.radar.ct_summary

Fields

The following fields are returned by SELECT queries:

get

Successful response.

Name	Datatype	Description
meta	object	Metadata for the results.
summary_0	object

Methods

The following methods are available for this resource:

Name	Accessible by	Required Params	Optional Params	Description
get	select	dimension	name, dateRange, dateStart, dateEnd, limitPerGroup, ca, caOwner, duration, entryType, expirationStatus, hasIps, hasWildcards, log, logApi, logOperator, publicKeyAlgorithm, signatureAlgorithm, tld, validationLevel, uniqueEntries, normalization, format	Retrieves an aggregated summary of certificates grouped by the specified dimension.

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.

Name	Datatype	Description
dimension	string	Specifies the certificate attribute by which to group the results.
ca	array	Filters results by certificate authority.
caOwner	array	Filters results by certificate authority owner.
dateEnd	array	End of the date range (inclusive).
dateRange	array	Filters 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).
dateStart	array	Start of the date range.
duration	array	Filters results by certificate duration.
entryType	array	Filters results by entry type (certificate vs. pre-certificate).
expirationStatus	array	Filters results by expiration status (expired vs. valid).
format	string	Format in which results will be returned.
hasIps	array	Filters results based on whether the certificates are bound to specific IP addresses.
hasWildcards	array	Filters results based on whether the certificates contain wildcard domains.
limitPerGroup	integer	Limits 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.
log	array	Filters results by certificate log.
logApi	array	Filters results by certificate log API (RFC6962 vs. static).
logOperator	array	Filters results by certificate log operator.
name	array	Array of names used to label the series in the response.
normalization	string	Normalization method applied to the results. Refer to Normalization methods.
publicKeyAlgorithm	array	Filters results by public key algorithm.
signatureAlgorithm	array	Filters results by signature algorithm.
tld	array	Filters results by top-level domain.
uniqueEntries	array	Specifies whether to filter out duplicate certificates and pre-certificates. Set to true for unique entries only.
validationLevel	array	Filters results by validation level.

SELECT examples

get

Retrieves an aggregated summary of certificates grouped by the specified dimension.

SELECT
meta,
summary_0
FROM cloudflare.radar.ct_summary
WHERE dimension = '{{ dimension }}' -- required
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 tld = '{{ tld }}'
AND validationLevel = '{{ validationLevel }}'
AND uniqueEntries = '{{ uniqueEntries }}'
AND normalization = '{{ normalization }}'
AND format = '{{ format }}'
;