Microsoft Exchange Log and Import Agent
Do you know who is sending e-mail or where they’re sending it?

Take Back Control over Exchange!

This is the tool that was lacking to enable you to really manage your Microsoft Exchange E-mail

Product Features

E-mail activity represents a major use of your corporate resources. It is (part of) your job to manage the Exchange servers. But do you know who is sending e-mail or where they’re sending it? Do you know how many messages are being sent each day, week, and month or when your Exchange® servers are busiest?

You should.

MELIA is the first dedicated MS Exchange e-mail management solution to give you and your organization the answers necessary to operate profitably, efficiently, and securely. MELIA can manage information from 1-1000 Exchange servers all from a single, simple interface. Finally, you can know how much space is taken by Exchange mail boxes, who sent what to whom and when, and where your employees are receiving mail from.

Messages processed by a Microsoft Exchange Server can be tracked. Message tracking can be enabled on the MTA, Information Stores, and most Connectors. When message tracking is enabled, each component that is handling mail records its activities in a log maintained by the System Attendant on each server. This log is a daily map of the processing of each message as a component receives, processes, and delivers it to the next component.

MELIA extracts and decodes these logs and stores the data in a relational database. MELIA includes fully customizable reports for easy reporting of both detail and summary information of activity.

A Report Wizard that lets users create many types of reports from within MELIA (no need to figure out SQL!)

Selective GAL import and GAL updates. Now when you import the GAL, you can pick which fields to import and you can tell MELIA to only get changes to the GAL since the last import. This speeds up processing of logs and keeps the imported GAL current.

Server Setup Wizard. MELIA goes out through your organization and automatically detects all of the Exchange servers and sets many of the program options automatically!

Automated command line reports.

An Exchange log transfer agent - in a WAN environment, it's necessary to consolidate the logs from various servers to a single, high speed location for processing. MELIA includes a small agent application that can be run from each Exchange server to automate the log movement.

MELIA 2000 provides complete reporting on the Public and Private stores in Exchange. This allows the user to get extensive information about each mailbox (how many messages, how many unopened, total KB, etc.) as well as detailed information about the public folders.

Graphs for many of the reports

Plus lots more!


Standard Features

  • Databases: Full support for Microsoft SQL Server and Microsoft Access (.MDB) databases. (there are two separate versions of MELIA for these two databases)

  • Microsoft Universal Data Access technologies.

  • Platforms: Windows 2000, NT, 98, 95.

  • Auto-Pilot Mode: allows you to process a previous day’s logs automatically.

  • Catch-up mode: process any outstanding log files since last run.

  • Command line interface to allow for easy scheduled and batch execution.

  • Convenient QuickStart helps you get going in under 10 minutes.

  • Optionally sort and move processed files to a subdirectory.

  • Optional Automatic ZIP compatible compression of processed log files.

  • Track message size, recipients, recipient count, sender, connector, time, and date.

  • Ability to report on Global Address Book and Distribution Lists.

  • Fully supports Microsoft CDO technologies.

  • Ability to process today’s log files as they are created.

  • Ability to reprocess log files without adding previously imported data.

  • Includes 30 enhanced reports.

  • Multi-server logging and reporting from one database. Allows for cross-server reporting.

  • Recipient data is now stored in a related sub table for easier per recipient reporting.

  • All data is imported without modification.

  • Universal Time Coordinate (UTC) to local time conversion.

  • Y2K Compliant.

MELIA is licensed on a per server basis and works with Microsoft Exchange Server 4.0 and higher.

Product Benefits

With MELIA, you can track all e-mail activity...

  • to ensure it meets company policies;

  • to maintain internal e-mail security and prevent the leak of important information to competitors

  • to facilitate the bill back of e-mail time and expense to appropriate departments and clients

  • to prevent network overload (volume) as well as to collect data to make informed purchase decisions

  • to protect against e-mail intrusion from "spam" or a hacker's attacks

And much more.

MELIA is a crucial Exchange Add-on.

Here is some ammo you can use to get approval from your management:

"Internal E-mails put firms in danger of libel lawsuits" ComputerWeekly, July 24, 1997

"Chevron has been forced to pay out $2.2m to four female employees who claimed sexual harassment after receiving abusive e-mails at work."

"Norwich Union last year paid $675,000 in an out-of-court settlement to Western Provident after employees sent defamatory e-mails about a rival firm."

"...employers could be held liable for abuse or harassment caused via e-mail if they are unable to show that systems had been introduced to prevent such harassment occurring" The Herald, June 24, 1998

Quotes from MELIA Users

MELIA was a tremendous help yesterday when we got hit with a variation of the VBS_FREELINK virus. This virus replicates itself by sending itself as an attachment to the Exchange GAL.

Thanks to MELIA, we were able to see where the message came from, and what clients and vendors of ours we sent it out to. This made contacting these people and organizations much easier.

Patrick Nolan, IS Director, GSD&M Advertising

I'm running daily reports on users sending e-mail over the Internet and internally with it. I'm able to collect global address information and analyze usage back and forth to manage our communications in a better way.

Chuck Shah, Operations Manager for IS, Tommy Hilfiger U.S.A. Inc.

By using MELIA, in less than one month [we were] able to view patterns that, while not yet a real problem, could prove disastrous in the future. For example, by watching traffic, we were able to see a chain letter being sent to one person in the organization, then passed quickly on to others. [Users] don't understand that this can be a problem, and we need to educate them on how to use e-mail effectively.

Harris Berkowitz, Executive Administrator, Screen Actor’s Guild

We purchased MELIA to report to management on the amount of Internet (SMTP) traffic in & outbound through our company's Exchange server. We looked at other products to perform this function but the MELIA product was the easiest to setup and use. It also generated the most complete and presentable reports.

Scott Steenhoek, IT Director, Cova Financial Services Life Insurance Co.

White Papers, Documents and Other Files

Best Practices and Deployment in Larger Multiserver Domains PDF File (PDF)

MELIA Full Manual (PDF)

Multi Server Melia Deployment Guide (PDF)

Sample MELIA Report: What is the hourly Internet mail use of the server? Pie Chart (PDF)

Sample MELIA Report: How much Internet mail was sent & received hourly? (PDF)

Sample MELIA Report: How much Internet mail did each user receive? (PDF)

Sample MELIA Report: How much Internet mail did each user send? (PDF)

Sample MELIA Report: Who sent the most Internet Email? (PDF)

Sample MELIA Report: What were the overall statistics per month for our servers? (PDF)

Product Requirements

OS Platform Supported
Windows 2000 Server
Windows 2000 Professional
Windows NT4 Server (SP4 or higher)
Windows NT4 Workstation (SP4 or higher)
Windows 98/95

Minimum Hardware Required
CPU Pentium 166
RAM 32
HD (Install) 24MB
HD (Operating) 32MB

Additional Requirement Notes
To run MELIA 2.0 you will need to have Microsoft Outlook 9x (or better) installed on the machine running MELIA. This does not mean the server, unless you are going to run MELIA on the server. You must also be sure to include Exchange Server support when installing Outlook9x. Outlook 97 is available as part of Exchange Server 5.x


What is MELIA?
MELIA transfers Exchange's difficult to use tracking log information to a usable Access database or SQL server. While 30 ready to use reports are included, MELIA allows you to easily use Microsoft Access or Excel to write your own reports.

How do I turn on Tracking Logs in Microsoft Exchange?
There are several Message Tracking Logs you can enable.

MTA - On the General tab of the MTA Site Configuration page check the Enable message tracking check box. This will log routing information on all messages processed by the MTA.

Information Store - On the General tab of the Information Store Site Configuration page check the Enable message tracking check box. This will log routing information on all messages processed by the Information Store

Connectors - Each Connector should have an Enable message tracking check box.

SMTP or Internet - On the General tab of the Internet Mail Service page check the Enable message tracking check box. This will log routing information on all messages processed by the the Internet Mail Service.

MS Mail - on the General tab of the MS Mail Connector page check the Enable message tracking check box. This will log routing information on all message processed by the MS Mail Connector.

CC Mail - on the General tab of the CC Mail Connector page check the Enable message tracking check box. This will log routing information on all message processed by the CC Mail Connector.

Does Melia scan the content of messages?
No, it does not scan content of messages (not an SMTP Scanner) as that information is not captured in the Exchange tracking logs.

To be able to report on sender activity, receipt activity, server operation, address lists, etc., a content reporting tool isn't going to work. MELIA provides that information exceptionally well, and also provides some security information.

Why not use Crystal Reports product for this?
Essentially, Crystal Reports has two things against it. First, it is a huge package and second, it's complex and doesn't fall into the 'friendly' category.

We've used Crystal Reports. MELIA was designed to be everything that applications like CR aren't - friendly, fast, simple-to-use, and providing powerful and timely information for making decisions.

MELIA can be set up in under 10 minutes and - very importantly - can be used by a non-technical user. Of course, a technical user can go into the program and do queries and set up new reports.

Why does my company want to know about e-mail use?
There are two reasons – technical and managerial.
Technically speaking, Exchange servers are very reliable, but administrators need information to keep them working properly. Mailboxes can grow out of control, users can abuse the system, and additional servers may need to be added to accommodate company and message growth. MELIA can harvest the data from all of an organization’s Exchange servers and provide clear, easy to use reports that help administrators maintain Exchange.

From a management perspective, e-mail is an important tool for communicating, but it can be a source of abuse, or worse, a source of potential legal liability. MELIA allows managers to monitor e-mail use and be alerted to potential problems before they get out of hand.

Also, MELIA can provide accounting for all e-mail sent and received by every department and individual. This means that departments can be billed back for proportionate use or clients can be charged for every e-mail sent on their behalf.

What kind of security information do we need?
There are really three levels of security regarding e-mail. The most absolute is an actual SMTP filter that examines every piece of mail and doesn’t transmit if something seems wrong (note that most of these don’t handle internal e-mail – MELIA can report on that, too). This is a very expensive system that actually gets intertwined into your servers and can cause real headaches. In some cases, additional server(s) may be required.

The second level of security would be content examination. In this scenario, the content of the e-mail is looked at, but the operation of the servers is not meddled with. This won’t stop a message from going out, but it will give someone a "heads up" when something is possibly not correct. This is not as expensive as the highest level of security, but still costly as it has to review the messages real time including decoding MIME and UU attachments.

The third level of security is what MELIA provides. It shows everything about the flow of messaging except the content. From this, you can piece a lot together pretty easily and if needed, examine the actual e-mail in question further. For example, being able to check if e-mail is being sent to a particular domain name provides a course for management to investigate further as seems warranted (for example, if mail is being sent to your main competitor). Similarly, if you notice that one employee routinely sends out messages with 75 cc’s, management could suspect they are doing something inappropriate (like joke rebroadcast – a prime source of libel sexist material). MELIA can pick up on this type of activity easily.

Each organization needs to ask itself how much security they need. If you need absolute content control, then you really need to be looking at SMTP filtering products – be prepared, however, to spend a lot of money. For most organizations, though, the focus is on providing a reasonable level of security. MELIA can inexpensively offer a lot of security protection and it’s easy to use – even for non-technical managers.

Can my employees take legal action against us if we use MELIA?
It has been ruled repeatedly in courts that e-mail is the property of the corporation and therefore a company can monitor its e-mail use. However, recent news stories have demonstrated that this is a two-edged sword. Employees claiming patterns of harassment via e-mail have been able to get courts to seize old e-mail as evidence. This is why use of SMTP filtering products may be, in fact, a bad idea as they tend to store copies of all e-mail which might later be used against a company. Using a product like MELIA can help prevent such situations from occurring by alerting you to problems early so that you can stop further abuse. For example, if an employee claims that they are receiving sexually explicit e-mail from another employee, MELIA can report on the e-mail the offender sends to ensure that they, in fact, stop. Obviously, for any legal issues you should consult with your own attorney, but the first steps for any company will involve creating an e-mail use policy and putting tools in place to prevent abuse.

What is e-mail filtering?
E-mail filtering is a process where each outgoing Internet message is examined to look for inappropriate destinations and inappropriate content. To get e-mail filtering, you need to purchase a product that sits between your Exchange server and your Internet connection. Very often, these products need to be placed on a separate server or may even replace the SMTP gateway entirely. Worldtalks WorldSecure is such a product but pricing starts at $10,000. Note that most of these products for not provide significant reporting and do not monitor internal e-mail. MELIA is not an SMTP filtering product.

What does MELIA do?
MELIA goes out and imports Microsoft Exchange log information into its database, decodes the information, and provides ready reports for use. The logs for the Exchange server don’t contain the text of the messages, but they do contain a great deal of information about the messages. This includes who sent each message, when, how big it was, who the recipient was, who each received mail was from, how many cc’s a message had, message flow through various connectors, department e-mail traffic, distribution traffic, and much more.

MELIA also has the ability to report on an unlimited number of Exchange servers throughout an organization. It stores the information either in an SQL server or in an open, accessible Access database.

I just downloaded the 30-day version. Is its functionality limited in any way?
No, it is the full product capable of either SQL or Access operation. This means that you can import logs from 500 Exchange servers and use all of the reports and data. At the end of the 30-day period, the product will simply stop operating.

Does MELIA get installed as part of Exchange?
No, MELIA by design is totally non-invasive and simply runs on any workstation. If you wish to use the SQL version, you’ll obviously need an SQL server.

What do I need for a workstation to run MELIA?
The workstation needs are pretty straightforward. A Windows 95/98 or NT 4.0 workstation is required. While MELIA is quite efficient, the processing of the logs is processor dependent so a Pentium II 300 or greater is recommended.
On all workstation types, you need to install Microsoft Outlook 98 – this is because a required Microsoft Library (Collaboration Data Objects (CDO), version 1.21) is only distributed with the Outlook 98 product. We expect Microsoft to change this distribution in the not-to-distant future and will update the code at that time. Make sure you install Outlook 98 before you install MELIA.

What is the Configuration Wizard
Configuration -- When you run MELIA for the first time, the configuration wizard will automatically run. This will allow you to create a new MELIA site or connect to an existing site. If you are installing MELIA to run for a user that will only access reports, select the User option. Select Super User if you want the individual to actively work with the database and oerform imports.

I had a MELIA 1.0 site. Can I just point 2.0 to the 1.0 database?
No, YOU CANNOT CONNECT TO A MELIA 1.0 DATABASE. If you need to use the data you have already imported into MELIA 1.0 we suggest you re-import that data into 2.0. Version 2.0 uses a faster engine and a different storage method.

What is the security file that is mentioned in the installation?
In order to allow multiple machines to work with multiple servers, MELIA uses a centralized security file. This file holds the information on where the servers are and where the database is located. When used with an Access database, the security file is stored in the same location as the database file. This should not be a concern to users as they will simply be asked where the security file is. MELIA will open it and discover the rest.

I have a lot of servers to register – is there an easier way to do this?
Possibly. If you’ve already set up MELIA as part of your 30-day trial, simply e-mail the security file to your purchaser. It contains all of the required information – the organization name (case sensitive), each server name (always upper case), and the key code. You will receive back an e-mail that contains the registration code for each server. You can then cut and paste this information into MELIA to complete the registration.

Where are the Exchange log directories?
You can check your Exchange Server for this directory location, but it is usually in \\server\exchsrvr\tracking.log. If you have multiple servers MELIA will remember where the data for each server is being stored.

What is the option check box for moving logs used for?
If you check this box will move log files from the Exchange directory after processing. This can be useful in assisting you to manage large numbers of files. It is recommended that you move the files rather than leave them behind.

What other information does MELIA provide?
In the MELIA.MDB Access file you will find several useful items. First, the Exchange Tracking Log data will be imported to the ExchangeTrackingLog table (if you are using MELIA in the Access mode). MELIA stores decoded data in a table named ExchangeTrackingLog. This table has been provided. One other table is also included. The Events table lists each of the EventID codes and details about them. You should refer to this when writing reports.


All trademarks are property of their respective owners or holders. Information subject to change without notice
Copyright © 2000 - 2015 AMT Software. All rights reserved.