This chapter contains a list of the available custom tables, CMDB tables, and system properties used in VMware Aria Automation Plug-in.

ServiceNow Custom Table used in VMware Aria Automation Plug-in

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 Aria Automation Plug-in

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

  • vra_requester

  • 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

  • Owner

  • Requester

  • 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

  • vra_requester

  • 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

  • Owner

  • Requester

  • 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 Aria Automation Plug-in

The catalog admin or system administrator of VMware Aria Automation Plug-in 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.

Plug-in admin or System administrator

x_vmw_cloudservice.CAS.log.header

Contains header for the log file.

Plug-in admin or System administrator

x_vmw_cloudservice.CAS.logging.verbosity

Contains log verbosity for the VMware Aria Automation Plug-in.

Plug-in admin or System administrator

x_vmw_cloudservice.cloud_API_endpoint_URL

The API URL for different geographical locations can be different.

Plug-in admin or System administrator

x_vmw_cloudservice.Request Iteration turnstile activity sys_id

This system property allows you to add Request Iteration turnstile activity sys_id

Plug-in admin or System administrator

x_vmw_cloudservice.Request re-trigger turnstile activity sys_id

This system property allows you to add Request re-trigger turnstile activity sys_id

Plug-in admin or System administrator

x_vmw_cloudservice.Request re-trigger turnstile activity sys_id

Create the support group for the VMware Aria Automation Plug-in when an incident is created from RITM assign it to them.

Plug-in admin or System administrator

x_vmw_cloudservice.TimetoRe-TriggerCatalogRequest

This system property allows you to update time in minutes to retrigger the catalog request if the MID server is down. The system resends the request untill the requests is successfully submitted to the VMware Aria Automation.

Plug-in admin or System administrator

x_vmw_cloudservice.itsm_application_version

Version of the VMware Aria Automation Plug-in

Plug-in admin or System administrator

x_vmw_cloudservice.Automation-ApprovalGroup

This system property has a default value as Automation-ApprovalGroup. It allows you to add multiple approval group names.

Plug-in 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.

Plug-in admin or System administrator

x_vmw_cloudservice.deploymentWindowSize

This system property allows you to update the number of Deployments in the Deployment List Widget of the Service Portal. The default value is 20.

Plug-in admin or System administrator

x_vmw_cloudservice.DeploymentLimit

This system property allows you to update the number of Deployments in the Deployment Widget of the Service Portal. The default value is 5.

Plug-in admin or System administrator

x_vmw_cloudservice.servicePortalPrefix

This system property allows you to update the customized Service Portal prefix. The default value is sp.

Plug-in admin or System administrator

x_vmw_cloudservice.Servicenow UI

This system property allows you to select the choices to see UI specific Module in ServiceNow.

Plug-in admin or System administrator

x_vmw_cloudservice.deploymentCategory

This system property allows you to set parent category of Deployment day 2 Action Catalog Items.

Plug-in admin or System administrator

x_vmw_cloudservice.machineCategory

This system property allows you to set the parent category of Resource day-2 Action Catalog Items.

Plug-in admin or System administrator

x_vmw_cloudservice.parent_category

It contains the sys_id of the category for Service Portal. The user needs to update the sys_id of category in use or sys_id category created.

Plug-in 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 VMware Aria Automation. The default value for the page size is 20.

Plug-in admin or System administrator

x_vmw_cloudservice.resourceActionResource

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

Plug-in admin or System administrator

x_vmw_cloudservice.deploymentActionDeployment

This system property contains the deployment field sys Id of the Deployment Day-2 Action.

Plug-in admin or System administrator

x_vmw_cloudservice.cas_valuepicker_ui_macro_sysid

This property contains the default sysId of the UI Macro CAS_Valuepicker_UI_Macro.

Plug-in admin or System administrator

x_vmw_cloudservice.cas_valuepicker_widget_sysid

This property contains the default sysId of the widget CAS_SP_valuePicker.

Plug-in admin or System administrator

x_vmw_cloudservice.apiPageSize

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

System administrator

x_vmw_cloudservice.ThreadUsed

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 usage to 50%.

System administrator

x_vmw_cloudservice.ThreadUsed_Maximum

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

Note:

Ensure that the maximum value set to the system property must 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.

Plug-in admin or System administrator

x_vmw_cloudservice.ThreadUsed_Minimum

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

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

Plug-in 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 Aria Automation Plug-in 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 must be displayed again on the Manage Endpoint if the user has provided consent as No for the last telemetry pop-up.

System administrator