I've made the first major revision to Imalogger available at: http://www.mccallie.org/technology/imalogger/. This version works with Imail 5.x log files. It also has an improved user interface. The attached file is the readme file. This version tries to answer the following questions: What local users receive the largest number of messages? What local users send the largest number or messages? What local domain receives the largest number of messages? What local domain sends the largest number of messages? Show where a particular local user sent mail. Show who sent a particular local user mail. What local user receives the largest amount of mail by size? This is a summation of all message sizes. What local user sends the largest amount of mail by size? This is a summation of all message sizes. Show records that had screwed up addresses. What remote users receive the largest number of messages from our local domains? What remote users sends the largest number or messages to our local domains? What remote domain receives the largest number of messages from our local domains? What remote domain sends our local domains the largest number of messages? Be sure to update the local domain information in the preferences before you start. Give it a try and let me know if you have problems. I'll try to fix them as time is available. Robert PS Importing large files takes time.
Imalogger By Robert Wilson Introduction: Imalogger is an Access 97 database that attempts to read Ipswitch's Imail 5.x log files and provide useful information from them. It isn't perfect, but does give one a general idea what is going on with an Imail server. Known problems: If a message is processed at the time the log is rolled over, it won't get imported. I don't change the dates read and since Imalogger uses date ranges, this thing is probably not Y2K compliant. If this is a problem, you are welcome to fix it. I haven't tested Imalogger with debugging enabled. Thanks: Thanks to Elise and Janet for their database expertise. Thanks to Billy for the logo. :-) Thanks to Uncle Ugly for Imail related questions. If you have any comments or suggestions, please send them to [EMAIL PROTECTED] Thanks, Robert Instructions 1) Read the menu descriptions below and become familiar with the menus. 2) Set the default Imail log path. 3) Set local domains. 4) Import one or more logs. 5) Set the required date ranges. 6) Select a menu to run a query. 7) As the database grows, remove older logs and compact the database. Menu Descriptions [File] File -> Import All Logs Imports all the Imail log files from the default Imail log directory. The default directory is set in the Preferences dialogue box mentioned below. File -> Import Selected Logs Imports one or more files selected log files. [Edit] Edit -> Clean Database Removes mail and error logs based on selected dates. Edit -> Compact Database Compacts the database recovering unused space. Edit -> Preferences Set Imail Log directory button Browse to the spool directory of your Imail server. You need to share the spool directory on the Imail server and map a drive locally if Imalogger isn't running on the server. Domains Considered Local The domain "localdomain" needs to exist. This is the domain used if no domain is included in a sender's address. Add the domains that are handled by your server including aliases. [Local Mail] Local Mail -> Who Gets the Most What local users receive the largest number of messages? Local Mail -> Who Sends the Most What local users send the largest number or messages? Local Mail -> What Domain Gets the Most What local domain receives the largest number of messages? Local Mail -> What Domain Sends the Most What local domain sends the largest number of messages? Local Mail -> Where Did a User Send Mail Show where a particular local user sent mail. Local Mail -> Who Sent a User Mail Show who sent a particular local user mail. Local Mail -> Who Gets the Most by Size What local user receives the largest amount of mail by size? This is a summation of all message sizes. Local Mail -> Who Sends the Most by Size What local user sends the largest amount of mail by size? This is a summation of all message sizes. Local Mail -> Show Errors Show records that had screwed up addresses. Remote Mail] Remote Mail -> Who Gets the Most What remote users receive the largest number of messages from our local domains? Remote Mail -> Who Sends the Most What remote users sends the largest number or messages to our local domains? Remote Mail -> What Domain Gets the Most What remote domain receives the largest number of messages from our local domains? Remote Mail -> What Domain Sends the Most What remote domain sends our local domains the largest number of messages?
