Policy types for @turbot/servicenow-azure-sql
- Azure > SQL > Database > ServiceNow
- Azure > SQL > Database > ServiceNow > Configuration Item
- Azure > SQL > Database > ServiceNow > Configuration Item > Record
- Azure > SQL > Database > ServiceNow > Configuration Item > Table Definition
- Azure > SQL > Database > ServiceNow > Table
- Azure > SQL > Database > ServiceNow > Table > Definition
- Azure > SQL > Elastic Pool > ServiceNow
- Azure > SQL > Elastic Pool > ServiceNow > Configuration Item
- Azure > SQL > Elastic Pool > ServiceNow > Configuration Item > Record
- Azure > SQL > Elastic Pool > ServiceNow > Configuration Item > Table Definition
- Azure > SQL > Elastic Pool > ServiceNow > Table
- Azure > SQL > Elastic Pool > ServiceNow > Table > Definition
- Azure > SQL > Server > ServiceNow
- Azure > SQL > Server > ServiceNow > Configuration Item
- Azure > SQL > Server > ServiceNow > Configuration Item > Record
- Azure > SQL > Server > ServiceNow > Configuration Item > Table Definition
- Azure > SQL > Server > ServiceNow > Table
- Azure > SQL > Server > ServiceNow > Table > Definition
Azure > SQL > Database > ServiceNow
tmod:@turbot/servicenow-azure-sql#/policy/types/databaseServiceNow
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.
tmod:@turbot/servicenow-azure-sql#/policy/types/databaseServiceNowConfigurationItem
[ "Skip", "Check: Archived", "Check: Deleted", "Check: Sync", "Enforce: Archived", "Enforce: Deleted", "Enforce: Sync", "Enforce: Sync, archive on delete"]
{ "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.
tmod:@turbot/servicenow-azure-sql#/policy/types/databaseServiceNowConfigurationItemRecord
"{\n resource: database{\n data\n metadata\n turbot {\n akas\n id\n tags\n title\n }\n }\n}\n"
"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"
{ "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.
tmod:@turbot/servicenow-azure-sql#/policy/types/databaseServiceNowConfigurationItemTableDefinition
[ "{\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"]
"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"
{ "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.
tmod:@turbot/servicenow-azure-sql#/policy/types/databaseServiceNowTable
[ "Skip", "Check: Configured", "Enforce: Configured"]
{ "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.
tmod:@turbot/servicenow-azure-sql#/policy/types/databaseServiceNowTableDefinition
{ "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
tmod:@turbot/servicenow-azure-sql#/policy/types/elasticPoolServiceNow
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.
tmod:@turbot/servicenow-azure-sql#/policy/types/elasticPoolServiceNowConfigurationItem
[ "Skip", "Check: Archived", "Check: Deleted", "Check: Sync", "Enforce: Archived", "Enforce: Deleted", "Enforce: Sync", "Enforce: Sync, archive on delete"]
{ "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.
tmod:@turbot/servicenow-azure-sql#/policy/types/elasticPoolServiceNowConfigurationItemRecord
"{\n resource: elasticPool{\n data\n metadata\n turbot {\n akas\n id\n tags\n title\n }\n }\n}\n"
"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"
{ "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.
tmod:@turbot/servicenow-azure-sql#/policy/types/elasticPoolServiceNowConfigurationItemTableDefinition
[ "{\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"]
"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"
{ "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.
tmod:@turbot/servicenow-azure-sql#/policy/types/elasticPoolServiceNowTable
[ "Skip", "Check: Configured", "Enforce: Configured"]
{ "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.
tmod:@turbot/servicenow-azure-sql#/policy/types/elasticPoolServiceNowTableDefinition
{ "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
tmod:@turbot/servicenow-azure-sql#/policy/types/serverServiceNow
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.
tmod:@turbot/servicenow-azure-sql#/policy/types/serverServiceNowConfigurationItem
[ "Skip", "Check: Archived", "Check: Deleted", "Check: Sync", "Enforce: Archived", "Enforce: Deleted", "Enforce: Sync", "Enforce: Sync, archive on delete"]
{ "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.
tmod:@turbot/servicenow-azure-sql#/policy/types/serverServiceNowConfigurationItemRecord
"{\n resource: server{\n data\n metadata\n turbot {\n akas\n id\n tags\n title\n }\n }\n}\n"
"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"
{ "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.
tmod:@turbot/servicenow-azure-sql#/policy/types/serverServiceNowConfigurationItemTableDefinition
[ "{\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"]
"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"
{ "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.
tmod:@turbot/servicenow-azure-sql#/policy/types/serverServiceNowTable
[ "Skip", "Check: Configured", "Enforce: Configured"]
{ "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.
tmod:@turbot/servicenow-azure-sql#/policy/types/serverServiceNowTableDefinition
{ "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" } ] }}