Summary
The purpose of this process is to collect a SQL report that runs daily from the Counterpoint SQL server (NET5020) and email a copy to ASF@ucf.edu every night at 11:30 pm.
Business Owner
ASF
Contact Information
Brenda Posey
407-823-2516
Hardware
VM
NET5020.net.ucf.edu
NET5031.net.ucf.edu
Database:
NET5020
Software Version
N/A – script developed in–house.
Software Status
Active
Application Data
Compatibility
Compatible with Windows 10, 11 – SMB File Transfer
Detail
CounterPoint SQL Report
- NET5020 saves the file ‘TicketCenterSummary.csv’ nightly at 11:00 pm to \\net5020.net.ucf.edu\workday\ASFTC\.
PowerShell Script and Scheduled Task
- The task ‘Get Ticket Center summary’ runs the script ‘GetTicketCenterSummary.ps1’ on NET5031 nightly at 11:30 pm.
-
- The PowerShell script is located at 'C:\Workday' on NET5031.
- The script MUST run as the service account ‘svc_tpc_workday_task’.
Actions performed by the PowerShell script
- Moves ‘TicketCenterSummary.csv’ to 'C:\Workday' on NET5031.
- Sends an email with attached report to each user listed in 'C:\Workday\WDAdmin.csv' (asf@ucf.edu, easappsupport@ucf.edu).
- Deletes ‘TicketCenterSummary.csv’ from 'C:\Workday' on NET5031.