--- title: "POST /v1beta:queryDatabaseResourceGroups" method: POST path: "/v1beta:queryDatabaseResourceGroups" tags: ["v1beta"] --- # POST /v1beta:queryDatabaseResourceGroups `POST /v1beta:queryDatabaseResourceGroups` QueryDatabaseResourceGroups returns paginated results of database groups. ## Request body - QueryDatabaseResourceGroupsRequest — QueryDatabaseResourceGroupsRequest is the request to get a list of database groups. - `filter` string — Optional. The expression to filter resources. The following fields are filterable: * full_resource_name * resource_type * container * product.type * product.engine * product.version * location * labels * resource_category * machine_config.cpu_count * machine_config.memory_size_bytes * machine_config.shard_count * resource_name * tags * backupdr_config.backupdr_managed * edition The expression is a list of zero or more restrictions combined via logical operators `AND` and `OR`. When `AND` and `OR` are both used in the expression, parentheses must be appropriately used to group the combinations. Example: `location="us-east1"` Example: `container="projects/123" OR container="projects/456"` Example: `(container="projects/123" OR container="projects/456") AND location="us-east1"` Example: `full_resource_name=~"test"` Example: `full_resource_name=~"test.*master"` - `pageSize` integer — Optional. If unspecified, at most 50 resource groups will be returned. The maximum value is 1000; values above 1000 will be coerced to 1000. - `pageToken` string — Optional. A page token, received from a previous `QueryDatabaseResourceGroupsRequest` call. Provide this to retrieve the subsequent page. All parameters except page_token should match the parameters in the call that provided the page page token. - `signalTypeGroups` SignalTypeGroup[] — Optional. Groups of signal types that are requested. - `signalTypes` string[] — Optional. List of signal types present in the group. - `displayName` string — Required. The display name of a signal group. - `signalFilters` SignalFilter[] — Optional. Filters based on signals. The list will be ORed together and then ANDed with the `filters` field above. - `signalStatus` 'SIGNAL_STATUS_UNSPECIFIED' | 'SIGNAL_STATUS_NOT_APPLICABLE' | 'SIGNAL_STATUS_OK' | 'SIGNAL_STATUS_ISSUE' | 'SIGNAL_STATUS_NOT_ENABLED' — Optional. Represents the status of the Signal for which the filter is for. - `signalType` 'SIGNAL_TYPE_UNSPECIFIED' | 'SIGNAL_TYPE_RESOURCE_FAILOVER_PROTECTED' | 'SIGNAL_TYPE_GROUP_MULTIREGIONAL' | 'SIGNAL_TYPE_NO_AUTOMATED_BACKUP_POLICY' | 'SIGNAL_TYPE_SHORT_BACKUP_RETENTION' | 'SIGNAL_TYPE_LAST_BACKUP_FAILED' | 'SIGNAL_TYPE_LAST_BACKUP_OLD' | 'SIGNAL_TYPE_VIOLATES_CIS_GCP_FOUNDATION_2_0' | 'SIGNAL_TYPE_VIOLATES_CIS_GCP_FOUNDATION_1_3' | 'SIGNAL_TYPE_VIOLATES_CIS_GCP_FOUNDATION_1_2' | 'SIGNAL_TYPE_VIOLATES_CIS_GCP_FOUNDATION_1_1' | 'SIGNAL_TYPE_VIOLATES_CIS_GCP_FOUNDATION_1_0' | 'SIGNAL_TYPE_VIOLATES_CIS_CONTROLS_V8_0' | 'SIGNAL_TYPE_VIOLATES_NIST_800_53' | 'SIGNAL_TYPE_VIOLATES_NIST_800_53_R5' | 'SIGNAL_TYPE_VIOLATES_NIST_CYBERSECURITY_FRAMEWORK_V1_0' | 'SIGNAL_TYPE_VIOLATES_ISO_27001' | 'SIGNAL_TYPE_VIOLATES_ISO_27001_V2022' | 'SIGNAL_TYPE_VIOLATES_PCI_DSS_V3_2_1' | 'SIGNAL_TYPE_VIOLATES_PCI_DSS_V4_0' | 'SIGNAL_TYPE_VIOLATES_CLOUD_CONTROLS_MATRIX_V4' | 'SIGNAL_TYPE_VIOLATES_HIPAA' | 'SIGNAL_TYPE_VIOLATES_SOC2_V2017' | 'SIGNAL_TYPE_LOGS_NOT_OPTIMIZED_FOR_TROUBLESHOOTING' | 'SIGNAL_TYPE_QUERY_DURATIONS_NOT_LOGGED' | 'SIGNAL_TYPE_VERBOSE_ERROR_LOGGING' | 'SIGNAL_TYPE_QUERY_LOCK_WAITS_NOT_LOGGED' | 'SIGNAL_TYPE_LOGGING_MOST_ERRORS' | 'SIGNAL_TYPE_LOGGING_ONLY_CRITICAL_ERRORS' | 'SIGNAL_TYPE_MINIMAL_ERROR_LOGGING' | 'SIGNAL_TYPE_QUERY_STATS_LOGGED' | 'SIGNAL_TYPE_EXCESSIVE_LOGGING_OF_CLIENT_HOSTNAME' | 'SIGNAL_TYPE_EXCESSIVE_LOGGING_OF_PARSER_STATS' | 'SIGNAL_TYPE_EXCESSIVE_LOGGING_OF_PLANNER_STATS' | 'SIGNAL_TYPE_NOT_LOGGING_ONLY_DDL_STATEMENTS' | 'SIGNAL_TYPE_LOGGING_QUERY_STATS' | 'SIGNAL_TYPE_NOT_LOGGING_TEMPORARY_FILES' | 'SIGNAL_TYPE_CONNECTION_MAX_NOT_CONFIGURED' | 'SIGNAL_TYPE_USER_OPTIONS_CONFIGURED' | 'SIGNAL_TYPE_EXPOSED_TO_PUBLIC_ACCESS' | 'SIGNAL_TYPE_UNENCRYPTED_CONNECTIONS' | 'SIGNAL_TYPE_NO_ROOT_PASSWORD' | 'SIGNAL_TYPE_WEAK_ROOT_PASSWORD' | 'SIGNAL_TYPE_ENCRYPTION_KEY_NOT_CUSTOMER_MANAGED' | 'SIGNAL_TYPE_SERVER_AUTHENTICATION_NOT_REQUIRED' | 'SIGNAL_TYPE_EXPOSED_TO_EXTERNAL_SCRIPTS' | 'SIGNAL_TYPE_EXPOSED_TO_LOCAL_DATA_LOADS' | 'SIGNAL_TYPE_CONNECTION_ATTEMPTS_NOT_LOGGED' | 'SIGNAL_TYPE_DISCONNECTIONS_NOT_LOGGED' | 'SIGNAL_TYPE_LOGGING_EXCESSIVE_STATEMENT_INFO' | 'SIGNAL_TYPE_EXPOSED_TO_REMOTE_ACCESS' | 'SIGNAL_TYPE_DATABASE_NAMES_EXPOSED' | 'SIGNAL_TYPE_SENSITIVE_TRACE_INFO_NOT_MASKED' | 'SIGNAL_TYPE_PUBLIC_IP_ENABLED' | 'SIGNAL_TYPE_IDLE' | 'SIGNAL_TYPE_OVERPROVISIONED' | 'SIGNAL_TYPE_HIGH_NUMBER_OF_OPEN_TABLES' | 'SIGNAL_TYPE_HIGH_NUMBER_OF_TABLES' | 'SIGNAL_TYPE_HIGH_TRANSACTION_ID_UTILIZATION' | 'SIGNAL_TYPE_UNDERPROVISIONED' | 'SIGNAL_TYPE_OUT_OF_DISK' | 'SIGNAL_TYPE_SERVER_CERTIFICATE_NEAR_EXPIRY' | 'SIGNAL_TYPE_DATABASE_AUDITING_DISABLED' | 'SIGNAL_TYPE_RESTRICT_AUTHORIZED_NETWORKS' | 'SIGNAL_TYPE_VIOLATE_POLICY_RESTRICT_PUBLIC_IP' | 'SIGNAL_TYPE_QUOTA_LIMIT' | 'SIGNAL_TYPE_NO_PASSWORD_POLICY' | 'SIGNAL_TYPE_CONNECTIONS_PERFORMANCE_IMPACT' | 'SIGNAL_TYPE_TMP_TABLES_PERFORMANCE_IMPACT' | 'SIGNAL_TYPE_TRANS_LOGS_PERFORMANCE_IMPACT' | 'SIGNAL_TYPE_HIGH_JOINS_WITHOUT_INDEXES' | 'SIGNAL_TYPE_SUPERUSER_WRITING_TO_USER_TABLES' | 'SIGNAL_TYPE_USER_GRANTED_ALL_PERMISSIONS' | 'SIGNAL_TYPE_DATA_EXPORT_TO_EXTERNAL_CLOUD_STORAGE_BUCKET' | 'SIGNAL_TYPE_DATA_EXPORT_TO_PUBLIC_CLOUD_STORAGE_BUCKET' | 'SIGNAL_TYPE_WEAK_PASSWORD_HASH_ALGORITHM' | 'SIGNAL_TYPE_NO_USER_PASSWORD_POLICY' | 'SIGNAL_TYPE_HOT_NODE' | 'SIGNAL_TYPE_NO_DELETION_PROTECTION' | 'SIGNAL_TYPE_NO_POINT_IN_TIME_RECOVERY' | 'SIGNAL_TYPE_RESOURCE_SUSPENDED' | 'SIGNAL_TYPE_EXPENSIVE_COMMANDS' | 'SIGNAL_TYPE_NO_MAINTENANCE_POLICY_CONFIGURED' | 'SIGNAL_TYPE_INEFFICIENT_QUERY' | 'SIGNAL_TYPE_READ_INTENSIVE_WORKLOAD' | 'SIGNAL_TYPE_MEMORY_LIMIT' | 'SIGNAL_TYPE_MAX_SERVER_MEMORY' | 'SIGNAL_TYPE_LARGE_ROWS' | 'SIGNAL_TYPE_HIGH_WRITE_PRESSURE' | 'SIGNAL_TYPE_HIGH_READ_PRESSURE' | 'SIGNAL_TYPE_ENCRYPTION_ORG_POLICY_NOT_SATISFIED' | 'SIGNAL_TYPE_LOCATION_ORG_POLICY_NOT_SATISFIED' | 'SIGNAL_TYPE_OUTDATED_MINOR_VERSION' | 'SIGNAL_TYPE_SCHEMA_NOT_OPTIMIZED' | 'SIGNAL_TYPE_REPLICATION_LAG' | 'SIGNAL_TYPE_OUTDATED_CLIENT' | 'SIGNAL_TYPE_DATABOOST_DISABLED' | 'SIGNAL_TYPE_RECOMMENDED_MAINTENANCE_POLICIES' | 'SIGNAL_TYPE_EXTENDED_SUPPORT' | 'SIGNAL_TYPE_VERSION_NEARING_END_OF_LIFE' | 'SIGNAL_TYPE_HIGH_MAINTENANCE_DOWNTIME_RISK' | 'SIGNAL_TYPE_LOW_CACHE_HIT_AND_MAINTENANCE_DOWNTIME' | 'SIGNAL_TYPE_MISSING_ENHANCED_PROTECTION' — Optional. Represents the type of the Signal for which the filter is for. - `parent` string — Required. Parent can be a project, a folder, or an organization. The search is limited to the resources within the `scope`. The allowed values are: * projects/{PROJECT_ID} (e.g., "projects/foo-bar") * projects/{PROJECT_NUMBER} (e.g., "projects/12345678") * folders/{FOLDER_NUMBER} (e.g., "folders/1234567") * organizations/{ORGANIZATION_NUMBER} (e.g., "organizations/123456") - `orderBy` string — Optional. A field that specifies the sort order of the results. The following fields are sortable: * full_resource_name * product.type * product.engine * product.version * container * issue_count * machine_config.vcpu_count * machine_config.memory_size_bytes * machine_config.shard_count * resource_name * issue_severity * signal_type * location * resource_type * instance_type * edition * metrics.p99_cpu_utilization * metrics.p95_cpu_utilization * metrics.current_storage_used_bytes * metrics.node_count * metrics.processing_unit_count * metrics.current_memory_used_bytes * metrics.peak_storage_utilization * metrics.peak_number_connections * metrics.peak_memory_utilization The default order is ascending. Add "DESC" after the field name to indicate descending order. Add "ASC" after the field name to indicate ascending order. It only supports a single field at a time. For example: `order_by = "full_resource_name"` sorts response in ascending order `order_by = "full_resource_name DESC"` sorts response in descending order `order_by = "issue_count DESC"` sorts response in descending order of count of all issues associated with a resource. More explicitly, `order_by = "full_resource_name, product"` is not supported. ## Response `200` Successful response --- [API](https://skmtc.dev/google/apis/databasecenter.md) · [All operations](https://skmtc.dev/google/apis/databasecenter/llms.txt) · [OpenAPI document](https://skmtc-service-production.skmtc.workers.dev/v1/apis/google/databasecenter/revisions/c8a8fc88f9cf/schema)