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

Targets

This policy targets the following resource types:

ServiceNow > Instance

Primary Policy

This policy is used with the following primary policy:

Azure > PostgreSQL > Server > ServiceNow > Table

Controls

Setting this policy configures this control:

Azure > PostgreSQL > Server > ServiceNow > Table

Policy Specification

Schema Type	`object`
Default	table: name: guardrails_azure_postgresql_server label: Azure > PostgreSQL > Server extendsTable: cmdb_ci columns: - name: administrator_login label: Administrator Login - name: backup_retention_days label: Backup Retention Days - name: earliest_restore_date label: Earliest Restore Date - name: firewall_rules label: Firewall Rules type: string size: 1000 - name: fully_qualified_domain_name label: Fully Qualified Domain Name - name: geo_redundant_backup label: Geo Redundant Backup - name: id label: ID - name: master_server_id label: Master Server ID - name: minimal_tls_version label: Minimal TLS Version - name: region label: Region - name: region_name label: Region Name type: string size: 200 - name: replica_capacity label: Replica Capacity - name: replication_role label: Replication Role - name: resource_group label: Resource Group type: string size: 200 - name: server_configurations label: Server Configurations type: string size: 1000 - name: server_name label: Server Name - name: sku_capacity label: SKU Capacity - name: sku_family label: SKU Family - name: sku_name label: SKU Name - name: sku_size label: SKU Size - name: sku_tier label: SKU Tier - name: ssl_enforcement label: SSL Enforcement - name: storage_auto_grow label: Storage Auto Grow - name: storage_mb label: Storage MB - name: subscription_id label: Subscription ID type: string - name: tags label: Tags type: string size: 1000 - name: type label: Type - name: user_visible_state label: User Visible State - name: version label: Version

Schema Type

object

Default

table:
  name: guardrails_azure_postgresql_server
  label: Azure > PostgreSQL > Server
  extendsTable: cmdb_ci
columns:
  - name: administrator_login
    label: Administrator Login
  - name: backup_retention_days
    label: Backup Retention Days
  - name: earliest_restore_date
    label: Earliest Restore Date
  - name: firewall_rules
    label: Firewall Rules
    type: string
    size: 1000
  - name: fully_qualified_domain_name
    label: Fully Qualified Domain Name
  - name: geo_redundant_backup
    label: Geo Redundant Backup
  - name: id
    label: ID
  - name: master_server_id
    label: Master Server ID
  - name: minimal_tls_version
    label: Minimal TLS Version
  - name: region
    label: Region
  - name: region_name
    label: Region Name
    type: string
    size: 200
  - name: replica_capacity
    label: Replica Capacity
  - name: replication_role
    label: Replication Role
  - name: resource_group
    label: Resource Group
    type: string
    size: 200
  - name: server_configurations
    label: Server Configurations
    type: string
    size: 1000
  - name: server_name
    label: Server Name
  - name: sku_capacity
    label: SKU Capacity
  - name: sku_family
    label: SKU Family
  - name: sku_name
    label: SKU Name
  - name: sku_size
    label: SKU Size
  - name: sku_tier
    label: SKU Tier
  - name: ssl_enforcement
    label: SSL Enforcement
  - name: storage_auto_grow
    label: Storage Auto Grow
  - name: storage_mb
    label: Storage MB
  - name: subscription_id
    label: Subscription ID
    type: string
  - name: tags
    label: Tags
    type: string
    size: 1000
  - name: type
    label: Type
  - name: user_visible_state
    label: User Visible State
  - name: version
    label: Version

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/serverServiceNowTableDefinition

GraphQL

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

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

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

CLI

Get Policy Type

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

Get Policy Settings

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

Policy Specification

Schema Type	`object`
Default	table: name: guardrails_azure_postgresql_server label: Azure > PostgreSQL > Server extendsTable: cmdb_ci columns: - name: administrator_login label: Administrator Login - name: backup_retention_days label: Backup Retention Days - name: earliest_restore_date label: Earliest Restore Date - name: firewall_rules label: Firewall Rules type: string size: 1000 - name: fully_qualified_domain_name label: Fully Qualified Domain Name - name: geo_redundant_backup label: Geo Redundant Backup - name: id label: ID - name: master_server_id label: Master Server ID - name: minimal_tls_version label: Minimal TLS Version - name: region label: Region - name: region_name label: Region Name type: string size: 200 - name: replica_capacity label: Replica Capacity - name: replication_role label: Replication Role - name: resource_group label: Resource Group type: string size: 200 - name: server_configurations label: Server Configurations type: string size: 1000 - name: server_name label: Server Name - name: sku_capacity label: SKU Capacity - name: sku_family label: SKU Family - name: sku_name label: SKU Name - name: sku_size label: SKU Size - name: sku_tier label: SKU Tier - name: ssl_enforcement label: SSL Enforcement - name: storage_auto_grow label: Storage Auto Grow - name: storage_mb label: Storage MB - name: subscription_id label: Subscription ID type: string - name: tags label: Tags type: string size: 1000 - name: type label: Type - name: user_visible_state label: User Visible State - name: version label: Version

Schema Type

object

Default

table:
  name: guardrails_azure_postgresql_server
  label: Azure > PostgreSQL > Server
  extendsTable: cmdb_ci
columns:
  - name: administrator_login
    label: Administrator Login
  - name: backup_retention_days
    label: Backup Retention Days
  - name: earliest_restore_date
    label: Earliest Restore Date
  - name: firewall_rules
    label: Firewall Rules
    type: string
    size: 1000
  - name: fully_qualified_domain_name
    label: Fully Qualified Domain Name
  - name: geo_redundant_backup
    label: Geo Redundant Backup
  - name: id
    label: ID
  - name: master_server_id
    label: Master Server ID
  - name: minimal_tls_version
    label: Minimal TLS Version
  - name: region
    label: Region
  - name: region_name
    label: Region Name
    type: string
    size: 200
  - name: replica_capacity
    label: Replica Capacity
  - name: replication_role
    label: Replication Role
  - name: resource_group
    label: Resource Group
    type: string
    size: 200
  - name: server_configurations
    label: Server Configurations
    type: string
    size: 1000
  - name: server_name
    label: Server Name
  - name: sku_capacity
    label: SKU Capacity
  - name: sku_family
    label: SKU Family
  - name: sku_name
    label: SKU Name
  - name: sku_size
    label: SKU Size
  - name: sku_tier
    label: SKU Tier
  - name: ssl_enforcement
    label: SSL Enforcement
  - name: storage_auto_grow
    label: Storage Auto Grow
  - name: storage_mb
    label: Storage MB
  - name: subscription_id
    label: Subscription ID
    type: string
  - name: tags
    label: Tags
    type: string
    size: 1000
  - name: type
    label: Type
  - name: user_visible_state
    label: User Visible State
  - name: version
    label: Version