Report ASP pages                                                                        Download Files

The report pages consist of three different types of page the first is the aggregate pages which display one of the total aggregate queries in a table. The second type is the drill down page which displays a segment of the log file based on input parameters passed in from the aggregate pages via html query-stings. The third page type is a graph page which displays a visual representation of mail traffic based on a aggregate query. All these pages use ADO  to connect to and query the trackinglog database. There is one hardcoded reference to the report database being located on the D:\ in all pages.

dataConn.Open "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=c:\Trackinglog.mdb" 'make connection

NavBar

All aggregate and graph pages include a NavBar across the top of the page which allows you to change the time scope of the data displayed by the page and also move between different reports. It achieves this using a case statement and some query strings if no query string is passed into the page the default will be set to a 14 day date range for displaying data. The front end of the page includes some code that inserts the date range into the qdatfilter table which is how the date range of the queries that run after this is controlled (see previous page for a description of this).

Aggregate Pages

The aggregate page shows one of the total aggregate queries from the database and includes some code to create hyperlinks to the drilldown pages for all the total values.

Drill-Down pages

The drill-down pages queries one of the Detail Access queries with input parameters passed in from HTML query-stings (which are passed in from the hyperlink)  to filter down the detail query to the section of the log file that the drill down refers to.

Graph pages

The Graph page shows a visual representation of mail traffic across a period of time, to generate the graph itself I've used a 3rd party Java applet which you can download for free from here. The hour graph page shows mail traffic grouped by the hour.

Installing and Using the pages

The first task you need to do to use these reports is you need to insert the domain you want to monitor into the domains table in the Access database. The format you use is just "domain.com" basically anything after the @ sign of the email address's (domain) you want to monitor.

The database file needs to be located on the d:\ of your web server unless you have changed the location in all the asp pages. Also the permissions on the database file must allow write access for the anonymous II_USR web server account. (or allow write access for everyone).  To install the pages you can create a directory under the default website call it something like tracking put the asp pages into that directory and you should be ready to go. If you are using Windows 2003 you need to make sure you have enabled ASP pages under the IIS web service extensions.

The other thing that's necessary to use the graph pages is you must download the java chart applet from here .I have no association with the people that wrote this Java applet they currently provides a free download of a branded applet so please respect the usage rights of the author. Once you have downloaded the applet you will have one java class file called barchart.class all you need to do is place this in the same direction as the asp files and it should work okay. To use the graphs all you need then is a browser with at least the Microsoft Java virtual machine (or equivalent)  installed and enabled.

Going a little further

But you don't have to stop with just reporting on the database you could use this same database to do things like threshold triggers for example if email traffic is over a certain number of messages or size in the last 15 minutes it sends an email alert with an aggregate report on who and what is causing the problem.

Download Files