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

Application admin or System administrator

x_vmw_cloudservice.Request re-trigger turnstile activity sys_id

Add Request re-trigger turnstile activity sys_id

Application admin or 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.

Application admin or System administrator

x_vmw_cloudservice.TimetoRe-TriggerCatalogRequest

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

Application admin or 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.

Application admin or System administrator

x_vmw_cloudservice.vRA Servicenow UI

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

Application admin or System administrator

x_vmw_cloudservice.deploymentCategory

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

Application admin or System administrator

x_vmw_cloudservice.machineCategory

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

Application admin or 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.

Application admin or 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.

Application admin or System administrator

x_vmw_cloudservice.deploymentActionDeployment

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

Application admin or System administrator

x_vmw_cloudservice.cas_valuepicker_ui_macro_sysid

This property contains default sysId of the UI Macro CAS_Valuepicker_UI_Macro.

Application admin or System administrator

x_vmw_cloudservice.cas_valuepicker_widget_sysid

This property contains default sysId of the widget CAS_SP_valuePicker.

Application admin or System administrator

x_vmw_cloudservice.apiPageSize

The default value is 200. You can reduce the default value. vRA API supports pagination a maximum of 200 pages only.

System administrator

x_vmw_cloudservice.vRAThread

The default value is 8 and can be configured based on the requirements. Ensure that the utilization is 50% usage of the threads configured in the system property. The utilization can go up to 100%. Specified threads will be used to process the job queue (data parsing).

System administrator

x_vmw_cloudservice.API Timeout

The default value is 8000 milliseconds. Sets API call timeout. All API calls wait for the provided time (in milliseconds) to receive the response.

System administrator

x_vmw_cloudservice.catalogLoader

System property checks for the value. If the value is set to true, the loader displays. For false, the loader is not displayed. The loader is displayed only on Catalog items during form load.

System administrator

vRA ITSM application admin-user

Responsible for all administrative tasks including application configuration, end-point registration, user entitlement management, and so on.

  • catalog_admin

  • agent_admin

  • x_vmw_cloudservice.vra_catalog_admin

  • x_vmw_cloudservice.vra_end_user

  • cmdb_read

vRA ITSM application end user

Uses the VMware vRealize Automation Service Portal or User Portal in ServiceNow.

  • x_vmw_cloudservice.vra_end_user

  • cmdb_read

vRA ITSM application approver user

Approves or rejects the catalog item requests.

  • x_vmw_cloudservice.vra_end_user

  • cmdb_read

  • approver_user