ServiceNow CMDB CI relationship sync: faster, more complete →
Mods
ServiceNow

Policy: Azure > Data Factory > Pipeline > ServiceNow > Configuration Item > Table Definition

This policy specifically allows users to define two key aspects: the name of the ServiceNow table where the Azure > Data Factory > Pipeline 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-datafactory#/policy/types/pipelineServiceNowTableDefinition 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