I've got iMS configured to cap each log at 10MB, so they're not
obscene, and we've got machines with enough horsepower to run text
parsing on those files, so that's not really the issue. It's just
that I *really* don't want to actually have to write a parser.
On Apr 25, 2007, at WednesdayApr 25, 2007 954PM, Mark Kecko wrote:
Brett,
How big are the iMS logs you're running these cf files against?
How powerful is the machine you're using?
Mark Kecko
Technology Director
MediaPost Communications
[EMAIL PROTECTED]
212-204-2002
Brett Payne-Rhodes wrote:
Hi Brett,
I have a couple of CF scripts that may help you get started.
The first one, collectEmailStats.cfm does the actual parsing of
the log files and that might be most useful to you. It writes mail
stats information for each email domain to a (mySQL) database.
The other, generateVolumeReports.cfm reads the data and creates a
simple text file report for each domain for the current month.
I have these set up to run every night.
The mailstats table looks like:
CREATE TABLE `iMS`.`mailstats` (
`DomainId` int(11) NOT NULL default '0',
`Domain` varchar(50) NOT NULL default '',
`TranDate` datetime NOT NULL default '0000-00-00 00:00:00',
`PostCount` smallint(6) NOT NULL default '0',
`PostVolume` int(11) NOT NULL default '0',
`SMTPCount` smallint(6) NOT NULL default '0',
`SMTPVolume` int(11) NOT NULL default '0',
`InvoiceNumber` int(11) default NULL,
PRIMARY KEY (`DomainId`,`Domain`,`TranDate`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;
Sorry for the delay in getting back to you, we had out Anzac Day
holiday here in Australia yesterday.
Cheers,
Brett
B)
Brett Peterson wrote:
Ben,
I've used TextPad to view the logs. The search functionality
lets you get a count of what it found (mark all), so I have
several phrases I look for on a regular basis. It remembers past
search phrases, so each time I go in I cycle through the top
search terms and get my counts. (eg, mbx sent successfully)
Brett Peterson (must be the third Brett on this list)
<hr size=1 color="#4455AA" noshade width=250 align=left><font
size=1>I think they should televise the Congressional Medal of
Honor awards instead of the Oscars.</font id=signature>
==^=======================================================
This list server is Powered by iMS "The Swiss Army Knife of Mail Servers"
--------------------------------------------------------------------------------------
This list is provided as a free service. Although we will try to address issues
in a timely manner, support via this list is not guaranteed. If you require
expedited
support then a support contract is required. Support may be purchased from
http://www.coolfusion.com/commerce. Details regarding support options may be
reviewed
at: http://www.coolfusion.com/SupportOptions.cfm
--------------------------------------------------------------------------------------
To leave this list please complete the form at
http://www.coolfusion.com/Support/
Need an iMS Developer license? Sign up for a free license here:
http://www.coolfusion.com/Developers/
List archives: http://www.coolfusion.com/cfbb/
Note: You are subscribed as archive_jab_org / [EMAIL PROTECTED]
==^=======================================================
