Appendix

This chapter contains a list of the available custom tables, CMDB tables, and system properties used in
.

ServiceNow Custom Table used 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

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

The catalog admin or system administrator of
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
.
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
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
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.
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
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
.
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
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