Installing the ZenGRC Application in ServiceNow

Overview

The ServiceNow connector requires the installation of an application in the ServiceNow environment. This should be done prior to connecting your ZenGRC instance to ServiceNow.

There are two necessary actions for the installation that are outlined in this documentation. They include the following:

• Adding the ZenGRC Request Table to the ServiceNow Database.

• Configuring the ZenGRC Request Application in ServiceNow.

Adding the ZenGRC Request Table to the ServiceNow Database

Add a new table, called ZenGRC Request, to the ServiceNow database by completing the following steps.

1. Log into ServiceNow.

2. In the left-hand menu, click Scripts - Background. It may be easier to find by using the Filter navigator as shown below:
   
   

   
   
   

3. Copy and paste the following script into the Run Script (Javascript executed on server) field in ServiceNow and click Run Script.
   
   

   // Version 0.4
   // Copy and paste into ServiceNow 
   var table_name = 'zengrc_requests', extends_table = 'task', auditId = 'audit_id', auditTitle = 'audit_title';
   var attrs = new Packages.java.util.HashMap();
   // Audit ID
   var ai = new GlideColumnAttributes(auditId);
   ai.setType("string");
   ai.setUsePrefix(false);
   attrs.put(auditId, ai);
   // Audit Title
   var at = new GlideColumnAttributes(auditTitle);
   at.setType("string");
   at.setUsePrefix(false);
   attrs.put(auditTitle, at);
   
   
   var tc = new GlideTableCreator(table_name , table_name);
   tc.setColumnAttributes(attrs);
   if(typeof extends_table != 'undefined') tc.setExtends(extends_table);
   tc.update();
   // Create Customs ZenGRC states
   var newCh = new GlideRecord('sys_choice');
   newCh.newRecord();
   newCh.name = 'zengrc_requests';
   newCh.element = 'state';
   newCh.label = 'Pending';
   newCh.value = 10;
   newCh.insert();
   newCh.label = 'Work in Progress';
   newCh.value = 20;
   newCh.insert();
   newCh.label = 'Closed Complete';
   newCh.value = 30;
   newCh.insert();

Configuring the ZenGRC Application in ServiceNow

Next, tailor the look-and-feel of the ZenGRC Request application in ServiceNow (e.g. the task card view, the left-hand-side link, the unique numbering schema, etc.) by adding configuration elements as follows:

1. Download this XML for ServiceNow and place it in a memorable place on your computer.

2. In ServiceNow, click Update Sets to Commit in the left-hand menu.

3. Click Import Update Set from XML.
   
   
   
   

4. In Step 1, click Choose File and select the XML file you saved in the first step of these instructions.
5. In Step 2, click Upload. A new row, called ZenGRC, is added for the update set.
6. Click the ZenGRC link in the Name column.
   
   
   
   
7. Click Preview Update Set.
   
   
   
   
8. When the update is complete, click Close to close the dialog box.
9. Click Commit Update Set.