ConfigBot for ServiceNow - Data Scrambling

The Intelligent Data Scrambler Module for ServiceNow is a configurable solution that safeguards sensitive information by allowing administrators to selectively scramble data across tables and query-based targeting records. It provides flexible field-level operations such as applying random or constant values, skipping specific fields, or clearing existing data. Designed for testing, development, and training environments, this module ensures data privacy while maintaining the integrity and usability of your instance.

For example, when a user selects the User (sys_user) table, the module automatically identifies all related fields such as Name, First Name, Last Name, Department, and more. Administrators can then choose to perform scrambling operations on specific fields or apply them to all fields, providing complete flexibility and control over how the data is anonymized. 

The following article explains how to use the Data Scramble Module in ConfigBot to perform operations.

Step 1: Log in to ConfigBot 

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

Step 2: Access Data Scrambling Module 

From the ConfigBot dashboard, navigate to the Scramble, and click on  Data Scramble module tile to open it. 

Step 3: Create new iteration 

Click the Add Iteration button 

• 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 Description   

Then click Submit to create the iteration. 

Step 4: Select Table, Select Fetch Type and Add Query: 

Open workbook by clicking on the sheet icon. 

Navigate to the Search Criteria sheet. As shown in the image below, select the User [sys_use r] table, set the Fetch Type to "Fetch by Query", and enter the required query conditions in the Value column 

• Table: Select the target table containing the data you want to scramble. 
• Fetch Type: Choose a retrieval method to filter and pull records from the selected table. 
• Value: Enter query conditions to isolate the exact records that require data scrambling. 

Step 5: Prepare Sheet 

Once the iteration is created and config is set, click on the Hamburger Menu and select Prepare Sheet. 

Step 6: In the pop-up window:  

• Check Select All 
• Enter your ServiceNow password  
• Add any execution notes (optional)  
• Click Confirm and Start to process execution 

This step adds fields from selected table in Scramble Config sheet. 

Once the execution status is complate, navigate to your workbook.

Here you can see Scramble Config sheet, with successfully backfilled all field for the selected table from instance. 

To execute the data scrambling operation, assign a Scramble Type to each field (row) you wish to modify based on the options below: 

• Constant: Applies a fixed value to the field. Specify the desired value in the Constant Value column. 
• Random: Replaces the existing data with a randomly generated value. 
• Delete: Removes the existing data, leaving the field blank. 
• Skip: Bypasses the field entirely without making any changes. 

Step 7: Start Configuration

Once your configuration data is set:  

• Return to your iteration in ConfigBot.  
• Click the Hamburger Menu and select Request Reprocess. 

Click the Hamburger Menu again and this time select Process Workbook.

In the pop-up window:  

• Enter your ServiceNow password  
• Add any notes  
• Select the Scrambling checkbox 
• Click Confirm and Start to execute 

Step 8: Monitor Progress  

You can click the Information (ℹ️) icon on your iteration to monitor the processing status in real time and Logs. 

Once the status changes to "Complete", review the logs to see the total number of processed records, along with a breakdown of successful and failed records. 

Open workbook and navigate to the Scramble Report sheet to view the status summary for the processed records. The key columns in this sheet include: 

• Tables: The name of the table target for the scramble operation. 
• Scrambled Count: The total number of records processed. 
• Success: The number of records successfully scrambled. 
• Failed: The number of records that failed to scramble. 
• Message: Logs for the scramble operation. 

This guide outlines the end-to-end process for setting up, configuring, and executing Data Scramble across your target tables. By establishing precise filter criteria and selecting the appropriate scramble rules, you can safeguard sensitive information while maintaining data integrity.

Always review the final Scramble Report to verify execution status, troubleshoot logged errors, and ensure your sanitized dataset is ready for use. 

Thank You!

Updated on: 09/10/2026