Policy types for @turbot/servicenow-azure-sql

Azure > SQL > Database > ServiceNow

URI
tmod:@turbot/servicenow-azure-sql#/policy/types/databaseServiceNow
Targets

Azure > SQL > Database > ServiceNow > Configuration Item

Synchronize the data for the Azure > SQL > Database based on the policies Azure > 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 > SQL > Database information within the ServiceNow CMDB.

URI
tmod:@turbot/servicenow-azure-sql#/policy/types/databaseServiceNowConfigurationItem
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 > 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 > 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-sql#/policy/types/databaseServiceNowConfigurationItemRecord
Default Template Input
"{\n resource: database{\n data\n metadata\n turbot {\n akas\n id\n tags\n title\n }\n }\n}\n"
Default Template
"collation: {{ $.resource.data.collation | dump | safe }}\ndatabase_id: {{ $.resource.data.databaseId | dump | safe }}\ndefault_secondary_location: {{ $.resource.data.defaultSecondaryLocation | dump | safe }}\nid: {{ $.resource.data.id | dump | safe }}\nmax_size_bytes: {{ $.resource.data.maxSizeBytes | dump | safe }}\nregion: {{ $.resource.data.location | dump | safe }}\nrequested_service_objective_name: {{ $.resource.data.requestedServiceObjectiveName | dump | safe }}\nresource_group: {{ $.resource.metadata.azure.resourceGroupName | dump | safe }}\nstatus: {{ $.resource.data.status | dump | safe }}\nsubscription_id: {{ $.resource.metadata.azure.subscriptionId | dump | safe }}\ntags: {{ $.resource.turbot.tags | dump | safe }}\ntransparent_data_encryption: {{ $.resource.data.transparentDataEncryption | dump | safe }}\ntype: {{ $.resource.data.type | dump | safe }}\nzone_redundant: {{ $.resource.data.zoneRedundant | dump | safe }}\n"
Schema
{
"type": "object"
}

Azure > 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 > SQL > Database data will be stored, and the details of the columns used for archiving purposes.

URI
tmod:@turbot/servicenow-azure-sql#/policy/types/databaseServiceNowConfigurationItemTableDefinition
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-sql#/policy/types/databaseServiceNowTableDefinition 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 > SQL > Database > ServiceNow > Table

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

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

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

URI
tmod:@turbot/servicenow-azure-sql#/policy/types/databaseServiceNowTableDefinition
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_sql_database",
"label": "Azure > SQL > Database",
"extendsTable": "cmdb_ci"
},
"columns": [
{
"name": "collation",
"label": "Collation"
},
{
"name": "database_id",
"label": "Database ID"
},
{
"name": "default_secondary_location",
"label": "Default Secondary Location"
},
{
"name": "id",
"label": "ID"
},
{
"name": "max_size_bytes",
"label": "Max Size Bytes"
},
{
"name": "region",
"label": "Region"
},
{
"name": "requested_service_objective_name",
"label": "Requested Service Objective Name"
},
{
"name": "resource_group",
"label": "Resource Group",
"type": "string",
"size": 200
},
{
"name": "status",
"label": "Status"
},
{
"name": "subscription_id",
"label": "Subscription ID"
},
{
"name": "tags",
"label": "Tags",
"type": "string",
"size": 1000
},
{
"name": "transparent_data_encryption",
"label": "Transparent Data Encryption",
"type": "string",
"size": 1000
},
{
"name": "type",
"label": "Type"
},
{
"name": "zone_redundant",
"label": "Zone Redundant",
"type": "boolean"
}
]
}
}

Azure > SQL > Elastic Pool > ServiceNow

URI
tmod:@turbot/servicenow-azure-sql#/policy/types/elasticPoolServiceNow
Targets

Azure > SQL > Elastic Pool > ServiceNow > Configuration Item

Synchronize the data for the Azure > SQL > Elastic Pool based on the policies Azure > SQL > Elastic Pool > 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 > SQL > Elastic Pool information within the ServiceNow CMDB.

URI
tmod:@turbot/servicenow-azure-sql#/policy/types/elasticPoolServiceNowConfigurationItem
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 > SQL > Elastic Pool > 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 > SQL > Elastic Pool 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-sql#/policy/types/elasticPoolServiceNowConfigurationItemRecord
Default Template Input
"{\n resource: elasticPool{\n data\n metadata\n turbot {\n akas\n id\n tags\n title\n }\n }\n}\n"
Default Template
"elastic_pool_name: {{ $.resource.data.name | dump | safe }}\nid: {{ $.resource.data.id | dump | safe }}\nregion: {{ $.resource.data.location | dump | safe }}\nresource_group: {{ $.resource.metadata.azure.resourceGroupName | dump | safe }}\nstate: {{ $.resource.data.state | dump | safe }}\nsubscription_id: {{ $.resource.metadata.azure.subscriptionId | dump | safe }}\ntags: {{ $.resource.turbot.tags | dump | safe }}\ntype: {{ $.resource.data.type | dump | safe }}\nzone_redundant: {{ $.resource.data.zoneRedundant | dump | safe }}\n"
Schema
{
"type": "object"
}

Azure > SQL > Elastic Pool > 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 > Elastic Pool data will be stored, and the details of the columns used for archiving purposes.

URI
tmod:@turbot/servicenow-azure-sql#/policy/types/elasticPoolServiceNowConfigurationItemTableDefinition
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-sql#/policy/types/elasticPoolServiceNowTableDefinition 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 > SQL > Elastic Pool > ServiceNow > Table

Configure a Table for Azure > SQL > Elastic Pool resource type in ServiceNow via the Azure > SQL > Elastic Pool > ServiceNow > Table > * policies.

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

Azure > SQL > Elastic Pool > 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 > SQL > Elastic Pool data.

URI
tmod:@turbot/servicenow-azure-sql#/policy/types/elasticPoolServiceNowTableDefinition
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_sql_elasticpool",
"label": "Azure > SQL > Elastic Pool",
"extendsTable": "cmdb_ci"
},
"columns": [
{
"name": "elastic_pool_name",
"label": "Elastic Pool Name"
},
{
"name": "id",
"label": "ID"
},
{
"name": "region",
"label": "Region"
},
{
"name": "resource_group",
"label": "Resource Group",
"type": "string",
"size": 200
},
{
"name": "state",
"label": "State"
},
{
"name": "subscription_id",
"label": "Subscription ID"
},
{
"name": "tags",
"label": "Tags",
"type": "string",
"size": 1000
},
{
"name": "type",
"label": "Type"
},
{
"name": "zone_redundant",
"label": "Zone Redundant",
"type": "boolean"
}
]
}
}

Azure > SQL > Server > ServiceNow

URI
tmod:@turbot/servicenow-azure-sql#/policy/types/serverServiceNow
Targets

Azure > SQL > Server > ServiceNow > Configuration Item

Synchronize the data for the Azure > SQL > Server based on the policies Azure > SQL > Server > 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 > SQL > Server information within the ServiceNow CMDB.

URI
tmod:@turbot/servicenow-azure-sql#/policy/types/serverServiceNowConfigurationItem
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 > SQL > 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 > SQL > 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.

URI
tmod:@turbot/servicenow-azure-sql#/policy/types/serverServiceNowConfigurationItemRecord
Default Template Input
"{\n resource: server{\n data\n metadata\n turbot {\n akas\n id\n tags\n title\n }\n }\n}\n"
Default Template
"administrator_login: {{ $.resource.data.administratorLogin | dump | safe }}\nencryption_protector: {{ $.resource.data.encryptionProtector | dump | safe }}\nfirewall_rules: {{ $.resource.data.firewallRules | dump | safe }}\nfully_qualified_domain_name: {{ $.resource.data.fullyQualifiedDomainName | dump | safe }}\nid: {{ $.resource.data.id | dump | safe }}\nregion: {{ $.resource.data.location | dump | safe }}\nresource_group: {{ $.resource.metadata.azure.resourceGroupName | dump | safe }}\nserver_audit_policy: {{ $.resource.data.auditPolicy | dump | safe }}\nserver_azure_ad_administrator: {{ $.resource.data.serverAzureADAdministrator | dump | safe }}\nserver_name: {{ $.resource.data.name | dump | safe }}\nserver_security_alert_policy: {{ $.resource.data.serverSecurityAlertPolicy | dump | safe }}\nserver_vulnerability_assessment: {{ $.resource.data.serverVulnerabilityAssessment | dump | safe }}\nstate: {{ $.resource.data.state | dump | safe }}\nsubscription_id: {{ $.resource.metadata.azure.subscriptionId | dump | safe }}\ntags: {{ $.resource.turbot.tags | dump | safe }}\ntype: {{ $.resource.data.type | dump | safe }}\nversion: {{ $.resource.data.version | dump | safe }}\n"
Schema
{
"type": "object"
}

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.

URI
tmod:@turbot/servicenow-azure-sql#/policy/types/serverServiceNowConfigurationItemTableDefinition
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-sql#/policy/types/serverServiceNowTableDefinition 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 > SQL > Server > ServiceNow > Table

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

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

Azure > SQL > Server > 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 > SQL > Server data.

URI
tmod:@turbot/servicenow-azure-sql#/policy/types/serverServiceNowTableDefinition
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_sql_server",
"label": "Azure > SQL > Server",
"extendsTable": "cmdb_ci"
},
"columns": [
{
"name": "administrator_login",
"label": "Administrator Login"
},
{
"name": "encryption_protector",
"label": "Encryption Protector",
"type": "string",
"size": 1000
},
{
"name": "firewall_rules",
"label": "Firewall Rules",
"type": "string",
"size": 1000
},
{
"name": "fully_qualified_domain_name",
"label": "Fully Qualified Domain Name"
},
{
"name": "id",
"label": "ID"
},
{
"name": "region",
"label": "Region"
},
{
"name": "resource_group",
"label": "Resource Group",
"type": "string",
"size": 200
},
{
"name": "server_audit_policy",
"label": "Server Audit Policy",
"type": "string",
"size": 1000
},
{
"name": "server_azure_ad_administrator",
"label": "Server Azure AD Administrator",
"type": "string",
"size": 1000
},
{
"name": "server_name",
"label": "Server Name"
},
{
"name": "server_security_alert_policy",
"label": "Server Security Alert Policy",
"type": "string",
"size": 1000
},
{
"name": "server_vulnerability_assessment",
"label": "Server Vulnerability Assessment",
"type": "string",
"size": 1000
},
{
"name": "state",
"label": "State"
},
{
"name": "subscription_id",
"label": "Subscription ID"
},
{
"name": "tags",
"label": "Tags",
"type": "string",
"size": 1000
},
{
"name": "type",
"label": "Type"
},
{
"name": "version",
"label": "Version"
}
]
}
}