- View a table of parsed reports
- Easily identify potential DMARC related issues through red, orange, yellow and green icons
- Filter report list by DMARC result, month, domain and reporting organization
- Sort report list table by any column
- View DKIM/SPF details for each report in a table, with the same red/orange/yellow/green colour-coding
- Sort report detail table by any column
- View the raw XML of the report beside the report detail table
Screenshot: Initial Report Listing
Screenshot: Report Detail
Screenshot: Report Detail with Raw XML
Installation and Configuration
A working webserver (apache, nginx, ...) with PHP
git clone https://github.com/techsneeze/dmarcts-report-viewer.git
Ensure that all the files are in their own sub-folder.
cp dmarcts-report-viewer-config.php.sample dmarcts-report-viewer-config.php
Next, edit these basic configuration options near the top of the
dmarcts-report-viewer-config.php file with your specific information:
$dbhost="localhost"; $dbname="<dmarc-database-name>"; $dbuser="<dmarc-database-username>"; $dbpass="<password-for-dmarc-database-username>"; $dbport="3306"; $cssfile="default.css"; $default_hostlookup = 1; // Hostname resolution: 1=on 0=off (Turning off host lookup greatly speeds up the program in the case of mail servers that have ceased to exist) $default_sort = 1; // Report listing Start Date: 1=ASCdending 0=DESCending (ASCending is default behaviour )
Finally, edit these basic configuration options near the top of the
dmarcts-report-viewer.js file with your preferences:
var default_reportlist_height = 60; // Main Report List height as a percentage of // browser window height (without the % mark)
Navigate in your browser to the location of the
You should be presented with the basic Report List view, allowing you to navigate through the reports that have been parsed.
Icon Color Legend
- Green : Both DKIM and SPF = pass
- Red : Both DKIM and SPF = fail
- Orange : Either DKIM or SPF (but not both) = fail
- Yellow : Some other condition, and should be investigated (e.g. DKIM or SPF result are missing, "softfail", "temperror", etc.)
At the top of the page you will find the option bar where you can set:
Hostname on/off: This determines whether or not the IP address of the mailserver is resolved into a hostname in the Report Detail.
Hostname resolution is fine until an IP address no longer has a reverse DNS entry (as when a mail server is de-commissioned) and it takes an excessive amount of time before the DNS resolution times out. If this is the case, you can turn off hostname resolution.
- DMARC Result: Filter by the combined result of DKIM/SPF: pass/pass, fail/fail, pass or fail, other condition
- Month: Filter by any month of reports
- Domain(s): Filter by any domain
- Reporter(s): Filter by any reporting organization
If the filter returns no reports, an error message will inform you that no reports meet the criteria you have set. In this case, you can change the filter settings or click on the Reset button to clear the filter.
- Refresh: This will refresh the data in the Report List while maintaining the currently set filter.
- Reset: This will reset the filter to show all reports in the Report List and then refresh the data.
The Report List table displays all the parsed DMARC reports, initially sorted by Start Date (whether initially ascending or descending is determined by the
$default_hostlookup option in
dmarcts-report-viewer-config.php) and initially filtered to show only those reports from the latest month available.
Clicking on a column heading will toggle the sort direction of the Report List table by that column. Clicking on any line of the Report List will display the detailed DMARC information of the selected report below the Report List table.
The Report Detail table displays the details of the selected DMARC report, initially sorted by IP Address ascending.
Clicking on a column heading will toggle the sort direction of the Report Detail table by that column.
Raw Report XML
More info can currently be found at : TechSneeze.com