Two-Find-And-Format Logfile Summary Tool

0 Likes
Trying to find some abuse of our email system we wanted to get a quick list with date, time, sender and recipient of mail to internet.

In the GWIA log-files this information is on separate lines. And if you get information of multiple day's, you also need part of the filename.

So I wrote this (configurable) tool. It uses a tfaf.ini file (example in the ZIP file) and commandline parameters.

To get information of all your GWIA logfiles, you can use:

for %I in (????GWIA.*) do TFAF /sf=%I /rf=result.txt

Information on use of the program is given starting the program without parameters.

Questions, suggestions, whishes: tfaf@switact.nl

Labels:

How To-Best Practice
Comment List
  •  
    This program doesn't take into account for how the GWIA processes multiple messages concurrently. An incoming message and an outgoing message could be logged before all the recipients are listed for the incoming message.

    This program simply takes the recipients and apply them to the last sender from a GWIA log. There is a MSG number that keeps the records tied together. This program ignores it.

    For example (bolded records belong together):
    GWIA LOG - Stripped down
    08:00:00 040 MSG 100001 Sender: Smith@YourDomain.com
    08:00:00 040 MSG 100001 Recipient: Someone@OtherDomain.com
    08:00:00 03C MSG 100002 Processing inbound message:
    08:00:00 03C MSG 100002 Sender: news@newssource.com
    08:00:00 03C MSG 100002 Recipient: Jones@YourDomain.com
    08:00:00 040 MSG 100001 Recipient: Sometwo@OtherDomain.com
    08:00:00 03C MSG 100002 Queuing to MTA

    This program will incorrectly show that news@newssource.com sent a message to Sometwo@OtherDomain.com, both of which are outside YourDomain.com
  •  
    How about making it so that it will return all senders and all recipients in a nicer format than the gwia logs use?
    Also it probably wouldn't take much to throw a gui on this so you could type your receipient and sender into edit boxes and have it display the results in a grid component! I see loads of potential here!
Related
Recommended