The Microsoft SMTP app for Splunk, it provides custom Splunk searches and dashboards for Simple mail transfer protocol server logs. All dashboards have been highly optimized for fast performance and contain custom drilldowns. Use to gain visibility and add insights to your mail sever logs. SMTP server error codes details is also incorporated in the app.
This app also provide monitoring for SMTP logs and helps to onboard logs into Splunk with pre-existing sourcetype and monitoring stanza to extract SMTP IIS logs in w3c Format.
Here we get two type of log SMTP daily email logs and BAD email logs.
Using this App:
Enable SMTP Server log settings:
SMTP log format selected is “W3C Extended Log File Format“ as W3C Extended format is a customizable ASCII format with a variety of different properties. You can log properties important to you, while limiting log size by omitting unwanted property fields. Properties are separated by spaces. Time is recorded as UTC.
Go to link for enabling SMTP server logging https://avotrix.com/docs/How_to_enable_logging_for_IIS_SMTP_server_in_windows-converted.pdf
Configuration and Installation:
Please see Splunk's official documentation for the initial installation of the app. To use the dashboards
Pre-requisite: This app contains monitoring stanza ,path can be edited as per specific path given by user for SMTP logs in server.
Index we are using here is Infra . Although no indexes. conf is given in package it should be made by user only while installation.
If you are using some index other, then Infra edit macro "smtp_index" for dashboard population, also edit eventype "smtp_ip" and put client_ip as per your logs
Links for eventtypes and macros used in app for modularity:
Link to lookup used for showing error code details in smtp logs:
• Single Instance
Install app here.
• Distributed deployment
Heavy Forwarder/Universal forwarder – Install app here. Enable monitoring stanza from inputs.conf (place index and add monitor path if not using standard)
Search Head – Install app here
smtp:iis:w3c – Getting SMTP email transactions logs
ms:iis:Badmail – Getting SMTP bad email logs
On the dashboard tab, you can use a time range to filter a result as per need. Selecting a new option in this panel will automatically reload all the graphs.
The very first row gives overview of daily count of Total, Outbound, Bounced and Erroneous with a trend line. Also provided drilldwon in these panels.
Outbound Email drilldown gives us details of mail sent to some recipient with other than permitted domain.
Bounced Email drilldown gives us details of delivery failure.
Error code generated while mail transaction will get captured with issue details. Drilldown for error code time will give insights of failed mail.
Error code statistics gives statistical data for all generated error codes.
Reports - Existing schedule and triggering condition can be altered as per required
Daily report to collect Error code generated: This report runs daily on 00:00 AM and collects all the error code with details
Daily report to collect Outbound Email list: This report runs daily on 00:00 AM and collects details of all outbound email sent
Daily report to collect Bounced Email list: This report runs daily on 00:00 AM and collects details of all Bounced email
Alerts - Existing schedule and triggering condition can be altered as per required
Error code generated -Email failed: Triggers when Error code count is greater than 20, runs at every three hours
Outbound Email sent: Triggers when an outbound email sent is greater than 0, runs at every hour past 15 minutes
Bounced Email alert generated: Triggers when Bounced email count is greater than 20, runs at every three hours
Updated dashboard queries and enriched installation and configuration document
Added Splunk Cloud Compatibility
As a Splunkbase app developer, you will have access to all Splunk development resources and receive a 10GB license to build an app that will help solve use cases for customers all over the world. Splunkbase has 1000+ apps from Splunk, our partners and our community. Find an app for most any data source and user need, or simply create your own with help from our developer portal.