> ## Knowledge Base Index
> Fetch the complete knowledge base index at: https://help.configbot.ai/sitemap.xml
> Use this file to discover available pages before exploring further.
> Pure-Markdown content can be obtained by appending a '.md' suffix to the content URLs listed in the sitemap (without the trailing slash).

# ConfigBot for ServiceNow - Certificates

The ConfigBot for ServiceNow - Certificate module supports ServiceNow certificate-based authentication data management by allowing users to reverse data related to CA Certificates and User Client Certificates from a ServiceNow instance. The module also supports Validation and Compare operations to verify configurations and identify differences across instances.

The following article explains how to use the Certificate module in ConfigBot to perform different operations. 

**Step 1: Log in to ConfigBot** 

Enter your username and password, then click Submit to access the portal. 

![](https://storage.crisp.chat/users/helpdesk/website/-/4/3/b/7/43b7e9fbd033000/image_yiuzr2.png)


**Step 2: Access the Certificate Module:** 

From the Home Screen, Navigate to Integration and click on the Certificate module tile. 


![](https://storage.crisp.chat/users/helpdesk/website/-/4/3/b/7/43b7e9fbd033000/image_mg6aw0.png)

**Step 3: Create a New Iteration:** 

Click the Add New Iteration button 

![](https://storage.crisp.chat/users/helpdesk/website/-/4/3/b/7/43b7e9fbd033000/image_19zo64q.png)

* Enter the Iteration Number 
* Select the Workspace or ADD NEW Workspace  
* Enter Host Address  
* Choose the Instance Type  
* Enter your Company ID and Username  
* Add a short Description  

![](https://storage.crisp.chat/users/helpdesk/website/-/4/3/b/7/43b7e9fbd033000/image_bdp4g2.png)

After filling in all details, click Submit to create your iteration. 

**Step 4: Set the Filter Configuration:** 

Once the iteration is created, open the workbook and navigate to Config Sheet and select filter type, as I have selected Fetch All filter type so it will fetch all records present in the instance.


![](https://storage.crisp.chat/users/helpdesk/website/-/4/3/b/7/43b7e9fbd033000/image_18lk55w.png)

You can also select other filters type   
* Fetch All: will fetched all the records from the instance  
* Fetch All, except these: will fetch all records except those that are mentioned in the next column.  
* Fetch Only: will fetch the records that are mentioned in the next column.  
* Fetch Active Only: will only fetch active records.  
* Fetch In Active Only: will only fetch inactive records.  
* Fetch By Query: will only fetch records that are associated with the query 

# Generate Workbook - Backfill Data from Instance.

**Step 1: Generate Workbook Intellisense:**

Once the iteration is created, and config filter criteria is set, click on the hamburger menu icon and select Generate workbook.


![](https://storage.crisp.chat/users/helpdesk/website/-/4/3/b/7/43b7e9fbd033000/image_o1ix7n.png)


In the pop-up window:  
* Enter your ServiceNow password  - in this example using certificate based login.
* Add any execution notes
* In Advanced Options, Select "Select All" checkbox. 
* Click Confirm and Start to process execution.


![](https://storage.crisp.chat/users/helpdesk/website/-/4/3/b/7/43b7e9fbd033000/image_oudk6b.png)

This step backfilled data from the ServiceNow instance into the respective sheets.

**Step 2: Review Results**

Once the status shows Complete, open the generated workbook, and navigate to each sheet to see the data backfilled successfully from the instance.


![](https://storage.crisp.chat/users/helpdesk/website/-/4/3/b/7/43b7e9fbd033000/image_1ax2c1w.png)
![](https://storage.crisp.chat/users/helpdesk/website/-/4/3/b/7/43b7e9fbd033000/image_1e85asb.png)
![](https://storage.crisp.chat/users/helpdesk/website/-/4/3/b/7/43b7e9fbd033000/image_1ssqhx1.png)

# **Validation (Validate Configuration Changes from the sheet):** 


**Step 1: Open the Generated workbook** 

Click on the sheet icon to open the generated workbook 


![](https://storage.crisp.chat/users/helpdesk/website/-/4/3/b/7/43b7e9fbd033000/image_oxdeaj.png)

**Step 2: Change the status to Pending**  

Navigate to the desired sheet for which you want to validate the data and change the Processing Status to “Pending” 


![](https://storage.crisp.chat/users/helpdesk/website/-/4/3/b/7/43b7e9fbd033000/image_prozsw.png)

**Step 3: Start Execution (Validation)** 

Once the Processing Status is set to Pending, close the workbook and navigate back to workspace 
Click on the hamburger menu icon and select “Request Reprocess”


![](https://storage.crisp.chat/users/helpdesk/website/-/4/3/b/7/43b7e9fbd033000/image_1b0qssv.png)

Click on the hamburger menu icon one more time and now select “Start Validation” 


![](https://storage.crisp.chat/users/helpdesk/website/-/4/3/b/7/43b7e9fbd033000/image_1e3gq6k.png)

**In the pop-up window:** 
* Enter your ServiceNow instance password. 
* Add any execution notes 
* Select the checkbox for the desired sheet 


![](https://storage.crisp.chat/users/helpdesk/website/-/4/3/b/7/43b7e9fbd033000/image_1yd9rjj.png)

Click Confirm and Start to start execution. 

**Step 4: Review Results:** 

Once the execution status changes to Complete, open the generated workbook. 

![](https://storage.crisp.chat/users/helpdesk/website/-/4/3/b/7/43b7e9fbd033000/image_1ln1jr2.png)
![](https://storage.crisp.chat/users/helpdesk/website/-/4/3/b/7/43b7e9fbd033000/image_mngcft.png)

You will notice highlights across multiple tabs: 
* Red Highlights → Indicate configuration differences between the values currently maintained in the sheet and those available in the ServiceNow instance. These highlights help identify areas where changes have been made or where the configurations are not aligned.	 
* Green Highlights → Indicate matching configuration values between the sheet and the ServiceNow instance, confirming that no configuration changes have been identified.


# Compare **(Compare Between Two Executions):** 

**Step 1: Should have two Generated Workbooks**   

Ensure that you have two workbooks generated.  

![](https://storage.crisp.chat/users/helpdesk/website/-/4/3/b/7/43b7e9fbd033000/image_1xafhd3.png)

**Step 2: To Start Compare Execution:** 

Once the iteration is created, click on the Hamburger Menu and select Request Reprocess. 


![](https://storage.crisp.chat/users/helpdesk/website/-/4/3/b/7/43b7e9fbd033000/image_mexkt5.png)

Click on the Hamburger Menu one more time and now select Generate Compare iteration.


![](https://storage.crisp.chat/users/helpdesk/website/-/4/3/b/7/43b7e9fbd033000/image_199i6pb.png)

**In the pop-up window:** 
* Select the iteration you want to compare against. 
* Click Confirm and Start to start the execution process. 


![](https://storage.crisp.chat/users/helpdesk/website/-/4/3/b/7/43b7e9fbd033000/image_p33224.png)

Once the status shows complete, open the workbook and navigate to each sheet to see the changes 


![](https://storage.crisp.chat/users/helpdesk/website/-/4/3/b/7/43b7e9fbd033000/image_80nr0x.png)
![](https://storage.crisp.chat/users/helpdesk/website/-/4/3/b/7/43b7e9fbd033000/image_mg22la.png)

You can notice highlights across multiple tabs: 
* Red Highlights – Indicate differences between the two iterations. 
* Green Highlights – Indicate matching values across both workbooks. 

These color-coded results allow you to instantly identify what has changed or remained consistent between the two ServiceNow instances. 

Or we can also Navigate to the “Compare Summary” Sheet, to find the differences 

![](https://storage.crisp.chat/users/helpdesk/website/-/4/3/b/7/43b7e9fbd033000/image_rcgu7z.png)


This Sheet provides a quick and reliable way to verify data consistency between executions. Instead of manually inspecting records, you can visualize differences and matches in a structured tabular form. 

Thank You.