Generating Backdated Daily AE Review Report and Triggering Email (Client: ConnectiveRx)

Purpose

This document explains how to access the RDP session, modify the ColdFusion .cfm file in Notepad++, generate a backdated report (e.g., on 16-Dec-25 we are generating for 14-Dec-25), trigger the email for that report, and roll back changes to resume normal daily processing.

Steps

1. Login to RDP

• Connect to the Windows Server using Remote Desktop Connection.
• Use the provided IP (e.g., 10.11.0.81) and credentials (reach out to Deepanshu Wadhwa).

2. Navigate to the .cfm File

• Open Notepad++ on the server.
• Go to the file path: F:\coldfusion11\cfusion\wwwroot\alarms\pskw\26729-75186-AE.cfm
• This file contains the logic for generating the report and sending the email.

3. Modify the Date Logic for Backdated Report

Locate and update the following snippets:

Snippet 1: Start and End Date Parameters

<cfparam name="startDate" default="#dateformat(dateadd('d',-1,now()),'yyyy/mm/dd')# 00:00:00"/>
<cfparam name="endDate" default="#dateformat(dateadd('d',-1,now()),'yyyy/mm/dd')# 23:59:59"/>
 

Action: Change both -1 to -2.

Snippet 2: CSV File Creation

<cfset inpFileName = "Daily_AE_review_report_detail_#dateformat(dateadd('d',-1,now()))#.csv">
 

Action: Change -1 to -2.

Snippet 3: Email Subject

subject="Daily AE review report #dateformat(dateadd('d',-1,now()))#"
 

Action: Change -1 to -2.

4. Save Changes

• After editing, save the file in Notepad++.

5. Trigger the Report

• From your local browser, connected via Tailscale MB VPN, run: http://10.11.0.81:8500/alarms/pskw/26729-75186-AE.cfm
• This executes the ColdFusion script, generates the CSV, and sends the email.

6. Verify Email

• Email will be sent from [e-mail]
• Subject example: Daily AE review report 14-Dec-25
• Recipients: To: [e-mail], CC: [e-mail]
• Attached Report: Daily_AE_review_report_detail_14-Dec-25.csv

7. Roll Back Changes

• After confirming the report and email, change all -2 back to -1 in the .cfm file and save.
• This ensures the system continues generating daily reports automatically.

Important Notes

• Always revert changes immediately after the backdated report is processed.
• Ensure MB Tailscale VPN connection is active before accessing the server and URL.
• We have also submitted https://mbroadcast.atlassian.net/browse/MBI-166, to automate detection and remote restart for legacy Windows server that intermittently hangs and fails to send daily email reports.