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

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

These custom tables are used in ServiceNow.

Label

Name

Extended Table

Project

x_vmw_cloudservice_cas_project

Category

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

Day-2 Actions

x_vmw_cloudservice_vra_cloud_actions

ServiceNow CMDB Tables in VMware vRealize Automation ITSM Application for ServiceNow

These custom tables are used in ServiceNow.

Table

Custom Field

Label

x_vmw_cloudservice_deployments

  • blueprint_version

  • bluprint_id

  • code

  • deployment_id

  • last_update_time

  • project_id

  • catalog_id

  • organization_id

  • catalog_version

  • operational_status

  • servicenow_owner

  • Shared_groups

  • vra_owner

  • entitled_users

  • unit

  • created_at

  • expired

  • expires_on

  • last_updated_at

  • last_updated_by

  • stimulated

  • u_catalog_item

  • u_project

  • Blueprint Version

  • Bluprint Id

  • Code

  • Deployment Id

  • Last Update Time

  • Project Id

  • Catalog Id

  • 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

  • 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

  • port

  • protocol

  • project

  • storage

  • syncstatus

  • status

  • vra_owner

  • resource_name

  • encrypted

  • attachment_status

  • address

  • endpointtype

  • account

  • volumetype

  • node_uuid

  • environment

  • 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

  • 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

  • CreatedAt

  • DeploymentId

  • Entitled Users

  • Instance Protocol

  • Instance Port

  • Resource Id

  • Resource Name

  • Name

  • Memory(MB)

  • Network Schema

  • Operational status

  • Port

  • Protocol

  • Project

  • Storage Schema

  • SyncStatus

  • Status

  • vRA Owner

  • Resource Name

  • Encrypted

  • Attachment status

  • Address

  • endpointType

  • Account

  • volumeType

  • Node UUID

  • Environment

  • 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 ITSM Application for ServiceNow

The catalog admin or system administrator of VMware vRealize Automation ITSM Application for ServiceNow 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 ITSM Application for ServiceNow.

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 ITSM Application for ServiceNow 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 set parent category of Deployment day 2 Action Catalog Items.

Application admin or System administrator

x_vmw_cloudservice.machineCategory

Allows you 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 needs 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. The 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 and resources available on ServiceNow. Specified threads will be used to process the job queue (data parsing). You need to set an appropriate value to the system property ensuring that not all ServiceNow worker threads are utilized for processing the job queue.

Note: if ServiceNow instance has 8 threads, then make sure you set the system property value as 4 to restrict the threads utilization to 50%.

System administrator

x_vmw_cloudservice.vRAThreadUsed_Maximum

The default value is 16 and can be configured based on the requirements and resources available on ServiceNow instance. This property allows you to dedicate maximum ServiceNow threads towards importing the data into ServiceNow. The scheduled job “vRA Thread Limit Maximum” will set the value of “x_vmw_cloudservice.vRAThreadUsed_Maximum” to system property “x_vmw_cloudservice.vRAThread” when the system is under less load.

Note Ensure that the maximum value set to the system property should be equal to or less than the number of worker threads available on the ServiceNow instance. Also setting this system property with the number of worker threads available on the ServiceNow instance will impact other ServiceNow operations too.

Application admin or System administrator

x_vmw_cloudservice.vRAThreadUsed_Minimum

The default value is 8 and can be configured based on the requirements and resources available on ServiceNow instance. This property allows you to dedicate minimum ServiceNow threads towards importing the data into ServiceNow. The scheduled job “vRA Thread Limit Minimum” will set the value of “x_vmw_cloudservice.vRAThreadUsed_Minimum” to system property “x_vmw_cloudservice.vRAThread” when the system is under normal load.

Note: The value set to the system property allows the number of threads for VMware vRealize Automation ITSM application for ServiceNow data import. Make sure you set the system property with the proper value so that ServiceNow instance can have sufficient worker threads to utilize for other operations that are not under the VMware vRealize Automation ITSM application for ServiceNow.

Application admin or System administrator

x_vmw_cloudservice.API Timeout

The default value is 60000 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

x_vmw_cloudservice.telemetry_last_trigger

This system property stores the Date and Time when the user responds to the consent pop-up when triggered for telemetry data collection from VMware vRealize Automation ITSM Application for ServiceNow to VMware.

System administrator

x_vmw_cloudservice.customer_consent_value

This system property value will be populated based on the user response to telemetry data collection. If the user responds to the telemetry pop-up as “Yes”, the system property value will be true. If the user responds to the telemetry pop-up as “No”, the system property value will be false.

System administrator

x_vmw_cloudservice.telemetry_consent_provided_user

This system property stores the sys id of the user who provides consent for the telemetry data collection.

System administrator

x_vmw_cloudservice.telemetry_Collector_Url

This system property describes the URL for telemetry data collection.

System administrator

x_vmw_cloudservice.telemetry_collector_id

This system property represents the Collector ID for telemetry data collection.

System administrator

x_vmw_cloudservice.consent_request_trigger_gap

This system property defines after how many days the consent pop-up should be displayed again on the Manage Endpoint if the user has provided consent as No for the last telemetry pop-up.

System administrator