Policy: Azure > SQL Virtual Machine Service > SQL Virtual Machine > 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 Virtual Machine Service > SQL Virtual Machine data.

Targets

This policy targets the following resource types:

ServiceNow > Instance

Primary Policy

This policy is used with the following primary policy:

Azure > SQL Virtual Machine Service > SQL Virtual Machine > ServiceNow > Table

Controls

Setting this policy configures this control:

Azure > SQL Virtual Machine Service > SQL Virtual Machine > ServiceNow > Table

Policy Specification

Schema Type	`object`
Default	table: name: guardrails_azure_sqlvirtualmachine_sqlvirtualmachine label: Azure > SQL Virtual Machine Service > SQL Virtual Machine extendsTable: cmdb_ci columns: - name: auto_backup_settings label: Auto Backup Settings type: string size: 1000 - name: auto_patching_settings label: Auto Patching Settings type: string size: 1000 - name: cloud_environment label: Cloud Environment - name: id label: ID - name: identity label: Identity type: string size: 1000 - name: key_vault_credential_settings label: Key Vault Credential Settings type: string size: 1000 - name: provisioning_state label: Provisioning State - name: region label: Region - name: region_name label: Region Name type: string size: 200 - name: resource_group label: Resource Group type: string - name: server_configurations_management_settings label: Server Configurations Management Settings type: string size: 1000 - name: sql_image_offer label: SQL Image Offer - name: sql_image_sku label: SQL Image Sku - name: sql_management label: SQL Management - name: sql_server_license_type label: SQL Server License Type - name: sql_virtual_machine_group_resource_id label: SQL Virtual Machine Group Resource ID - name: sql_virtualm_machine_name label: Name - name: storage_configuration_settings label: Storage Configuration Settings type: string size: 1000 - name: subscription_id label: Subscription ID type: string - name: tags label: Tags type: string size: 1000 - name: type label: Type - name: virtual_machine_resource_id label: Virtual Machine Resource ID - name: wsfc_domain_credentials label: Wsfc Domain Credentials type: string size: 1000

Schema Type

object

Default

table:
  name: guardrails_azure_sqlvirtualmachine_sqlvirtualmachine
  label: Azure > SQL Virtual Machine Service > SQL Virtual Machine
  extendsTable: cmdb_ci
columns:
  - name: auto_backup_settings
    label: Auto Backup Settings
    type: string
    size: 1000
  - name: auto_patching_settings
    label: Auto Patching Settings
    type: string
    size: 1000
  - name: cloud_environment
    label: Cloud Environment
  - name: id
    label: ID
  - name: identity
    label: Identity
    type: string
    size: 1000
  - name: key_vault_credential_settings
    label: Key Vault Credential Settings
    type: string
    size: 1000
  - name: provisioning_state
    label: Provisioning State
  - name: region
    label: Region
  - name: region_name
    label: Region Name
    type: string
    size: 200
  - name: resource_group
    label: Resource Group
    type: string
  - name: server_configurations_management_settings
    label: Server Configurations Management Settings
    type: string
    size: 1000
  - name: sql_image_offer
    label: SQL Image Offer
  - name: sql_image_sku
    label: SQL Image Sku
  - name: sql_management
    label: SQL Management
  - name: sql_server_license_type
    label: SQL Server License Type
  - name: sql_virtual_machine_group_resource_id
    label: SQL Virtual Machine Group Resource ID
  - name: sql_virtualm_machine_name
    label: Name
  - name: storage_configuration_settings
    label: Storage Configuration Settings
    type: string
    size: 1000
  - name: subscription_id
    label: Subscription ID
    type: string
  - name: tags
    label: Tags
    type: string
    size: 1000
  - name: type
    label: Type
  - name: virtual_machine_resource_id
    label: Virtual Machine Resource ID
  - name: wsfc_domain_credentials
    label: Wsfc Domain Credentials
    type: string
    size: 1000

In Your Workspace

Policy Settings by Type report

Developers

Category URI

tmod:@turbot/turbot#/control/categories/cloudIntegration

Policy Type URI

tmod:@turbot/servicenow-azure-sqlvirtualmachine#/policy/types/sqlVirtualMachineServiceNowTableDefinition

GraphQL

query policyType(id: "tmod:@turbot/servicenow-azure-sqlvirtualmachine#/policy/types/sqlVirtualMachineServiceNowTableDefinition") { … }

query policySettings(filter: "policyTypeId:'tmod:@turbot/servicenow-azure-sqlvirtualmachine#/policy/types/sqlVirtualMachineServiceNowTableDefinition'") { … }

query policyValues(filter: "policyTypeId:'tmod:@turbot/servicenow-azure-sqlvirtualmachine#/policy/types/sqlVirtualMachineServiceNowTableDefinition'") { … }

CLI

Get Policy Type

turbot graphql policy-type --id "tmod:@turbot/servicenow-azure-sqlvirtualmachine#/policy/types/sqlVirtualMachineServiceNowTableDefinition"

Get Policy Settings

turbot graphql policy-settings --filter "policyTypeId:tmod:@turbot/servicenow-azure-sqlvirtualmachine#/policy/types/sqlVirtualMachineServiceNowTableDefinition"

Policy Specification

Schema Type	`object`
Default	table: name: guardrails_azure_sqlvirtualmachine_sqlvirtualmachine label: Azure > SQL Virtual Machine Service > SQL Virtual Machine extendsTable: cmdb_ci columns: - name: auto_backup_settings label: Auto Backup Settings type: string size: 1000 - name: auto_patching_settings label: Auto Patching Settings type: string size: 1000 - name: cloud_environment label: Cloud Environment - name: id label: ID - name: identity label: Identity type: string size: 1000 - name: key_vault_credential_settings label: Key Vault Credential Settings type: string size: 1000 - name: provisioning_state label: Provisioning State - name: region label: Region - name: region_name label: Region Name type: string size: 200 - name: resource_group label: Resource Group type: string - name: server_configurations_management_settings label: Server Configurations Management Settings type: string size: 1000 - name: sql_image_offer label: SQL Image Offer - name: sql_image_sku label: SQL Image Sku - name: sql_management label: SQL Management - name: sql_server_license_type label: SQL Server License Type - name: sql_virtual_machine_group_resource_id label: SQL Virtual Machine Group Resource ID - name: sql_virtualm_machine_name label: Name - name: storage_configuration_settings label: Storage Configuration Settings type: string size: 1000 - name: subscription_id label: Subscription ID type: string - name: tags label: Tags type: string size: 1000 - name: type label: Type - name: virtual_machine_resource_id label: Virtual Machine Resource ID - name: wsfc_domain_credentials label: Wsfc Domain Credentials type: string size: 1000

Schema Type

object

Default

table:
  name: guardrails_azure_sqlvirtualmachine_sqlvirtualmachine
  label: Azure > SQL Virtual Machine Service > SQL Virtual Machine
  extendsTable: cmdb_ci
columns:
  - name: auto_backup_settings
    label: Auto Backup Settings
    type: string
    size: 1000
  - name: auto_patching_settings
    label: Auto Patching Settings
    type: string
    size: 1000
  - name: cloud_environment
    label: Cloud Environment
  - name: id
    label: ID
  - name: identity
    label: Identity
    type: string
    size: 1000
  - name: key_vault_credential_settings
    label: Key Vault Credential Settings
    type: string
    size: 1000
  - name: provisioning_state
    label: Provisioning State
  - name: region
    label: Region
  - name: region_name
    label: Region Name
    type: string
    size: 200
  - name: resource_group
    label: Resource Group
    type: string
  - name: server_configurations_management_settings
    label: Server Configurations Management Settings
    type: string
    size: 1000
  - name: sql_image_offer
    label: SQL Image Offer
  - name: sql_image_sku
    label: SQL Image Sku
  - name: sql_management
    label: SQL Management
  - name: sql_server_license_type
    label: SQL Server License Type
  - name: sql_virtual_machine_group_resource_id
    label: SQL Virtual Machine Group Resource ID
  - name: sql_virtualm_machine_name
    label: Name
  - name: storage_configuration_settings
    label: Storage Configuration Settings
    type: string
    size: 1000
  - name: subscription_id
    label: Subscription ID
    type: string
  - name: tags
    label: Tags
    type: string
    size: 1000
  - name: type
    label: Type
  - name: virtual_machine_resource_id
    label: Virtual Machine Resource ID
  - name: wsfc_domain_credentials
    label: Wsfc Domain Credentials
    type: string
    size: 1000