db_framework_compliance_reports

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

Overview

Name	db_framework_compliance_reports
Type	Resource
Id	google.assuredworkloads.db_framework_compliance_reports

Fields

The following fields are returned by SELECT queries:

fetch

Name	Datatype	Description
name	string	The name of the framework compliance report.
controlAssessmentDetails	object	The control assessment details of the framework. (id: GoogleCloudAssuredworkloadsV1ControlAssessmentDetails)
framework	string	The name of the framework.
frameworkCategories	array	The list of framework categories supported.
frameworkDescription	string	The description of the framework.
frameworkDisplayName	string	Optional. The display name for the framework.
frameworkType	string	The type of the framework. (FRAMEWORK_TYPE_UNSPECIFIED, BUILT_IN, CUSTOM)
majorRevisionId	string (int64)	The latest major revision ID of the framework.
minorRevisionId	string (int64)	The latest minor revision ID of the latest major revision of the framework.
supportedCloudProviders	array	The list of cloud providers that are supported by the framework.
targetResourceDetails	array	The target resource details of the framework.
updateTime	string (google-datetime)	Output only. The last updated time of the report.

Methods

The following methods are available for this resource:

Name	Accessible by	Required Params	Optional Params	Description
fetch	select	projectsId, locationsId, dbFrameworkComplianceReportsId	endTime, filter	Fetches the framework compliance report for a given scope.
aggregate	exec	projectsId, locationsId, dbFrameworkComplianceReportsId	interval.startTime, filter, interval.endTime	Gets the aggregated compliance report over time 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
endTime	string (google-datetime)
filter	string
interval.endTime	string (google-datetime)
interval.startTime	string (google-datetime)

SELECT examples

fetch

Fetches the framework compliance report for a given scope.

SELECT
name,
controlAssessmentDetails,
framework,
frameworkCategories,
frameworkDescription,
frameworkDisplayName,
frameworkType,
majorRevisionId,
minorRevisionId,
supportedCloudProviders,
targetResourceDetails,
updateTime
FROM google.assuredworkloads.db_framework_compliance_reports
WHERE projectsId = '{{ projectsId }}' -- required
AND locationsId = '{{ locationsId }}' -- required
AND dbFrameworkComplianceReportsId = '{{ dbFrameworkComplianceReportsId }}' -- required
AND endTime = '{{ endTime }}'
AND filter = '{{ filter }}'
;

Lifecycle Methods

aggregate

Gets the aggregated compliance report over time for a given scope.

EXEC google.assuredworkloads.db_framework_compliance_reports.aggregate 
@projectsId='{{ projectsId }}' --required, 
@locationsId='{{ locationsId }}' --required, 
@dbFrameworkComplianceReportsId='{{ dbFrameworkComplianceReportsId }}' --required, 
@interval.startTime='{{ interval.startTime }}', 
@filter='{{ filter }}', 
@interval.endTime='{{ interval.endTime }}'
;