Policy: Azure > SQL > Elastic Pool > 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 Azure > SQL > Elastic Pool data.

Resource Types

This policy targets the following resource types:

ServiceNow > Instance

Primary Policy

This policy is used with the following primary policy:

Azure > SQL > Elastic Pool > ServiceNow > Table

Controls

Policy Specification

Schema Type	`object`
Default	`table: name: guardrails_azure_sql_elasticpool label: Azure > SQL > Elastic Pool extendsTable: cmdb_ci columns: - name: elastic_pool_name label: Elastic Pool Name - name: id label: ID - name: region label: Region - name: resource_group label: Resource Group type: string size: 200 - name: state label: State - name: subscription_id label: Subscription ID - name: tags label: Tags type: string size: 1000 - name: type label: Type - name: zone_redundant label: Zone Redundant type: boolean`

Schema Type

object

Default

table:
  name: guardrails_azure_sql_elasticpool
  label: Azure > SQL > Elastic Pool
  extendsTable: cmdb_ci
columns:
  - name: elastic_pool_name
    label: Elastic Pool Name
  - name: id
    label: ID
  - name: region
    label: Region
  - name: resource_group
    label: Resource Group
    type: string
    size: 200
  - name: state
    label: State
  - name: subscription_id
    label: Subscription ID
  - name: tags
    label: Tags
    type: string
    size: 1000
  - name: type
    label: Type
  - name: zone_redundant
    label: Zone Redundant
    type: boolean

In Your Workspace

Policy Settings by Type report

Developers

Category URI

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

Policy Type URI

tmod:@turbot/servicenow-azure-sql#/policy/types/elasticPoolServiceNowTableDefinition

GraphQL

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

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

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

CLI

Get Policy Type

turbot graphql policy-type --id "tmod:@turbot/servicenow-azure-sql#/policy/types/elasticPoolServiceNowTableDefinition"

Get Policy Settings

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