Policy: Azure > PostgreSQL > Flexible Server > ServiceNow > Configuration Item > Record

The policy facilitates the accurate representation of cloud resource within the ServiceNow environment, ensuring that critical data is effectively mapped and managed. Attribute of an Azure > PostgreSQL > Flexible Server is systematically mapped to a specific column in a ServiceNow table.

The policy allows enabling organizations to select and map only those attributes that are most relevant to their operational needs. It significantly reduces the manual effort involved in data transfer and minimizes the risk of errors, thereby enhancing the overall efficiency of data management.

Resource Types

This policy targets the following resource types:

Azure > PostgreSQL > Flexible Server

Primary Policy

This policy is used with the following primary policy:

Azure > PostgreSQL > Flexible Server > ServiceNow > Configuration Item

Controls

Policy Specification

Schema Type	`object`
Default template	flexible_server_configurations: {{ $.resource.data.configurations \| dump \| safe }} id: {{ $.resource.data.id \| dump \| safe }} postgresql_flexible_server_name: {{ $.resource.data.name \| dump \| safe }} region: {{ $.resource.data.location \| dump \| safe }} resource_group: {{ $.resource.metadata.azure.resourceGroupName \| dump \| safe }} sku: {{ $.resource.data.sku \| dump \| safe }} subscription_id: {{ $.resource.metadata.azure.subscriptionId \| dump \| safe }} tags: {{ $.resource.turbot.tags \| dump \| safe }} type: {{ $.resource.data.type \| dump \| safe }}
Default template input	`\| { resource: flexibleServer{ data metadata turbot { akas id tags title } } }`

Schema Type

object

Default template

flexible_server_configurations: {{ $.resource.data.configurations | dump | safe }}
id: {{ $.resource.data.id | dump | safe }}
postgresql_flexible_server_name: {{ $.resource.data.name | dump | safe }}
region: {{ $.resource.data.location | dump | safe }}
resource_group: {{ $.resource.metadata.azure.resourceGroupName | dump | safe }}
sku: {{ $.resource.data.sku | dump | safe }}
subscription_id: {{ $.resource.metadata.azure.subscriptionId | dump | safe }}
tags: {{ $.resource.turbot.tags | dump | safe }}
type: {{ $.resource.data.type | dump | safe }}

Default template input

|
  {
    resource: flexibleServer{
      data
      metadata
      turbot {
        akas
        id
        tags
        title
      }
    }
  }

In Your Workspace

Policy Settings by Type report

Developers

Category URI

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

Policy Type URI

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

GraphQL

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

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

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

CLI

Get Policy Type

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

Get Policy Settings

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