Policy: GCP > SQL > Instance > ServiceNow > Table > Definition

The policy enables the definition of ServiceNow table properties, including its name and the base table from which it extends, and details the specific columns required for representing GCP > SQL > Instance data.

Targets

This policy targets the following resource types:

ServiceNow > Instance

Primary Policy

This policy is used with the following primary policy:

GCP > SQL > Instance > ServiceNow > Table

Controls

Setting this policy configures this control:

GCP > SQL > Instance > ServiceNow > Table

Policy Specification

Schema Type	`object`
Default	table: name: guardrails_gcp_sql_instance label: GCP > SQL > Instance extendsTable: cmdb_ci columns: - name: availability_type label: Availability Type - name: backup_enabled label: Backup Enabled type: boolean - name: backup_start_time label: Backup Start Time - name: current_disk_size label: Current Disk Size - name: data_disk_size_gb label: Data Disk Size GB - name: database_version label: Database Version - name: enable_point_in_time_recovery label: Enable Point In Time Recovery type: boolean - name: gce_zone label: Gce Zone - name: instance_name label: Instance Name - name: instance_type label: Instance Type - name: ip_addresses label: IP Addresses type: string size: 1000 - name: ip_configuration label: IP Configuration type: string size: 1000 - name: ipv6_address label: IPv6 Address - name: kms_key_name label: KMS Key Name - name: labels label: Labels type: string size: 1000 - name: machine_type label: Machine Type - name: maintenance_window label: Maintenance Window type: string size: 1000 - name: max_disk_size label: Max Disk Size - name: project label: Project ID type: string - name: region label: Region Name type: string - name: service_account_email_address label: Service Account Email Address - name: ssl_configuration label: SSL Configuration type: string size: 1000 - name: state label: State - name: storage_auto_resize label: Storage Auto Resize type: boolean - name: tags label: Tags type: string size: 1000

Schema Type

object

Default

table:
  name: guardrails_gcp_sql_instance
  label: GCP > SQL > Instance
  extendsTable: cmdb_ci
columns:
  - name: availability_type
    label: Availability Type
  - name: backup_enabled
    label: Backup Enabled
    type: boolean
  - name: backup_start_time
    label: Backup Start Time
  - name: current_disk_size
    label: Current Disk Size
  - name: data_disk_size_gb
    label: Data Disk Size GB
  - name: database_version
    label: Database Version
  - name: enable_point_in_time_recovery
    label: Enable Point In Time Recovery
    type: boolean
  - name: gce_zone
    label: Gce Zone
  - name: instance_name
    label: Instance Name
  - name: instance_type
    label: Instance Type
  - name: ip_addresses
    label: IP Addresses
    type: string
    size: 1000
  - name: ip_configuration
    label: IP Configuration
    type: string
    size: 1000
  - name: ipv6_address
    label: IPv6 Address
  - name: kms_key_name
    label: KMS Key Name
  - name: labels
    label: Labels
    type: string
    size: 1000
  - name: machine_type
    label: Machine Type
  - name: maintenance_window
    label: Maintenance Window
    type: string
    size: 1000
  - name: max_disk_size
    label: Max Disk Size
  - name: project
    label: Project ID
    type: string
  - name: region
    label: Region Name
    type: string
  - name: service_account_email_address
    label: Service Account Email Address
  - name: ssl_configuration
    label: SSL Configuration
    type: string
    size: 1000
  - name: state
    label: State
  - name: storage_auto_resize
    label: Storage Auto Resize
    type: boolean
  - name: tags
    label: Tags
    type: string
    size: 1000

In Your Workspace

Policy Settings by Type report

Developers

Category URI

tmod:@turbot/turbot#/control/categories/cloudIntegration

Policy Type URI

tmod:@turbot/servicenow-gcp-sql#/policy/types/instanceServiceNowTableDefinition

GraphQL

query policyType(id: "tmod:@turbot/servicenow-gcp-sql#/policy/types/instanceServiceNowTableDefinition") { … }

query policySettings(filter: "policyTypeId:'tmod:@turbot/servicenow-gcp-sql#/policy/types/instanceServiceNowTableDefinition'") { … }

query policyValues(filter: "policyTypeId:'tmod:@turbot/servicenow-gcp-sql#/policy/types/instanceServiceNowTableDefinition'") { … }

CLI

Get Policy Type

turbot graphql policy-type --id "tmod:@turbot/servicenow-gcp-sql#/policy/types/instanceServiceNowTableDefinition"

Get Policy Settings

turbot graphql policy-settings --filter "policyTypeId:tmod:@turbot/servicenow-gcp-sql#/policy/types/instanceServiceNowTableDefinition"

Policy Specification

Schema Type	`object`
Default	table: name: guardrails_gcp_sql_instance label: GCP > SQL > Instance extendsTable: cmdb_ci columns: - name: availability_type label: Availability Type - name: backup_enabled label: Backup Enabled type: boolean - name: backup_start_time label: Backup Start Time - name: current_disk_size label: Current Disk Size - name: data_disk_size_gb label: Data Disk Size GB - name: database_version label: Database Version - name: enable_point_in_time_recovery label: Enable Point In Time Recovery type: boolean - name: gce_zone label: Gce Zone - name: instance_name label: Instance Name - name: instance_type label: Instance Type - name: ip_addresses label: IP Addresses type: string size: 1000 - name: ip_configuration label: IP Configuration type: string size: 1000 - name: ipv6_address label: IPv6 Address - name: kms_key_name label: KMS Key Name - name: labels label: Labels type: string size: 1000 - name: machine_type label: Machine Type - name: maintenance_window label: Maintenance Window type: string size: 1000 - name: max_disk_size label: Max Disk Size - name: project label: Project ID type: string - name: region label: Region Name type: string - name: service_account_email_address label: Service Account Email Address - name: ssl_configuration label: SSL Configuration type: string size: 1000 - name: state label: State - name: storage_auto_resize label: Storage Auto Resize type: boolean - name: tags label: Tags type: string size: 1000

Schema Type

object

Default

table:
  name: guardrails_gcp_sql_instance
  label: GCP > SQL > Instance
  extendsTable: cmdb_ci
columns:
  - name: availability_type
    label: Availability Type
  - name: backup_enabled
    label: Backup Enabled
    type: boolean
  - name: backup_start_time
    label: Backup Start Time
  - name: current_disk_size
    label: Current Disk Size
  - name: data_disk_size_gb
    label: Data Disk Size GB
  - name: database_version
    label: Database Version
  - name: enable_point_in_time_recovery
    label: Enable Point In Time Recovery
    type: boolean
  - name: gce_zone
    label: Gce Zone
  - name: instance_name
    label: Instance Name
  - name: instance_type
    label: Instance Type
  - name: ip_addresses
    label: IP Addresses
    type: string
    size: 1000
  - name: ip_configuration
    label: IP Configuration
    type: string
    size: 1000
  - name: ipv6_address
    label: IPv6 Address
  - name: kms_key_name
    label: KMS Key Name
  - name: labels
    label: Labels
    type: string
    size: 1000
  - name: machine_type
    label: Machine Type
  - name: maintenance_window
    label: Maintenance Window
    type: string
    size: 1000
  - name: max_disk_size
    label: Max Disk Size
  - name: project
    label: Project ID
    type: string
  - name: region
    label: Region Name
    type: string
  - name: service_account_email_address
    label: Service Account Email Address
  - name: ssl_configuration
    label: SSL Configuration
    type: string
    size: 1000
  - name: state
    label: State
  - name: storage_auto_resize
    label: Storage Auto Resize
    type: boolean
  - name: tags
    label: Tags
    type: string
    size: 1000