Product logo
DocsBlogPricing

Policy types for @turbot/servicenow-azure-cosmosdb

Azure > Cosmos DB > Database Account > ServiceNow

URI
tmod:@turbot/servicenow-azure-cosmosdb#/policy/types/databaseAccountServiceNow
Category
Parent
Targets

Azure > Cosmos DB > Database Account > ServiceNow > Configuration Item

Synchronize the data for the Azure > Cosmos DB > Database Account based on the policies Azure > Cosmos DB > Database Account > ServiceNow > Configuration Item > *

The Configuration Item control is responsible for automatically synchronizing records in a designated ServiceNow table, maintaining an up-to-date reflection of the Azure > Cosmos DB > Database Account information within the ServiceNow CMDB.

URI
tmod:@turbot/servicenow-azure-cosmosdb#/policy/types/databaseAccountServiceNowConfigurationItem
Category
Parent
Targets
Valid Value
[
  "Skip",
  "Check: Archived",
  "Check: Deleted",
  "Check: Sync",
  "Enforce: Archived",
  "Enforce: Deleted",
  "Enforce: Sync",
  "Enforce: Sync, archive on delete"
]
Schema
{
  "type": "string",
  "enum": [
    "Skip",
    "Check: Archived",
    "Check: Deleted",
    "Check: Sync",
    "Enforce: Archived",
    "Enforce: Deleted",
    "Enforce: Sync",
    "Enforce: Sync, archive on delete"
  ],
  "example": [
    "Skip"
  ],
  "default": "Skip"
}

Azure > Cosmos DB > Database Account > 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 > Cosmos DB > Database Account 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.

URI
tmod:@turbot/servicenow-azure-cosmosdb#/policy/types/databaseAccountServiceNowConfigurationItemRecord
Category
Parent
Targets
Default Template Input
"{\n  resource: databaseAccount{\n    data\n    metadata\n    turbot {\n      akas\n      id\n      tags\n      title\n    }\n  }\n}\n"
Default Template
"connector_offer: {{ $.resource.data.connectorOffer | dump | safe }}\nconsistency_policy_default_consistency_level: {{ $.resource.data.consistencyPolicy.defaultConsistencyLevel | dump | safe }}\nconsistency_policy_max_interval: {{ $.resource.data.consistencyPolicy.maxIntervalInSeconds | dump | safe }}\nconsistency_policy_max_staleness_prefix: {{ $.resource.data.consistencyPolicy.maxStalenessPrefix | dump | safe }}\ndatabase_account_location: {{ $.resource.data.location | dump | safe }}\ndatabase_account_name: {{ $.resource.data.name | dump | safe }}\ndatabase_account_offer_type: {{ $.resource.data.databaseAccountOfferType | dump | safe }}\ndocument_endpoint: {{ $.resource.data.documentEndpoint | dump | safe }}\nenable_automatic_failover: {{ $.resource.data.enableAutomaticFailover | dump | safe }}\nenable_cassandra_connector: {{ $.resource.data.enableCassandraConnector | dump | safe }}\nenable_multiple_write_locations: {{ $.resource.data.enableMultipleWriteLocations | dump | safe }}\nfailover_policies: {{ $.resource.data.failoverPolicies | dump | safe }}\nid: {{ $.resource.data.id | dump | safe }}\nis_virtual_network_filter_enabled: {{ $.resource.data.isVirtualNetworkFilterEnabled | dump | safe }}\nkind: {{ $.resource.data.kind | dump | safe }}\nprovisioning_state: {{ $.resource.data.provisioningState | dump | safe }}\nread_locations: {{ $.resource.data.readLocations | dump | safe }}\nresource_group: {{ $.resource.metadata.azure.resourceGroupName | dump | safe }}\nsubscription_id: {{ $.resource.metadata.azure.subscriptionId | dump | safe }}\ntags: {{ $.resource.turbot.tags | dump | safe }}\nvirtual_network_rules: {{ $.resource.data.virtualNetworkRules | dump | safe }}\nwrite_locations: {{ $.resource.data.writeLocations | dump | safe }}\n"
Schema
{
  "type": "object"
}

Azure > Cosmos DB > Database Account > ServiceNow > Configuration Item > Table Definition

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

URI
tmod:@turbot/servicenow-azure-cosmosdb#/policy/types/databaseAccountServiceNowConfigurationItemTableDefinition
Category
Parent
Targets
Default Template Input
[
  "{\n  serviceNowInstance: resources(filter: \"resourceTypeId:tmod:@turbot/servicenow#/resource/types/instance level:self limit:1\") {\n    items {\n      turbot {\n        id\n      }\n    }\n  }\n}\n",
  "{\n  tableDefinition: policyValues(filter: \"policyTypeId:tmod:@turbot/servicenow-azure-cosmosdb#/policy/types/databaseAccountServiceNowTableDefinition resourceId:{{$.serviceNowInstance.items[0].turbot.id}} level:self\") {\n    items {\n      value\n    }\n  }\n  applicationScope: policyValues(filter: \"policyTypeId:tmod:@turbot/servicenow#/policy/types/serviceNowApplicationScope resourceId:{{$.serviceNowInstance.items[0].turbot.id}} level:self\") {\n    items {\n      value\n    }\n  }\n}\n"
]
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 %}"\n"
Schema
{
  "type": "object",
  "additionalProperties": false,
  "required": [
    "tableName"
  ],
  "properties": {
    "tableName": {
      "type": "string"
    },
    "archiveColumns": {
      "type": "object"
    }
  }
}

Azure > Cosmos DB > Database Account > ServiceNow > Table

Configure a Table for Azure > Cosmos DB > Database Account resource type in ServiceNow via the Azure > Cosmos DB > Database Account > ServiceNow > Table > * policies.

URI
tmod:@turbot/servicenow-azure-cosmosdb#/policy/types/databaseAccountServiceNowTable
Category
Parent
Targets
Valid Value
[
  "Skip",
  "Check: Configured",
  "Enforce: Configured"
]
Schema
{
  "type": "string",
  "enum": [
    "Skip",
    "Check: Configured",
    "Enforce: Configured"
  ],
  "example": [
    "Skip"
  ],
  "default": "Skip"
}

Azure > Cosmos DB > Database Account > 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 > Cosmos DB > Database Account data.

URI
tmod:@turbot/servicenow-azure-cosmosdb#/policy/types/databaseAccountServiceNowTableDefinition
Category
Parent
Targets
Schema
{
  "type": "object",
  "additionalProperties": false,
  "required": [
    "table",
    "columns"
  ],
  "properties": {
    "table": {
      "type": "object",
      "required": [
        "name"
      ],
      "properties": {
        "name": {
          "type": "string",
          "pattern": "^([0-9a-z_])+$"
        },
        "label": {
          "type": "string"
        },
        "extendsTable": {
          "type": "string",
          "pattern": "^([0-9a-z_])+$"
        }
      }
    },
    "columns": {
      "type": "array",
      "description": "An array of columns with their mappings to the CMDB.",
      "default": [],
      "items": {
        "type": "object",
        "required": [
          "name"
        ],
        "properties": {
          "name": {
            "type": "string",
            "description": "The name of the column in the table.",
            "pattern": "^([0-9a-z_])+$"
          },
          "label": {
            "type": "string",
            "description": "The label for the column."
          },
          "type": {
            "description": "The data type of the column.",
            "type": "string"
          },
          "size": {
            "type": "integer",
            "description": "The length for data type."
          }
        }
      }
    }
  },
  "default": {
    "table": {
      "name": "guardrails_azure_cosmosdb_databaseaccount",
      "label": "Azure > Cosmos DB > Database Account",
      "extendsTable": "cmdb_ci"
    },
    "columns": [
      {
        "name": "connector_offer",
        "label": "Connector Offer"
      },
      {
        "name": "consistency_policy_default_consistency_level",
        "label": "Default Consistency Level"
      },
      {
        "name": "consistency_policy_max_interval",
        "label": "Consistency Policy Max Interval"
      },
      {
        "name": "consistency_policy_max_staleness_prefix",
        "label": "Consistency Policy Max Staleness Prefix"
      },
      {
        "name": "database_account_location",
        "label": "Locations"
      },
      {
        "name": "database_account_name",
        "label": "Name"
      },
      {
        "name": "database_account_offer_type",
        "label": "Database Account Offer Type"
      },
      {
        "name": "document_endpoint",
        "label": "Document Endpoint"
      },
      {
        "name": "enable_automatic_failover",
        "label": "Enable Automatic Failover",
        "type": "boolean"
      },
      {
        "name": "enable_cassandra_connector",
        "label": "Enable Cassandra Connector",
        "type": "boolean"
      },
      {
        "name": "enable_multiple_write_locations",
        "label": "Enable Multiple Write Locations",
        "type": "boolean"
      },
      {
        "name": "failover_policies",
        "label": "Failover Policies",
        "type": "string",
        "size": 1000
      },
      {
        "name": "id",
        "label": "ID"
      },
      {
        "name": "is_virtual_network_filter_enabled",
        "label": "Is Virtual Network Filter Enabled",
        "type": "boolean"
      },
      {
        "name": "kind",
        "label": "Kind"
      },
      {
        "name": "provisioning_state",
        "label": "Provisioning State"
      },
      {
        "name": "read_locations",
        "label": "Read Locations",
        "type": "string",
        "size": 1000
      },
      {
        "name": "resource_group",
        "label": "Resource Group"
      },
      {
        "name": "subscription_id",
        "label": "Subscription ID"
      },
      {
        "name": "tags",
        "label": "Tags",
        "type": "string",
        "size": 1000
      },
      {
        "name": "virtual_network_rules",
        "label": "Virtual Network Rules",
        "type": "string",
        "size": 1000
      },
      {
        "name": "write_locations",
        "label": "Write Locations",
        "type": "string",
        "size": 1000
      }
    ]
  }
}

Azure > Cosmos DB > MongoDB Collection > ServiceNow

URI
tmod:@turbot/servicenow-azure-cosmosdb#/policy/types/mongoDbCollectionServiceNow
Category
Parent
Targets

Azure > Cosmos DB > MongoDB Collection > ServiceNow > Configuration Item

Synchronize the data for the Azure > Cosmos DB > MongoDB Collection based on the policies Azure > Cosmos DB > MongoDB Collection > ServiceNow > Configuration Item > *

The Configuration Item control is responsible for automatically synchronizing records in a designated ServiceNow table, maintaining an up-to-date reflection of the Azure > Cosmos DB > MongoDB Collection information within the ServiceNow CMDB.

URI
tmod:@turbot/servicenow-azure-cosmosdb#/policy/types/mongoDbCollectionServiceNowConfigurationItem
Category
Parent
Targets
Valid Value
[
  "Skip",
  "Check: Archived",
  "Check: Deleted",
  "Check: Sync",
  "Enforce: Archived",
  "Enforce: Deleted",
  "Enforce: Sync",
  "Enforce: Sync, archive on delete"
]
Schema
{
  "type": "string",
  "enum": [
    "Skip",
    "Check: Archived",
    "Check: Deleted",
    "Check: Sync",
    "Enforce: Archived",
    "Enforce: Deleted",
    "Enforce: Sync",
    "Enforce: Sync, archive on delete"
  ],
  "example": [
    "Skip"
  ],
  "default": "Skip"
}

Azure > Cosmos DB > MongoDB Collection > 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 > Cosmos DB > MongoDB Collection 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.

URI
tmod:@turbot/servicenow-azure-cosmosdb#/policy/types/mongoDbCollectionServiceNowConfigurationItemRecord
Category
Parent
Targets
Default Template Input
"{\n  resource: mongoDbCollection{\n    data\n    metadata\n    turbot {\n      akas\n      id\n      tags\n      title\n    }\n  }\n}\n"
Default Template
"id: {{ $.resource.data.id | dump | safe }}\nindexes: {{ $.resource.data.indexes | dump | safe }}\nmongo_db_collection_name: {{ $.resource.data.name | dump | safe }}\nresource_group: {{ $.resource.metadata.azure.resourceGroupName | dump | safe }}\nshard_key: {{ $.resource.data.shardKey | dump | safe }}\nsubscription_id: {{ $.resource.metadata.azure.subscriptionId | dump | safe }}\n"
Schema
{
  "type": "object"
}

Azure > Cosmos DB > MongoDB Collection > ServiceNow > Configuration Item > Table Definition

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

URI
tmod:@turbot/servicenow-azure-cosmosdb#/policy/types/mongoDbCollectionServiceNowConfigurationItemTableDefinition
Category
Parent
Targets
Default Template Input
[
  "{\n  serviceNowInstance: resources(filter: \"resourceTypeId:tmod:@turbot/servicenow#/resource/types/instance level:self limit:1\") {\n    items {\n      turbot {\n        id\n      }\n    }\n  }\n}\n",
  "{\n  tableDefinition: policyValues(filter: \"policyTypeId:tmod:@turbot/servicenow-azure-cosmosdb#/policy/types/mongoDbCollectionServiceNowTableDefinition resourceId:{{$.serviceNowInstance.items[0].turbot.id}} level:self\") {\n    items {\n      value\n    }\n  }\n  applicationScope: policyValues(filter: \"policyTypeId:tmod:@turbot/servicenow#/policy/types/serviceNowApplicationScope resourceId:{{$.serviceNowInstance.items[0].turbot.id}} level:self\") {\n    items {\n      value\n    }\n  }\n}\n"
]
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 %}"\n"
Schema
{
  "type": "object",
  "additionalProperties": false,
  "required": [
    "tableName"
  ],
  "properties": {
    "tableName": {
      "type": "string"
    },
    "archiveColumns": {
      "type": "object"
    }
  }
}

Azure > Cosmos DB > MongoDB Collection > ServiceNow > Table

Configure a Table for Azure > Cosmos DB > MongoDB Collection resource type in ServiceNow via the Azure > Cosmos DB > MongoDB Collection > ServiceNow > Table > * policies.

URI
tmod:@turbot/servicenow-azure-cosmosdb#/policy/types/mongoDbCollectionServiceNowTable
Category
Parent
Targets
Valid Value
[
  "Skip",
  "Check: Configured",
  "Enforce: Configured"
]
Schema
{
  "type": "string",
  "enum": [
    "Skip",
    "Check: Configured",
    "Enforce: Configured"
  ],
  "example": [
    "Skip"
  ],
  "default": "Skip"
}

Azure > Cosmos DB > MongoDB Collection > 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 > Cosmos DB > MongoDB Collection data.

URI
tmod:@turbot/servicenow-azure-cosmosdb#/policy/types/mongoDbCollectionServiceNowTableDefinition
Category
Parent
Targets
Schema
{
  "type": "object",
  "additionalProperties": false,
  "required": [
    "table",
    "columns"
  ],
  "properties": {
    "table": {
      "type": "object",
      "required": [
        "name"
      ],
      "properties": {
        "name": {
          "type": "string",
          "pattern": "^([0-9a-z_])+$"
        },
        "label": {
          "type": "string"
        },
        "extendsTable": {
          "type": "string",
          "pattern": "^([0-9a-z_])+$"
        }
      }
    },
    "columns": {
      "type": "array",
      "description": "An array of columns with their mappings to the CMDB.",
      "default": [],
      "items": {
        "type": "object",
        "required": [
          "name"
        ],
        "properties": {
          "name": {
            "type": "string",
            "description": "The name of the column in the table.",
            "pattern": "^([0-9a-z_])+$"
          },
          "label": {
            "type": "string",
            "description": "The label for the column."
          },
          "type": {
            "description": "The data type of the column.",
            "type": "string"
          },
          "size": {
            "type": "integer",
            "description": "The length for data type."
          }
        }
      }
    }
  },
  "default": {
    "table": {
      "name": "guardrails_azure_cosmosdb_mongodbcollection",
      "label": "Azure > Cosmos DB > MongoDB Collection",
      "extendsTable": "cmdb_ci"
    },
    "columns": [
      {
        "name": "id",
        "label": "ID"
      },
      {
        "name": "indexes",
        "label": "Indexes",
        "type": "string",
        "size": 5000
      },
      {
        "name": "mongo_db_collection_name",
        "label": "Name"
      },
      {
        "name": "resource_group",
        "label": "Resource Group"
      },
      {
        "name": "shard_key",
        "label": "Shard Key",
        "type": "string",
        "size": 1000
      },
      {
        "name": "subscription_id",
        "label": "Subscription Id"
      }
    ]
  }
}

Azure > Cosmos DB > MongoDB Database > ServiceNow

URI
tmod:@turbot/servicenow-azure-cosmosdb#/policy/types/mongoDbDatabaseServiceNow
Category
Parent
Targets

Azure > Cosmos DB > MongoDB Database > ServiceNow > Configuration Item

Synchronize the data for the Azure > Cosmos DB > MongoDB Database based on the policies Azure > Cosmos DB > MongoDB Database > ServiceNow > Configuration Item > *

The Configuration Item control is responsible for automatically synchronizing records in a designated ServiceNow table, maintaining an up-to-date reflection of the Azure > Cosmos DB > MongoDB Database information within the ServiceNow CMDB.

URI
tmod:@turbot/servicenow-azure-cosmosdb#/policy/types/mongoDbDatabaseServiceNowConfigurationItem
Category
Parent
Targets
Valid Value
[
  "Skip",
  "Check: Archived",
  "Check: Deleted",
  "Check: Sync",
  "Enforce: Archived",
  "Enforce: Deleted",
  "Enforce: Sync",
  "Enforce: Sync, archive on delete"
]
Schema
{
  "type": "string",
  "enum": [
    "Skip",
    "Check: Archived",
    "Check: Deleted",
    "Check: Sync",
    "Enforce: Archived",
    "Enforce: Deleted",
    "Enforce: Sync",
    "Enforce: Sync, archive on delete"
  ],
  "example": [
    "Skip"
  ],
  "default": "Skip"
}

Azure > Cosmos DB > MongoDB 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 Azure > Cosmos DB > MongoDB 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.

URI
tmod:@turbot/servicenow-azure-cosmosdb#/policy/types/mongoDbDatabaseServiceNowConfigurationItemRecord
Category
Parent
Targets
Default Template Input
"{\n  resource: mongoDbDatabase{\n    data\n    metadata\n    turbot {\n      akas\n      id\n      tags\n      title\n    }\n  }\n}\n"
Default Template
"id: {{ $.resource.data.id | dump | safe }}\nmongo_db_database_name: {{ $.resource.data.name | dump | safe }}\nresource_group: {{ $.resource.metadata.azure.resourceGroupName | dump | safe }}\nsubscription_id: {{ $.resource.metadata.azure.subscriptionId | dump | safe }}\n"
Schema
{
  "type": "object"
}

Azure > Cosmos DB > MongoDB Database > ServiceNow > Configuration Item > Table Definition

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

URI
tmod:@turbot/servicenow-azure-cosmosdb#/policy/types/mongoDbDatabaseServiceNowConfigurationItemTableDefinition
Category
Parent
Targets
Default Template Input
[
  "{\n  serviceNowInstance: resources(filter: \"resourceTypeId:tmod:@turbot/servicenow#/resource/types/instance level:self limit:1\") {\n    items {\n      turbot {\n        id\n      }\n    }\n  }\n}\n",
  "{\n  tableDefinition: policyValues(filter: \"policyTypeId:tmod:@turbot/servicenow-azure-cosmosdb#/policy/types/mongoDbDatabaseServiceNowTableDefinition resourceId:{{$.serviceNowInstance.items[0].turbot.id}} level:self\") {\n    items {\n      value\n    }\n  }\n  applicationScope: policyValues(filter: \"policyTypeId:tmod:@turbot/servicenow#/policy/types/serviceNowApplicationScope resourceId:{{$.serviceNowInstance.items[0].turbot.id}} level:self\") {\n    items {\n      value\n    }\n  }\n}\n"
]
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 %}"\n"
Schema
{
  "type": "object",
  "additionalProperties": false,
  "required": [
    "tableName"
  ],
  "properties": {
    "tableName": {
      "type": "string"
    },
    "archiveColumns": {
      "type": "object"
    }
  }
}

Azure > Cosmos DB > MongoDB Database > ServiceNow > Table

Configure a Table for Azure > Cosmos DB > MongoDB Database resource type in ServiceNow via the Azure > Cosmos DB > MongoDB Database > ServiceNow > Table > * policies.

URI
tmod:@turbot/servicenow-azure-cosmosdb#/policy/types/mongoDbDatabaseServiceNowTable
Category
Parent
Targets
Valid Value
[
  "Skip",
  "Check: Configured",
  "Enforce: Configured"
]
Schema
{
  "type": "string",
  "enum": [
    "Skip",
    "Check: Configured",
    "Enforce: Configured"
  ],
  "example": [
    "Skip"
  ],
  "default": "Skip"
}

Azure > Cosmos DB > MongoDB Database > 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 > Cosmos DB > MongoDB Database data.

URI
tmod:@turbot/servicenow-azure-cosmosdb#/policy/types/mongoDbDatabaseServiceNowTableDefinition
Category
Parent
Targets
Schema
{
  "type": "object",
  "additionalProperties": false,
  "required": [
    "table",
    "columns"
  ],
  "properties": {
    "table": {
      "type": "object",
      "required": [
        "name"
      ],
      "properties": {
        "name": {
          "type": "string",
          "pattern": "^([0-9a-z_])+$"
        },
        "label": {
          "type": "string"
        },
        "extendsTable": {
          "type": "string",
          "pattern": "^([0-9a-z_])+$"
        }
      }
    },
    "columns": {
      "type": "array",
      "description": "An array of columns with their mappings to the CMDB.",
      "default": [],
      "items": {
        "type": "object",
        "required": [
          "name"
        ],
        "properties": {
          "name": {
            "type": "string",
            "description": "The name of the column in the table.",
            "pattern": "^([0-9a-z_])+$"
          },
          "label": {
            "type": "string",
            "description": "The label for the column."
          },
          "type": {
            "description": "The data type of the column.",
            "type": "string"
          },
          "size": {
            "type": "integer",
            "description": "The length for data type."
          }
        }
      }
    }
  },
  "default": {
    "table": {
      "name": "guardrails_azure_cosmosdb_mongodbdatabase",
      "label": "Azure > Cosmos DB > MongoDB Database",
      "extendsTable": "cmdb_ci"
    },
    "columns": [
      {
        "name": "id",
        "label": "ID"
      },
      {
        "name": "mongo_db_database_name",
        "label": "Name"
      },
      {
        "name": "resource_group",
        "label": "Resource Group"
      },
      {
        "name": "subscription_id",
        "label": "Subscription ID"
      }
    ]
  }
}

Azure > Cosmos DB > SQL Container > ServiceNow

URI
tmod:@turbot/servicenow-azure-cosmosdb#/policy/types/sqlContainerServiceNow
Category
Parent
Targets

Azure > Cosmos DB > SQL Container > ServiceNow > Configuration Item

Synchronize the data for the Azure > Cosmos DB > SQL Container based on the policies Azure > Cosmos DB > SQL Container > ServiceNow > Configuration Item > *

The Configuration Item control is responsible for automatically synchronizing records in a designated ServiceNow table, maintaining an up-to-date reflection of the Azure > Cosmos DB > SQL Container information within the ServiceNow CMDB.

URI
tmod:@turbot/servicenow-azure-cosmosdb#/policy/types/sqlContainerServiceNowConfigurationItem
Category
Parent
Targets
Valid Value
[
  "Skip",
  "Check: Archived",
  "Check: Deleted",
  "Check: Sync",
  "Enforce: Archived",
  "Enforce: Deleted",
  "Enforce: Sync",
  "Enforce: Sync, archive on delete"
]
Schema
{
  "type": "string",
  "enum": [
    "Skip",
    "Check: Archived",
    "Check: Deleted",
    "Check: Sync",
    "Enforce: Archived",
    "Enforce: Deleted",
    "Enforce: Sync",
    "Enforce: Sync, archive on delete"
  ],
  "example": [
    "Skip"
  ],
  "default": "Skip"
}

Azure > Cosmos DB > SQL Container > 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 > Cosmos DB > SQL Container 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.

URI
tmod:@turbot/servicenow-azure-cosmosdb#/policy/types/sqlContainerServiceNowConfigurationItemRecord
Category
Parent
Targets
Default Template Input
"{\n  resource: sqlContainer{\n    data\n    metadata\n    turbot {\n      akas\n      id\n      tags\n      title\n    }\n  }\n}\n"
Default Template
"conflict_resolution_policy_mode: {{ $.resource.data.conflictResolutionPolicy.mode | dump | safe }}\nconflict_resolution_policy_path: {{ $.resource.data.conflictResolutionPolicy.conflictResolutionPath | dump | safe }}\nconflict_resolution_policy_procedure: {{ $.resource.data.conflictResolutionPolicy.conflictResolutionProcedure | dump | safe }}\ncontainer_id: {{ $.resource.data.sqlContainerId | dump | safe }}\ncontainer_rid: {{ $.resource.data._rid | dump | safe }}\ndatabase_account: {{ $.resource.data.databaseAccount | dump | safe }}\ndefault_ttl: {{ $.resource.data.defaultTtl | dump | safe }}\nindexing_policy: {{ $.resource.data.indexingPolicy | dump | safe }}\nlast_updated_timestamp: {{ $.resource.data._ts | dump | safe }}\npartition_key_kind: {{ $.resource.data.partitionKey.kind | dump | safe }}\npartition_key_paths: {{ $.resource.data.partitionKey.paths | dump | safe }}\nresource_group: {{ $.resource.metadata.azure.resourceGroupName | dump | safe }}\nsubscription_id: {{ $.resource.metadata.azure.subscriptionId | dump | safe }}\nunique_key_policy: {{ $.resource.data.uniqueKeyPolicy | dump | safe }}\n"
Schema
{
  "type": "object"
}

Azure > Cosmos DB > SQL Container > ServiceNow > Configuration Item > Table Definition

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

URI
tmod:@turbot/servicenow-azure-cosmosdb#/policy/types/sqlContainerServiceNowConfigurationItemTableDefinition
Category
Parent
Targets
Default Template Input
[
  "{\n  serviceNowInstance: resources(filter: \"resourceTypeId:tmod:@turbot/servicenow#/resource/types/instance level:self limit:1\") {\n    items {\n      turbot {\n        id\n      }\n    }\n  }\n}\n",
  "{\n  tableDefinition: policyValues(filter: \"policyTypeId:tmod:@turbot/servicenow-azure-cosmosdb#/policy/types/sqlContainerServiceNowTableDefinition resourceId:{{$.serviceNowInstance.items[0].turbot.id}} level:self\") {\n    items {\n      value\n    }\n  }\n  applicationScope: policyValues(filter: \"policyTypeId:tmod:@turbot/servicenow#/policy/types/serviceNowApplicationScope resourceId:{{$.serviceNowInstance.items[0].turbot.id}} level:self\") {\n    items {\n      value\n    }\n  }\n}\n"
]
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 %}"\n"
Schema
{
  "type": "object",
  "additionalProperties": false,
  "required": [
    "tableName"
  ],
  "properties": {
    "tableName": {
      "type": "string"
    },
    "archiveColumns": {
      "type": "object"
    }
  }
}

Azure > Cosmos DB > SQL Container > ServiceNow > Table

Configure a Table for Azure > Cosmos DB > SQL Container resource type in ServiceNow via the Azure > Cosmos DB > SQL Container > ServiceNow > Table > * policies.

URI
tmod:@turbot/servicenow-azure-cosmosdb#/policy/types/sqlContainerServiceNowTable
Category
Parent
Targets
Valid Value
[
  "Skip",
  "Check: Configured",
  "Enforce: Configured"
]
Schema
{
  "type": "string",
  "enum": [
    "Skip",
    "Check: Configured",
    "Enforce: Configured"
  ],
  "example": [
    "Skip"
  ],
  "default": "Skip"
}

Azure > Cosmos DB > SQL Container > 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 > Cosmos DB > SQL Container data.

URI
tmod:@turbot/servicenow-azure-cosmosdb#/policy/types/sqlContainerServiceNowTableDefinition
Category
Parent
Targets
Schema
{
  "type": "object",
  "additionalProperties": false,
  "required": [
    "table",
    "columns"
  ],
  "properties": {
    "table": {
      "type": "object",
      "required": [
        "name"
      ],
      "properties": {
        "name": {
          "type": "string",
          "pattern": "^([0-9a-z_])+$"
        },
        "label": {
          "type": "string"
        },
        "extendsTable": {
          "type": "string",
          "pattern": "^([0-9a-z_])+$"
        }
      }
    },
    "columns": {
      "type": "array",
      "description": "An array of columns with their mappings to the CMDB.",
      "default": [],
      "items": {
        "type": "object",
        "required": [
          "name"
        ],
        "properties": {
          "name": {
            "type": "string",
            "description": "The name of the column in the table.",
            "pattern": "^([0-9a-z_])+$"
          },
          "label": {
            "type": "string",
            "description": "The label for the column."
          },
          "type": {
            "description": "The data type of the column.",
            "type": "string"
          },
          "size": {
            "type": "integer",
            "description": "The length for data type."
          }
        }
      }
    }
  },
  "default": {
    "table": {
      "name": "guardrails_azure_cosmosdb_sqlcontainer",
      "label": "Azure > Cosmos DB > SQL Container",
      "extendsTable": "cmdb_ci"
    },
    "columns": [
      {
        "name": "conflict_resolution_policy_mode",
        "label": "Conflict Resolution Policy Mode"
      },
      {
        "name": "conflict_resolution_policy_path",
        "label": "Conflict Resolution Policy Path"
      },
      {
        "name": "conflict_resolution_policy_procedure",
        "label": "Conflict Resolution Policy Procedure"
      },
      {
        "name": "container_id",
        "label": "ID"
      },
      {
        "name": "container_rid",
        "label": "Container RID"
      },
      {
        "name": "database_account",
        "label": "Database Account"
      },
      {
        "name": "default_ttl",
        "label": "Default TTL"
      },
      {
        "name": "indexing_policy",
        "label": "Indexing Policy",
        "type": "string",
        "size": 2000
      },
      {
        "name": "last_updated_timestamp",
        "label": "Last Updated Timestamp"
      },
      {
        "name": "partition_key_kind",
        "label": "Partition Key Kind"
      },
      {
        "name": "partition_key_paths",
        "label": "Partition Key Paths",
        "type": "string",
        "size": 1000
      },
      {
        "name": "resource_group",
        "label": "Resource Group"
      },
      {
        "name": "subscription_id",
        "label": "Subscription ID"
      },
      {
        "name": "unique_key_policy",
        "label": "Unique Key Policy",
        "type": "string",
        "size": 1000
      }
    ]
  }
}

Azure > Cosmos DB > SQL Database > ServiceNow

URI
tmod:@turbot/servicenow-azure-cosmosdb#/policy/types/sqlDatabaseServiceNow
Category
Parent
Targets

Azure > Cosmos DB > SQL Database > ServiceNow > Configuration Item

Synchronize the data for the Azure > Cosmos DB > SQL Database based on the policies Azure > Cosmos DB > SQL Database > ServiceNow > Configuration Item > *

The Configuration Item control is responsible for automatically synchronizing records in a designated ServiceNow table, maintaining an up-to-date reflection of the Azure > Cosmos DB > SQL Database information within the ServiceNow CMDB.

URI
tmod:@turbot/servicenow-azure-cosmosdb#/policy/types/sqlDatabaseServiceNowConfigurationItem
Category
Parent
Targets
Valid Value
[
  "Skip",
  "Check: Archived",
  "Check: Deleted",
  "Check: Sync",
  "Enforce: Archived",
  "Enforce: Deleted",
  "Enforce: Sync",
  "Enforce: Sync, archive on delete"
]
Schema
{
  "type": "string",
  "enum": [
    "Skip",
    "Check: Archived",
    "Check: Deleted",
    "Check: Sync",
    "Enforce: Archived",
    "Enforce: Deleted",
    "Enforce: Sync",
    "Enforce: Sync, archive on delete"
  ],
  "example": [
    "Skip"
  ],
  "default": "Skip"
}

Azure > Cosmos DB > 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 Azure > Cosmos DB > 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.

URI
tmod:@turbot/servicenow-azure-cosmosdb#/policy/types/sqlDatabaseServiceNowConfigurationItemRecord
Category
Parent
Targets
Default Template Input
"{\n  resource: sqlDatabase{\n    data\n    metadata\n    turbot {\n      akas\n      id\n      tags\n      title\n    }\n  }\n}\n"
Default Template
"database_account: {{ $.resource.data.databaseAccount | dump | safe }}\ndatabase_colls: {{ $.resource.data._colls | dump | safe }}\ndatabase_rid: {{ $.resource.data._rid | dump | safe }}\ndatabase_users: {{ $.resource.data._users | dump | safe }}\nlast_updated_timestamp: {{ $.resource.data._ts | dump | safe }}\nresource_group: {{ $.resource.metadata.azure.resourceGroupName | dump | safe }}\nsql_database_id: {{ $.resource.data.sqlDatabaseId | dump | safe }}\nsubscription_id: {{ $.resource.metadata.azure.subscriptionId | dump | safe }}\n"
Schema
{
  "type": "object"
}

Azure > Cosmos DB > SQL Database > ServiceNow > Configuration Item > Table Definition

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

URI
tmod:@turbot/servicenow-azure-cosmosdb#/policy/types/sqlDatabaseServiceNowConfigurationItemTableDefinition
Category
Parent
Targets
Default Template Input
[
  "{\n  serviceNowInstance: resources(filter: \"resourceTypeId:tmod:@turbot/servicenow#/resource/types/instance level:self limit:1\") {\n    items {\n      turbot {\n        id\n      }\n    }\n  }\n}\n",
  "{\n  tableDefinition: policyValues(filter: \"policyTypeId:tmod:@turbot/servicenow-azure-cosmosdb#/policy/types/sqlDatabaseServiceNowTableDefinition resourceId:{{$.serviceNowInstance.items[0].turbot.id}} level:self\") {\n    items {\n      value\n    }\n  }\n  applicationScope: policyValues(filter: \"policyTypeId:tmod:@turbot/servicenow#/policy/types/serviceNowApplicationScope resourceId:{{$.serviceNowInstance.items[0].turbot.id}} level:self\") {\n    items {\n      value\n    }\n  }\n}\n"
]
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 %}"\n"
Schema
{
  "type": "object",
  "additionalProperties": false,
  "required": [
    "tableName"
  ],
  "properties": {
    "tableName": {
      "type": "string"
    },
    "archiveColumns": {
      "type": "object"
    }
  }
}

Azure > Cosmos DB > SQL Database > ServiceNow > Table

Configure a Table for Azure > Cosmos DB > SQL Database resource type in ServiceNow via the Azure > Cosmos DB > SQL Database > ServiceNow > Table > * policies.

URI
tmod:@turbot/servicenow-azure-cosmosdb#/policy/types/sqlDatabaseServiceNowTable
Category
Parent
Targets
Valid Value
[
  "Skip",
  "Check: Configured",
  "Enforce: Configured"
]
Schema
{
  "type": "string",
  "enum": [
    "Skip",
    "Check: Configured",
    "Enforce: Configured"
  ],
  "example": [
    "Skip"
  ],
  "default": "Skip"
}

Azure > Cosmos DB > SQL Database > 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 > Cosmos DB > SQL Database data.

URI
tmod:@turbot/servicenow-azure-cosmosdb#/policy/types/sqlDatabaseServiceNowTableDefinition
Category
Parent
Targets
Schema
{
  "type": "object",
  "additionalProperties": false,
  "required": [
    "table",
    "columns"
  ],
  "properties": {
    "table": {
      "type": "object",
      "required": [
        "name"
      ],
      "properties": {
        "name": {
          "type": "string",
          "pattern": "^([0-9a-z_])+$"
        },
        "label": {
          "type": "string"
        },
        "extendsTable": {
          "type": "string",
          "pattern": "^([0-9a-z_])+$"
        }
      }
    },
    "columns": {
      "type": "array",
      "description": "An array of columns with their mappings to the CMDB.",
      "default": [],
      "items": {
        "type": "object",
        "required": [
          "name"
        ],
        "properties": {
          "name": {
            "type": "string",
            "description": "The name of the column in the table.",
            "pattern": "^([0-9a-z_])+$"
          },
          "label": {
            "type": "string",
            "description": "The label for the column."
          },
          "type": {
            "description": "The data type of the column.",
            "type": "string"
          },
          "size": {
            "type": "integer",
            "description": "The length for data type."
          }
        }
      }
    }
  },
  "default": {
    "table": {
      "name": "guardrails_azure_cosmosdb_sqldatabase",
      "label": "Azure > Cosmos DB > SQL Database",
      "extendsTable": "cmdb_ci"
    },
    "columns": [
      {
        "name": "database_account",
        "label": "Database Account"
      },
      {
        "name": "database_colls",
        "label": "Collections"
      },
      {
        "name": "database_rid",
        "label": "Database RID"
      },
      {
        "name": "database_users",
        "label": "Users"
      },
      {
        "name": "last_updated_timestamp",
        "label": "Last Updated Timestamp"
      },
      {
        "name": "resource_group",
        "label": "Resource Group"
      },
      {
        "name": "sql_database_id",
        "label": "ID"
      },
      {
        "name": "subscription_id",
        "label": "Subscription ID"
      }
    ]
  }
}