# Collection of scripts - Cleanup test form submissions

**URL:** <https://forum.mautic.org/t/collection-of-scripts-cleanup-test-form-submissions/37508>\
**Category:** General Discussion\
**Created:** [March 20, 2026, 6:14pm UTC](https://forum.mautic.org/t/collection-of-scripts-cleanup-test-form-submissions/37508 "2026-03-20T18:14:57Z")\
**Posts on this page:** 1\
**Page:** 1

<div class="post-metadata">

**Author:** ![dirk\_s](https://sea2.discourse-cdn.com/flex020/user_avatar/forum.mautic.org/dirk_s/32/748_2.png) [@dirk\_s](https://forum.mautic.org/u/dirk_s)\
**Post date:** [March 20, 2026, 6:14pm UTC](https://forum.mautic.org/t/collection-of-scripts-cleanup-test-form-submissions/37508/1 "2026-03-20T18:14:57Z")

</div>

Hi there,

I’m starting a small collection of maintenance scripts for Mautic. The first tool addresses a common pain point: **test data bloating statistics.**

We have a client who uses a UI test script to regularly verify form functionality. While helpful, it creates a lot of noise in the reporting. To solve this, I’ve created `mautic_clean_submissions.sh`.

**What it does:** It allows you to target a specific user (by email address) and wipe their entire submission history.

**Key Features:**

- **Deep Clean:** It doesn’t just touch the central submission log; it dynamically identifies and cleans the specific `form_results_X` tables associated with that lead.

- **Multi-Form Support:** Handles leads who have submitted multiple different forms.

- **Safety First:** Includes a **Dry Run** mode by default to preview affected rows before any deletion happens.

- **External Execution:** Designed to run securely outside the Mautic web root using a `.env` configuration.

I tested it with Mautic 5.2.10 - please use it at your own risk! Please let me know when you find issues with it directly in github.

> **[GitHub - twentyZen/mautic\_scripts: A collection of useful scripts to work with Mautic](https://github.com/twentyZen/mautic_scripts/)**
>
> A collection of useful scripts to work with Mautic