CDR SMS Prune

Status

Active, Maintained and In Production

Purpose

System Maintentence

Removes old customers records from the following tables

    1. ppn_CdrSummary
    2. ppn_RecentActivity
    3. ppn_MessageRoutedSummary
    4. ppn_UserContact

Technology

Application is a C# .NET6 console app.

Built with Microsoft Visual Studio Professional 2022 / 17.3.2

Source code

Application source code is stored on Azure Devops GIT

    Project: CDRSMSPrune

    Repo: vumber/CDRSMSPrune/Repos/Files/CDRSMSPrune

Deployment Method

Selecting the 'webdeploy' build configuration will complile a release version to C:\webdeploy\CDRSMSPrune.

From there files are copy and pasted onto the production server

Description

Application is a simple console app that calls three stored procedures:

- ppn_Maintenance_PruneCallRecords
- ppn_Maintenance_PruneSMSRecords
- ppn_Maintenance_PruneUserContactRecords

The application will simply call the sp and wait for it to finish.

The application use Dapper, and the "commandTimeout" parameter to extend the normal sp timeout.

commandTimeout is configurable and current set to 1500 (seconds)

Hosted

Currently NOT hosted

Logging

Logging will be on the logging server, currently VumTest2:

L:\Logs\LogReceiverService\CDRSMSPrune\_unauthenticated