Purpose/Use Case

To update the ServiceNow Virtual Machine Instance with the vRA Request ID with SovLabs ServiceNow CMDB

Supported Versions

All

Pre-requisites

1. Basic knowledge and setup of SovLabs ServiceNow CMDB module
2. Basic knowledge and setup of SovLabs ServiceNow Connector
3. Access to SerivceNow instance with "admin" level permissions
4. Access to VMware's vRealize Automation tenant with SovLabs SA account permissions

Solution

Add Column to cmdb_ci Table

1. Login with admin level permissions to the ServiceNow Instance
2. Navigate to System Definition > Tables
3. Search for Table Name: cmdb_ci
4. Click on Configuration Item label to edit
5. Click on New on Columns tab > Table Columns
6. Fill out New Record > Dictionary Entry for Configuration Item Table
   1. Type: String
   2. Column label: vRA Request ID
      1. Note: This is a suggested Column label
   3. Column name: auto-populates to u_vra_request_id
      1. Note: Copy the Column name value for safe-keeping.  This will be used later on
   4. Max length: 120
   5. Display: true
7. Click Submit

Fig 1: Edit cmdb_ci System Definition Table

Fig 2: Add new table column to cmdb_ci System Definition Table

Fig 3: Create vRA Request ID Column

Create and/or Update SovLabs ServiceNow CMDB

1. Login to the vRA tenant
2. Create ServiceNow CMDB Configuration
   1. Pre-req: ServiceNow Endpoint
   2. Catalog > Add ServiceNow CMDB Configuration - SovLabs Modules
3. Update ServiceNow CMDB Configuration
   1. Deployments > Filters: All owners and SovLabs ServiceNow CMDB
   2. Actions > Update ServiceNow CMDB Configuration
4. Update the JSON template in the ServiceNow CMDB Configuration (either existing or new)
   1. Add in the appropriate column name (e.g. u_vra_request_id) with the value {{ __Cafe.Root.Request.Id }}
      1. Example:
         1. "u_vra_request_id": "{{ __Cafe.Root.Request.Id }}"
   2. Please make sure that the JSON is valid
5. Click Submit

By correlating the vRA VM Property __Cafe.Root.Request.Id to the appropriate column name in ServiceNow, it will populate the column with the vRA Request ID

Fig 4: Add ServiceNow CMDB Configuration

Fig 5: Update ServiceNow CMDB Configuration

Fig 6: Update JSON Template by adding new lines to associate Table Column to vRA Request ID

Result