This chapter contains the list the available custom tables, CMDB tables, and system properties used in the VMware vRealize Automation for ServiceNow ITSM application.

ServiceNow Custom Table used in VMware vRealize Automation for ServiceNow ITSM Application

These custom tables are used in the ServiceNow.

Label

Name

Extended Table

Project

x_vmw_cloudservice_cas_project

Categories

Catalog Items

x_vmw_cloudservice_cas_catalog_items

Catalog Item

Deployments

x_vmw_cloudservice_deployments

Application

Resources

x_vmw_cloudservice_machines

Virtual Machine Instance

Deployments Import Set

x_vmw_cloudservice_vra_deployments_import_set

Import Set Row

Resources Import Set

x_vmw_cloudservice_vra_machines_import_set

Import Set Row

Job Queue

x_vmw_cloudservice_cas_queue

Manage Endpoints

x_vmw_cloudservice_register_cas_organization

Manage Entitlements

x_vmw_cloudservice_cas_catalog_entitlement

Shared Resource

x_vmw_cloudservice_shared_resources

Day-2 Actions

x_vmw_cloudservice_vra_cloud_actions

Day-2 Action Request

x_vmw_cloudservice_vra_action_request

Day-2 Actions Entitlements

x_vmw_cloudservice_day_2_action_request_entitlement

ServiceNow CMDB Tables in VMware vRealize Automation for ServiceNow ITSM Application

These custom tables are used in the ServiceNow.

Table

Custom Field

Label

x_vmw_cloudservice_deployments

  • blueprint_version

  • bluprint_id

  • code

  • deployment_id

  • last_update_time

  • message name

  • project_id

  • catalog_id

  • hostname

  • organization_id

  • catalog_version

  • operational_status

  • servicenow_owner

  • entitled_groups

  • vra_owner

  • entitled_users

  • unit

  • created_at

  • expired

  • expires_on

  • last_updated_at

  • last_updated_by

  • message status

  • stimulated

  • u_catalog_item

  • u_project

  • Blueprint Version

  • Bluprint Id

  • Code

  • Deployment Id

  • Last Update Time

  • Message Name

  • Project Id

  • Catalog Id

  • Host Url

  • Organization Id

  • Catalog Version

  • Operational status

  • ServiceNow Owner

  • Entitled Groups

  • vRA Owner

  • Entitled Users

  • Unit

  • Created At

  • Expired

  • Expires On

  • Last Updated At

  • Last Updated by

  • Message Status

  • Stimulated

  • Catalog Item

  • Project

x_vmw_cloudservice_machines

  • createdat

  • deploymentid

  • entitled_users

  • instance_protocol

  • instance_port

  • machine_id

  • machine_name

  • name

  • memory

  • network_schema

  • operational_status

  • organization_id

  • port

  • protocol

  • project

  • storage

  • sync_status

  • status

  • vra_owner

  • resource_name

  • encrypted

  • attachment_status

  • address

  • endpointtype

  • account

  • volumetype

  • node_uuid

  • enviornment

  • workflow_name

  • started_on

  • id

  • account_region

  • network_type

  • network

  • internet_facing

  • capacity_gb

  • zone

  • region

  • externallink

  • role

  • workflow_id

  • workflow_run_id

  • completed_on

  • u_type

  • stack_name

  • custom_properties_schema

  • servicenow_owner

  • shared_groups

  • inputs

  • outputs

  • resources

  • host_schema

  • attached_disks

  • computehostref

  • computehostType

  • count

  • countIndex

  • cpucount

  • deployment_sys

  • environment

  • flavor

  • flavorref

  • hassnapshots

  • image

  • os_type

  • outputs

  • primarymac

  • resourcepool

  • routes_schema

  • softwareName

  • Status

  • CreatedAt

  • DeploymentId

  • Entitled Users

  • Instance Protocol

  • Instance Port

  • Resource Id

  • Resource Name

  • Name

  • Memory(MB)

  • Network Schema

  • Operational status

  • Organization Id

  • Port

  • Protocol

  • Project

  • Storage Schema

  • SyncStatus

  • Status

  • vRA Owner

  • Resource Name

  • Encrypted

  • Attachment status

  • Address

  • endpointType

  • Account

  • volumeType

  • Node UUID

  • Enviornment

  • Workflow name

  • Started on

  • Id

  • Account/Region

  • Network Type

  • Network

  • Internet facing

  • Capacity(GB)

  • Availability Zone

  • Region

  • externalLink

  • Role

  • Workflow ID

  • Workflow run ID

  • Completed on

  • Type

  • Stack Name

  • Custom Properties Schema

  • ServiceNow Owner

  • Entitled Groups

  • Inputs

  • Outputs

  • Resources

  • Host Schema

  • attached Disks

  • computeHostRef

  • computeHostType

  • Count

  • countindex

  • cpuCount

  • Deployment Sys

  • Environment

  • Flavor

  • flavorRef

  • hasSnapshots

  • Image

  • OS Type

  • Outputs

  • primaryMAC

  • resourcePool

  • Routes Schema

  • softwarename

  • status

System Properties in VMware vRealize Automation for ServiceNow ITSM Application

The catalog admin or system administrator of VMware vRealize Automation for ServiceNow ITSM application can update the system properties:

System Properties

Description

Updated by

x_vmw_cloudservice.cancelCatalogRequest

Update the value in hours to cancel the catalog request if mid server is down.

Application admin or system administrator

x_vmw_cloudservice.CAS.log.header

Contains header for the log file.

Application admin or system administrator

x_vmw_cloudservice.CAS.logging.verbosity

Contains log verbosity for the VMware vRealize Automation for ServiceNow ITSM application.

Application admin or system administrator

x_vmw_cloudservice.cloud_API_endpoint_URL

The API URL for different geographical locations can be different.

Application admin or system administrator

x_vmw_cloudservice.Request Iteration turnstile activity sys_id

Add Request Iteration turnstile activity sys_id

System administrator

x_vmw_cloudservice.Request re-trigger turnstile activity sys_id

Add Request re-trigger turnstile activity sys_id

System administrator

x_vmw_cloudservice.Request re-trigger turnstile activity sys_id

Create the support group for the VMware vRealize Automation for ServiceNow ITSM application when an incident is created from RITM assign it to them.

System administrator

x_vmw_cloudservice.TimetoRe-TriggerCatalogRequest

Time in minutes to retrigger the catalog request if the MID server is down.

System administrator

x_vmw_cloudservice.vra_itsm_application_version

Version of the VMware vRealize Automation for ServiceNow ITSM application.

Application admin or system administrator

x_vmw_cloudservice.vRealizeAutomation-ApprovalGroup

Contains the name for the Approval group.

Application admin or system administrator

x_vmw_cloudservice.SetApiVersionDate

Allows you to lock the API at a given point in time and control when you upgrade to a new API version. Update the API version date in the yyyy-mm-dd format. For example: 2019-01-15.

Application admin or system administrator

x_vmw_cloudservice.deploymentWindowSize

Allows you to update the number of Deployments in Deployment List Widget of the Service Portal. The default value is 20.

Application admin or system administrator

x_vmw_cloudservice.DeploymentLimit

Allows you to update the number of Deployments in the Deployment Widget of the Service Portal. The default value is 5.

Application admin or system administrator

x_vmw_cloudservice.servicePortalPrefix

Allows you to update the customized Service Portal prefix. The default value is sp.

System administrator

x_vmw_cloudservice.vRA Servicenow UI

Allows you to select the choices to see UI specific Module in Servicenow.

System administrator

x_vmw_cloudservice.deploymentCategory

Allows you to to set parent category of Deployment day 2 Action Catalog Items.

System administrator

x_vmw_cloudservice.machineCategory

Allows you to to set parent category of Resource day 2 Action Catalog Items.

System administrator

x_vmw_cloudservice.vra_parent_category

It contains the sys_id of the category for Service Portal. User need to update the sys_id of category in use or sys_id category created.

System administrator

x_vmw_cloudservice.apiPageSize

This system property is used to set the page size of the API call to retrieve records from vRA. Default value for the page size is 20

Application admin or system administrator

x_vmw_cloudservice.resourceActionResource

This system property contains the deployment field sysId of the Resource Day2 Action.

System administrator

x_vmw_cloudservice.deploymentActionDeployment

This system property contains the deployment field sys Id of the Deployment Day2 Action.

System administrator

x_vmw_cloudservice.cas_valuepicker_ui_macro_sysid

This property contains default sysId of the UI Macro CAS_Valuepicker_UI_Macro.

System administrator

x_vmw_cloudservice.cas_valuepicker_widget_sysid

This property contains default sysId of the widget CAS_SP_valuePicker.

System administrator