db_framework_compliance_summaries
Creates, updates, deletes, gets or lists a db_framework_compliance_summaries resource.
Overview
| Name | db_framework_compliance_summaries |
| Type | Resource |
| Id | google.assuredworkloads.db_framework_compliance_summaries |
Fields
The following fields are returned by SELECT queries:
- list
| Name | Datatype | Description |
|---|---|---|
name | string | Identifier. The name of the framework compliance summary. |
controlAssessmentDetails | object | The control assessment details of the framework. (id: GoogleCloudAssuredworkloadsV1ControlAssessmentDetails) |
controlsPassingTrend | object | Output only. The trend of controls that are passing for the given duration. (id: GoogleCloudAssuredworkloadsV1Trend) |
findingCount | string (int64) | Output only. The count of the findings generated against the framework. |
framework | string | The name of the framework. |
frameworkCategories | array | The list of framework categories supported by the framework. |
frameworkDisplayName | string | Optional. The display name for the framework. |
frameworkType | string | The type of framework. (FRAMEWORK_TYPE_UNSPECIFIED, BUILT_IN, CUSTOM) |
majorRevisionId | string (int64) | The major revision ID of the framework. |
minorRevisionId | string (int64) | The minor revision ID of the framework. |
supportedCloudProviders | array | The list of cloud providers supported by the framework. |
targetResourceDetails | array | The target resource details for the framework. |
Methods
The following methods are available for this resource:
| Name | Accessible by | Required Params | Optional Params | Description |
|---|---|---|---|---|
list | select | projectsId, locationsId | filter, view, pageSize, pageToken | Lists the framework 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 |
|---|---|---|
locationsId | string | |
projectsId | string | |
filter | string | |
pageSize | integer (int32) | |
pageToken | string | |
view | string |
SELECT examples
- list
Lists the framework compliance summary for a given scope.
SELECT
name,
controlAssessmentDetails,
controlsPassingTrend,
findingCount,
framework,
frameworkCategories,
frameworkDisplayName,
frameworkType,
majorRevisionId,
minorRevisionId,
supportedCloudProviders,
targetResourceDetails
FROM google.assuredworkloads.db_framework_compliance_summaries
WHERE projectsId = '{{ projectsId }}' -- required
AND locationsId = '{{ locationsId }}' -- required
AND filter = '{{ filter }}'
AND view = '{{ view }}'
AND pageSize = '{{ pageSize }}'
AND pageToken = '{{ pageToken }}'
;