--- title: "POST /v1beta:queryIssues" method: POST path: "/v1beta:queryIssues" tags: ["v1beta"] --- # POST /v1beta:queryIssues `POST /v1beta:queryIssues` QueryIssues provides a list of issues and recommendations that a user has access to and that are within the requested scope. ## Request body - QueryIssuesRequest — QueryIssuesRequest is the request to get a list of issues. - `parent` string — Required. Parent can be a project, a folder, or an organization. The list is limited to the one attached to resources within the `scope` that a user has access to. 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. Following fields are sortable: SignalType Product Location IssueSeverity 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. - `signalProductsFilters` SignalProductsFilters[] — Optional. Filters based on signal and product. The filter list will be ORed across pairs and ANDed within a signal and products pair. - `products` Product[] — Optional. Product type of the resource. The version of the product will be ignored in filtering. - `version` string — Optional. Version of the underlying database engine. Example values: For MySQL, it could be "8.0", "5.7" etc. For Postgres, it could be "14", "15" etc. - `minorVersion` string — Optional. Minor version of the underlying database engine. Example values: For MySQL, it could be "8.0.35", "5.7.25" etc. For PostgreSQL, it could be "14.4", "15.5" etc. - `type` 'PRODUCT_TYPE_UNSPECIFIED' | 'PRODUCT_TYPE_CLOUD_SQL' | 'PRODUCT_TYPE_ALLOYDB' | 'PRODUCT_TYPE_SPANNER' | 'PRODUCT_TYPE_BIGTABLE' | 'PRODUCT_TYPE_MEMORYSTORE' | 'PRODUCT_TYPE_FIRESTORE' | 'PRODUCT_TYPE_COMPUTE_ENGINE' | 'PRODUCT_TYPE_ORACLE_ON_GCP' | 'PRODUCT_TYPE_BIGQUERY' | 'PRODUCT_TYPE_OTHER' — Optional. Type of specific database product. It could be CloudSQL, AlloyDB etc.. - `engine` 'ENGINE_UNSPECIFIED' | 'ENGINE_MYSQL' | 'ENGINE_POSTGRES' | 'ENGINE_SQL_SERVER' | 'ENGINE_NATIVE' | 'ENGINE_MEMORYSTORE_FOR_REDIS' | 'ENGINE_MEMORYSTORE_FOR_REDIS_CLUSTER' | 'ENGINE_MEMORSTORE_FOR_VALKEY' | 'ENGINE_MEMORYSTORE_FOR_VALKEY' | 'ENGINE_FIRESTORE_WITH_NATIVE_MODE' | 'ENGINE_FIRESTORE_WITH_DATASTORE_MODE' | 'ENGINE_EXADATA_ORACLE' | 'ENGINE_ADB_SERVERLESS_ORACLE' | 'ENGINE_FIRESTORE_WITH_MONGODB_COMPATIBILITY_MODE' | 'ENGINE_OTHER' — Optional. The specific engine that the underlying database is running. - `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. The type of signal. - `filter` string — Optional. Supported fields are: 'product', `location`, `issue_severity`, 'tags', 'labels', - `pageSize` integer — Optional. If unspecified, at most 50 issues 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 `QueryIssues` call. Provide this to retrieve the subsequent page. All parameters except page size should match the parameters used in the call that provided the page token. ## 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)