Automate Database Maintenance - Tickets

Summary

This script is called from CWM - Automate - Script - Automate Database Maintenance Solution.

This script handles the cleanup of the following table(s):

• Tickets - Requires CWM - Automate - Script - Automate Database Maintenance Solution TicketCleanup_Days Global Variable set to a value other than 0.
• TicketData - Requires CWM - Automate - Script - Automate Database Maintenance Solution TicketDataAdditionalCleanup_Days set to a value other than 0.
• plugin_cw_cwstatusmapping - Requires CWM - Automate - Script - Automate Database Maintenance Solution InactiveTicketStatus_Cleanup set to 1.
• plugin_cw_servicestatuses - Requires CWM - Automate - Script - Automate Database Maintenance Solution InactiveTicketStatus_Cleanup set to 1.
• plugin_cw_clientmapping - Requires CWM - Automate - Script - Automate Database Maintenance Solution InactiveAgreementMapping_Cleanup set to 1.

Sample Run

This script is a function script called from CWM - Automate - Script - Automate Database Maintenance Solution.

Variables

Name	Description
Verify	This variable verifies both the starting count of targeted data and the after-action count of targeted data. We expect the starting count to be a value greater than 0, and the after-action value to be 0.
LogMessage	This variable holds the running log message. Please note this variable is always set the same way wherever it's used in the solution: @logMessage@ = @LogMessage@[Linebreak]%when% : [Category] Cleanup [Stage] - Result. Please continue to utilize this standard with this running log file.

Output

This script will add the following section to the log variable: