ServiceNow CMDB CI relationship sync: faster, more complete →
Turbot Guardrails Hub 
Hub
Mods
ServiceNow
76
Mods
5
Resource Types
1,883
Policies
857
Controls
0
Quick Actions
0
IAM

Policy: Azure > SQL > Server > ServiceNow > Configuration Item > Table Definition

This policy specifically allows users to define two key aspects: the name of the ServiceNow table where the Azure > SQL > Server data will be stored, and the details of the columns used for archiving purposes.

Resource Types

This policy targets the following resource types:

Primary Policy

This policy is used with the following primary policy:

Controls

Policy Specification

Schema Type
object
Default template
tableName: "{%- if $.applicationScope.items | length == 0 or $.tableDefinition.items | length == 0 %}  {%- else %}{{$.applicationScope.items[0].value}}_{{$.tableDefinition.items[0].value.table.name | lower}}{% endif %}"
Default template input
- |
  {
    serviceNowInstance: resources(filter: "resourceTypeId:tmod:@turbot/servicenow#/resource/types/instance level:self limit:1") {
      items {
        turbot {
          id
        }
      }
    }
  }
- |
  {
    tableDefinition: policyValues(filter: "policyTypeId:tmod:@turbot/servicenow-azure-sql#/policy/types/serverServiceNowTableDefinition resourceId:{{$.serviceNowInstance.items[0].turbot.id}} level:self") {
      items {
        value
      }
    }
    applicationScope: policyValues(filter: "policyTypeId:tmod:@turbot/servicenow#/policy/types/serviceNowApplicationScope resourceId:{{$.serviceNowInstance.items[0].turbot.id}} level:self") {
      items {
        value
      }
    }
  }

Category

In Your Workspace

Developers