Verifying Exelon Reach Simulation Mode Enable/Disable Activity

This knowledge base article outlines the process for verifying logs related to the enabling and disabling of the Simulation Mode feature in Reach for Exelon Operating Companies (OpCos), including ComEd, PECO, BGE, and PHI. It also provides the required Exelon distribution lists (DLs) that must be notified whenever Convey performs testing or configuration changes involving Simulation Mode.

Overview

Exelon OpCos (ComEd, PECO, BGE, and PHI) may submit a support ticket requesting details regarding Simulation Mode changes within Reach. These requests typically involve determining who enabled or disabled the feature and identifying the timestamps associated with the changes.

Example Ticket:
https://goconvey.zendesk.com/agent/tickets/29276

Required Information

Before proceeding, verify that the request includes the affected Exelon OpCo:

ComEd
PECO
BGE
PHI

Required Access

Before you begin, ensure you have the following:

Google BigQuery Access

Tier 1 Support Process

Follow these steps to complete the process or resolve the issue:

Step 1: Access BigQuery
URL: Google BigQuery

Step 2: Navigate to the Reach Data Warehouse
Navigate to the following dataset:c3t-tango-prd → reach_dw

Locate the API_CALL_LOG table.

Step 3: Open the Query Editor

Select the API_CALL_LOG table.
Click View Actions.
Select Query.

This will open the query editor.

Step 4: Run the Simulation Mode Audit Query
Use the query below to retrieve Simulation Mode activity.

Important Note!!

Update the CLIENT_ID value based on the affected Exelon OpCo before executing the query.

Client ID Refence

OpCo	Client ID
ComEd	2
PECO	3
BGE	4
PHI	6

Query:
SELECT * FROM `c3t-tango-stg.reach_dw.API_CALL_LOG` WHERE REQUEST_URI = "/reach/clients/v_1/meta" AND REQUEST_PAYLOAD LIKE "%SIMULATION_MODE%" AND CLIENT_ID = 6 ORDER BY CREATE_DATE DESC LIMIT 10;

Execute the query and wait for the results to load.

Step 5: Export the Results

After the query completes:

Click Save Results.
Select CSV as the export format.

A csv file will automatically download.

Step 6: Review the Audit Log Results
Review the exported CSV file and verify the following information.

Verify the Client ID
Confirm that the CLIENT_ID values in the results correspond to the affected OpCo specified in the ticket.
Identify the User Who Made the Change
Review the USER_NAME column. This field identifies the user who enabled or disabled Simulation Mode.
Identify the Change Timestamp
The following fields can be used to determine when the change occurred:
- REQUEST_DATE_TIME
  CREATE_DATE
  LAST_UPDATE_DATE
These timestamps indicate when Simulation Mode was enabled or disabled.
Review the Simulation Mode Changes
Review the RESPONSE_VALUE column.
- Channel Types
    SMS
    Email
    Voice
    Push
- Value Definitions
  
  Value Meaning
  
  True Simulation Mode Enabled
  
  False Simulation Mode Disabled

Use the response details to determine the exact configuration changes that were made.

Step 7: Summarize the Findings and Respond to the Customer

Prepare a summary of the audit log findings and provide the requested information to the customer.

Include:

✓User who made the change
✓Date and time of the change
✓Channels affected
✓Whether Simulation Mode was enabled or disabled

Exelon Notification Distribution Lists

Exelon has requested that the following distribution lists be notified whenever Convey performs testing or configuration changes involving Simulation Mode.

These contacts should be included in communications to ensure awareness and prevent unnecessary incident tickets.

Required Distribution Lists

✓EUDigitalReleaseManagement@exeloncorp.com
✓EU-LowerEnvironmentSupport@exeloncorp.com
✓EUCustomerDigitalSupport@exeloncorp.com

Important Note!!

Include these distribution lists in advance of any planned testing, configuration changes, or maintenance activities involving Reach Simulation Mode.

Value	Meaning
True	Simulation Mode Enabled
False	Simulation Mode Disabled