Hi there! Are you looking for the official Deno documentation? Try docs.deno.com for all your Deno learning needs.

IssueStats

import type { IssueStats } from "https://googleapis.deno.dev/v1/databasecenter:v1beta.ts";

IssueStats holds stats for a particular signal category.

interface IssueStats {
deltaDetails?: DeltaDetails;
issueSeverity?:
| "ISSUE_SEVERITY_UNSPECIFIED"
| "ISSUE_SEVERITY_LOW"
| "ISSUE_SEVERITY_MEDIUM"
| "ISSUE_SEVERITY_HIGH"
| "ISSUE_SEVERITY_CRITICAL"
| "ISSUE_SEVERITY_IRRELEVANT";
resourceCount?: number;
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";
}

§Properties

§
deltaDetails?: DeltaDetails
[src]

Optional. Delta counts and details of resources for which issue was raised or fixed.

§
issueSeverity?: "ISSUE_SEVERITY_UNSPECIFIED" | "ISSUE_SEVERITY_LOW" | "ISSUE_SEVERITY_MEDIUM" | "ISSUE_SEVERITY_HIGH" | "ISSUE_SEVERITY_CRITICAL" | "ISSUE_SEVERITY_IRRELEVANT"
[src]

Severity of the issue.

§
resourceCount?: number
[src]

Number of resources having issues of a given type.

§
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"
[src]

Type of signal which is an issue.