I wrote a little hMailServer DB-Utility which is able to execute Insert/Update/Delete SQL-Queries against hMailServers
internal COM-API. This can be usefull if you need to process some batch operations (for example, delete all Mails
by a specific Sender, Recipient, Textstring, Date, Time, by accountid ect. It supports any SQL-DB hMailServer
does supports by itself.
Its not able to operate with return values, so you need a diffrent tool to handcraft your SQL-Queries/Scripts
in the first place or simply use the allready avaiable SQL-Scripts from other hMailServer users.
The above SQL-Query is builtin, so you can diretly modify it as you need. I noticed if this SQL-Query is executed,
hMailServer automatically deletes all its depending *.eml Messages files from hMailServer\Data\xxxx\*.eml
Folder by itself. There should no orphaned Message Fragments remain after SQL-Query execution.
The above SQL-Script will delete all Messages from the hMailServer Database for Messagesender with the Email-Address: firstname.lastname@example.org
C# VS2017 - Sourcecode:
https://github.com/Dravion/hMSSqlPad/tr ... Sql/hMSSql
https://github.com/Dravion/hMSSqlPad/re ... hMSSql.exe