8
SMReport - Quarantine Summary Report for SmarterMail
Idea shared by Joe Wolf - 5/18/2015 at 3:37 PM
Proposed
NOTE: I do not take credit for this feature and I do not know who originally developed it, but I find it very useful and feel that a similar feature should be standard in SmarterMail.
 
This is an easy to install package that will notify users of the messages held in their Junk E-Mail folder the previous day.  It is our policy that no messages (except those containing viruses or malware, etc.) be unaccounted for.  We do not have any Antispam action that would DELETE messages.  Either the sender is notified that their message was SMTP Blocked (via the 554) or we notify our users that we held the message in their Junk E-Mail folder (that we auto-clean at 10 days).  This package sends a report to all users (there are provisions in the package to exclude users or domains that do not wish to receive the reports) that lists the Date, From, and Subject of the messages held in their Junk E-Mail folder.  It also gives them instructions on how to access those messages, mark them as Not Spam if we happen to filter what the user considers a valid message, and notifies them that the messages will be deleted in 10 days.  This is similar to what the commercial spam filtering services like Exchange Defender send out.  
 
I am including only the base package.  It sends out both HTML and plain text versions of the report (we call our reports "Quarantine Summary  Report" but you can call it anything you choose).  You can modify the templates easily to make them as fancy or plain as you want, and change the text any way you choose.  I'm actually hoping that someone will contribute to this feature and develop better looking templates.  I have modified what we send out, but I am not including that in the base package.  You probably need to take a look at the template files to make sure they match the version of SmarterMail you are running.
 
NOTE: This package does use a .exe file to run the reports.  I have checked to make sure this file sends no information outside of my own system many times to the best of my ability, but I do not guarantee anything.
 
The package is very simple to install and configure.  Simply download it to your SmarterMail server and un-zip it to any folder you choose (I use C:\SMReport but you can use anything you want)  Just follow the instructions in the ReadMe.txt file to configure the package.  The feature does have a "test" mode so you can see what it would have produced if it was in production mode.  You then simply use the Task Scheduler to run SMReport daily shortly after midnight.  The .exe runs VERY fast and it can process thousands of users in just a minute or so.  It's not a high load on the server at all.
 
Here's the link to: SMReport.zip
 
Again, I did not develop this but I am sharing it because I think it was valuable information that was lost when we lost the old forum.  I hope that we can revive this feature and we can further develop the templates to look better, etc.  The program itself is rock solid and has never caused me a single problem (I've been using it for many years).  
 
To SmarterTools:  I have suggested this as a feature in SmarterMail many times.  I hope you will take a look at this again.
Thanks,
-Joe

5 Replies

Reply to Thread
0
Come on.  Many of you have downloaded it.  What do you think?  The .exe is SAFE.
 
 
Thanks, -Joe
0
great, set it up within 5 mins... put it in test mode and ran the task... all seemed to work, not going live yet as need to get spam filtering sorted first.

I have approx 3000 mailboxes and the script ran in about 3 seconds??? is that right?
0
Yes, it's VERY FAST and low load.

-Joe
Thanks, -Joe
0
Where to get the newest smspamreport.exe. Mine from 2012 does not work anymore in version 14.5 of SmarterMail, all users get just blank empty emails, nothing listid anymore. In version SM 13.x it did work fine, but in 14 not, any ideas?
 
Thanks,
Fritz
0
Is this still available for users to download?  Tried to follow the link but it's broken.
 
Thanks,

Reply to Thread