Policy: Azure > PostgreSQL > Flexible Server > 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 > PostgreSQL > Flexible Server data.

Resource Types

This policy targets the following resource types:

ServiceNow > Instance

Primary Policy

This policy is used with the following primary policy:

Azure > PostgreSQL > Flexible Server > ServiceNow > Table

Controls

Policy Specification

Schema Type	`object`
Default	table: name: guardrails_azure_postgresql_flexibleserver label: Azure > PostgreSQL > Flexible Server extendsTable: cmdb_ci columns: - name: flexible_server_configurations label: Flexible Server Configurations type: string size: 1000 - name: id label: ID - name: postgresql_flexible_server_name label: Postgresql Flexible Server Name - name: region label: Region - name: resource_group label: Resource Group type: string size: 200 - name: sku label: SKU type: string size: 1000 - name: subscription_id label: Subscription ID - name: tags label: Tags type: string size: 1000 - name: type label: Type

Schema Type

object

Default

table:
  name: guardrails_azure_postgresql_flexibleserver
  label: Azure > PostgreSQL > Flexible Server
  extendsTable: cmdb_ci
columns:
  - name: flexible_server_configurations
    label: Flexible Server Configurations
    type: string
    size: 1000
  - name: id
    label: ID
  - name: postgresql_flexible_server_name
    label: Postgresql Flexible Server Name
  - name: region
    label: Region
  - name: resource_group
    label: Resource Group
    type: string
    size: 200
  - name: sku
    label: SKU
    type: string
    size: 1000
  - name: subscription_id
    label: Subscription ID
  - name: tags
    label: Tags
    type: string
    size: 1000
  - name: type
    label: Type

In Your Workspace

Policy Settings by Type report

Developers

Category URI

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

Policy Type URI

tmod:@turbot/servicenow-azure-postgresql#/policy/types/flexibleServerServiceNowTableDefinition

GraphQL

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

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

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

CLI

Get Policy Type

turbot graphql policy-type --id "tmod:@turbot/servicenow-azure-postgresql#/policy/types/flexibleServerServiceNowTableDefinition"

Get Policy Settings

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