I mentioned some time ago that I was developing a program for archiving iMail logs. It is near completion, and with some luck I'll have it available for interested folks to download this weekend. At the risk of contracting "FeatureCreepItis", I've attached a sample copy of the .ini file for the program; it give a fair idea of what it does, and to see if there are suggestions for additional capabilities.
Some other notes:
I developed the program to use MySQL to archive the logs. Theoretically, it will connect to most any ODBC database (MS-SQL, Access,SyBase, etc), but I have not tried it. I have MS-SQL and Sybase environments available to me, so I may test it against them, time permitting.
For each log entry, most of the important data is in it's own field; so a query to see, for example, how many messages JoeSmith has received that were over 1 megabyte is size are possible:
SELECT count(*) FROM imail
WHERE ToAddr = '[EMAIL PROTECTED]'
AND TheSize > 1000;When I release the program, the database structure will be documented in detail. If any anyone interested in a bare-bone list of database fields in the mean time, just let me know.
IMLP_DEMO.INI attached -----------------------------
-- -------------------------------------------------------------------- For it's Tommy this, an' Tommy that, an' "Chuck him out, the brute!" But it's "Saviour of 'is country" when the guns begin to shoot; An' it's Tommy this, an' Tommy that, an' anything you please; An' Tommy ain't a bloomin' fool -- you bet that Tommy sees! -- Rudyard Kipling, "tommy" --------------------------------------------------------------------- Bud Durland, CNE Mold-Rite Plastics Network Administrator http://www.mrpcap.com ---------------------------------------------------------------------
[SETTINGS] ; This is the ODBC DSN to connect to ; if a password is required, either define in the ODBC ; datasource definition, or put it here. ; IMLP has only been tested with MySQL ; iMailDSN=SOME_DSN_NAME ; ; This is the address the daily server admin report ; will be mailed to. More than one address is OK, just ; separate them with a comma ; [EMAIL PROTECTED] ; ; This is the IP address or host name of the mail host to use ; IMLP does *not* do SMTP auth ; MailHost=mail.mrpcap.com ; ; This is where the log files can be found ; SpoolPath=C:\imail\spool ; ; This is where log files are copied to, once they have been ; processed. If left blank, they will remain in 'SpoolPath' ; SavePath=c:\imail\spool\old ; ; Interval is how many minutes between log processing runs ; default is 10 ; Interval=15 ; ; Set this flag to Y if you want the log files deleted ; after processing. If this is set to Y, SavePath is ignored ; KillAfterArchive=N ; ; How many days should entries be held in the database? ; PurgeAge=180 ; ; If you are using iMail's feature to copy all mail to ; a user, and that user is named 'filecopy', this flag ; tells IMLP to skip any delivery lines for that user ; SkipFileCopy=Y ; ; When was the last cleanup done? ; Leave this blank -- the program will update it ; as needed. Or, you can change this and restart the ; program to have it re-create reports ; LastCleanup=11-13-2003 ; ; This section defines domain groups that you want to have a separate ; daily report generated for. ; ; This setting is simply how many groups there are ; There is probably a practical limit, but it should handle ; well over 5000 entries DomainReports=3 ; ; This is the list of groups of domains you want a report for ; each entry is ReportDomain<number>, where <number> is ; some number between 1 and the value of DomainReports ReportDomain1=mrpcap.com,moldriteplastics.com,mrpcaps.com,mold-riteplastics.com ReportDomain2=geoffreyspub.com,geoffreysbritishpub.com ReportDomain3=treadwellbaymarina.com,treadwellbay.com,marinachamplain.com,lighthousemarina.com ; ; This list is the e-mail addresses the domain reports ; are sent to. Numbered the same way as ReportDomain ; Multiple e-mail addresses for each entry should be separated ; by a comma ; [EMAIL PROTECTED] [EMAIL PROTECTED] [EMAIL PROTECTED]
