Policy: GCP > SQL > Database > 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 GCP > SQL > Database 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:

GCP > SQL > Database

Primary Policy

This policy is used with the following primary policy:

GCP > SQL > Database > ServiceNow > Configuration Item

Controls

Policy Specification

Schema Type	`object`
Default template	charset: {{ $.resource.data.charset \| dump \| safe }} collation: {{ $.resource.data.collation \| dump \| safe }} database_location: {{ $.resource.metadata.gcp.regionName \| dump \| safe }} database_name: {{ $.resource.data.name \| dump \| safe }} etag: {{ $.resource.data.etag \| dump \| safe }} instance_name: {{ $.resource.data.instance \| dump \| safe }} kind: {{ $.resource.data.kind \| dump \| safe }} project: {{ $.resource.metadata.gcp.projectId \| dump \| safe }} self_link: {{ $.resource.data.selfLink \| dump \| safe }} sql_server_database_details: {{ $.resource.data.sqlserverDatabaseDetails \| dump \| safe }}
Default template input	`\| { resource: database{ data metadata turbot { akas id tags title } } }`

Schema Type

object

Default template

charset: {{ $.resource.data.charset | dump | safe }}
collation: {{ $.resource.data.collation | dump | safe }}
database_location: {{ $.resource.metadata.gcp.regionName | dump | safe }}
database_name: {{ $.resource.data.name | dump | safe }}
etag: {{ $.resource.data.etag | dump | safe }}
instance_name: {{ $.resource.data.instance | dump | safe }}
kind: {{ $.resource.data.kind | dump | safe }}
project: {{ $.resource.metadata.gcp.projectId | dump | safe }}
self_link: {{ $.resource.data.selfLink | dump | safe }}
sql_server_database_details: {{ $.resource.data.sqlserverDatabaseDetails | dump | safe }}

Default template input

|
  {
    resource: database{
      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-gcp-sql#/policy/types/databaseServiceNowConfigurationItemRecord

GraphQL

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

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

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

CLI

Get Policy Type

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

Get Policy Settings

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