db_control_compliance_summaries

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

Overview

Name	db_control_compliance_summaries
Type	Resource
Id	google.assuredworkloads.db_control_compliance_summaries

Fields

The following fields are returned by SELECT queries:

list

Name	Datatype	Description
name	string	Identifier. The name of the control compliance summary.
cloudControlReports	array	The list of cloud control reports.
complianceFrameworks	array	The list of compliance frameworks that the control belongs to.
control	string	The name of the control.
controlResponsibilityType	string	The responsibility type for the control. (REGULATORY_CONTROL_RESPONSIBILITY_TYPE_UNSPECIFIED, GOOGLE, CUSTOMER, SHARED)
description	string	The description of the control.
displayName	string	The display name of the control.
isFakeControl	boolean	Whether the control is a fake control. Fake controls are created and mapped to cloud controls that don't belong to a control group.
overallEvaluationState	string	Output only. The overall evaluation status of the control. (EVALUATION_STATE_UNSPECIFIED, EVALUATION_STATE_PASSED, EVALUATION_STATE_FAILED, EVALUATION_STATE_NOT_ASSESSED)
similarControls	array	The list of similar controls.
totalFindingsCount	integer (int32)	The total number of findings for the control.

Methods

The following methods are available for this resource:

Name	Accessible by	Required Params	Optional Params	Description
list	select	projectsId, locationsId, dbFrameworkComplianceReportsId	filter, pageSize, pageToken	Lists the control compliance summary 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
dbFrameworkComplianceReportsId	string
locationsId	string
projectsId	string
filter	string
pageSize	integer (int32)
pageToken	string

SELECT examples

list

Lists the control compliance summary for a given scope.

SELECT
name,
cloudControlReports,
complianceFrameworks,
control,
controlResponsibilityType,
description,
displayName,
isFakeControl,
overallEvaluationState,
similarControls,
totalFindingsCount
FROM google.assuredworkloads.db_control_compliance_summaries
WHERE projectsId = '{{ projectsId }}' -- required
AND locationsId = '{{ locationsId }}' -- required
AND dbFrameworkComplianceReportsId = '{{ dbFrameworkComplianceReportsId }}' -- required
AND filter = '{{ filter }}'
AND pageSize = '{{ pageSize }}'
AND pageToken = '{{ pageToken }}'
;