db_finding_summaries

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

Overview

Name	db_finding_summaries
Type	Resource
Id	google.assuredworkloads.db_finding_summaries

Fields

The following fields are returned by SELECT queries:

list

Name	Datatype	Description
name	string	Identifier. The name of the finding summary.
findingCategory	string	Output only. The category of the finding.
findingClass	string	Output only. The class of the finding. (FINDING_CLASS_UNSPECIFIED, THREAT, VULNERABILITY, MISCONFIGURATION, OBSERVATION, SCC_ERROR, POSTURE_VIOLATION, TOXIC_COMBINATION, SENSITIVE_DATA_RISK, CHOKEPOINT)
findingCount	string (int64)	Output only. The count of the finding.
organizationPolicyFindingCount	string (int64)	Output only. Number of active organization policy findings for this category.
relatedFrameworks	array	Optional. The list of compliance frameworks that the finding belongs to.
resourceFindingCount	string (int64)	Output only. Number of active resource findings for this category.
severity	string	Output only. The severity of the finding. (SEVERITY_UNSPECIFIED, CRITICAL, HIGH, MEDIUM, LOW)
updateTime	string (google-datetime)	Output only. The last updated time of the finding.

Methods

The following methods are available for this resource:

Name	Accessible by	Required Params	Optional Params	Description
list	select	foldersId, locationsId	filter, pageSize, pageToken	Lists 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.

Name	Datatype	Description
foldersId	string
locationsId	string
filter	string
pageSize	integer (int32)
pageToken	string

SELECT examples

list

Lists the finding summary by category for a given scope.

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