Skip to main content

db_finding_summaries

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

Overview

Namedb_finding_summaries
TypeResource
Idgoogle.assuredworkloads.db_finding_summaries

Fields

The following fields are returned by SELECT queries:

NameDatatypeDescription
namestringIdentifier. The name of the finding summary.
findingCategorystringOutput only. The category of the finding.
findingClassstringOutput only. The class of the finding. (FINDING_CLASS_UNSPECIFIED, THREAT, VULNERABILITY, MISCONFIGURATION, OBSERVATION, SCC_ERROR, POSTURE_VIOLATION, TOXIC_COMBINATION, SENSITIVE_DATA_RISK, CHOKEPOINT)
findingCountstring (int64)Output only. The count of the finding.
relatedFrameworksarrayOptional. The list of compliance frameworks that the finding belongs to.
severitystringOutput only. The severity of the finding. (SEVERITY_UNSPECIFIED, CRITICAL, HIGH, MEDIUM, LOW)
updateTimestring (google-datetime)Output only. The last updated time of the finding.

Methods

The following methods are available for this resource:

NameAccessible byRequired ParamsOptional ParamsDescription
listselectprojectsId, locationsIdfilter, pageSize, pageTokenLists the finding summary by category for a given scope.

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
locationsIdstring
projectsIdstring
filterstring
pageSizeinteger (int32)
pageTokenstring

SELECT examples

Lists the finding summary by category for a given scope.

SELECT
name,
findingCategory,
findingClass,
findingCount,
relatedFrameworks,
severity,
updateTime
FROM google.assuredworkloads.db_finding_summaries
WHERE projectsId = '{{ projectsId }}' -- required
AND locationsId = '{{ locationsId }}' -- required
AND filter = '{{ filter }}'
AND pageSize = '{{ pageSize }}'
AND pageToken = '{{ pageToken }}'
;