This manufacturing company with offices in the US and China has tight controls over proprietary design documents. Despite numerous restrictions and policies they want a summary report of all attachments sent in and out of the company. Using Mailspect’s eamil stream management abilities we constructed a MySQL database and recorded metatdata about the messages. Mailspect’s query engine allows you to work with any MySQL database using a broad range of email generated macros in queries. Mailspect supports both insert and select statements. Email Stream Management queries are processed sequentially so in our case, one job finds interesting messages, one records metadata and one stores the attachment for later review.
After creating a storage model and queries we created a report that emails management a daily summarized report of attachment flow in and out of the organization.