Here's a sample SQL I'm using (it's from access, so it's a little ugly).. It
creates a query that shows simple counts of messages - it groups them by day
(columns) and message folder (rows).. It shows the previous 2 weeks of
usage (which can be adjusted of course).
To try it out, create an empty access db (or use your current one if you are
using an access database).. Links tables if necessary - adjust for the
fieldnames, and run it. Keep in mind, txtFolderName is a custom field I
added. I then created a graph on a form that simply uses the query, and it
creates a nice visual (whoa, visuals)..
TRANSFORM Count(dbo_Mail.MessageID) AS CountOfMessageID
SELECT Left$([txtFolderName],2) AS Fldr
FROM dbo_Mail INNER JOIN dbo_POPs ON dbo_Mail.AccountNum =
dbo_POPs.AccountNum
WHERE (((dbo_POPs.Domain)=3) AND
((dbo_Mail.datTimeStamp)>DateAdd("d",-14,Now())))
GROUP BY dbo_POPs.Domain, Left$([txtFolderName],2)
ORDER BY Format([dattimestamp],"Short Date") DESC
PIVOT Format([dattimestamp],"Short Date");
hope this helps... BTW - Sorry I've been so darn inactive lately, I've just
been so busy. On the upside though, I'm about ready to start my first paid
iMS installation, configuration and customization for a customer.
cya - Tom
----- Original Message -----
From: Howie Hamlin <[EMAIL PROTECTED]>
To: inFusion Support List <[EMAIL PROTECTED]>
Sent: Thursday, August 31, 2000 8:10 AM
Subject: Re: [iMS] Mail Volume Reporting
> iMS keeps stats and stores them in standard INI files. By default, these
> are in a folder called "Stats". The format is documented in the manual.
> So, all you would need is a program to read the Stats files.
>
> Regards,
>
> Howie
>
> ----- Original Message -----
> From: "Brett Payne-Rhodes" <[EMAIL PROTECTED]>
> To: "inFusion Support List" <[EMAIL PROTECTED]>
> Sent: Thursday, August 31, 2000 4:20 AM
> Subject: [iMS] Mail Volume Reporting
>
>
> > Hi All,
> >
> > Is anyone doing any reporting on traffic volumes from the iMS mail logs?
> > If so could you provide any tips on the best way to approach the issue
> > please? Some sample code perhaps?
> >
> > Many Thanks,
> >
> > Brett Payne-Rhodes
> > B)
> >
>
>
> ========================================================================
> This list server is Powered by iMS
> 'The Swiss Army Knife of Mail Servers'
> --------------------------------------
> To leave this list please complete the form at
> http://www.CoolFusion.com/iMS.htm
>
> List archives: http://www.mail-archive.com/infusion-email%40eoscape.com/
> ========================================================================
========================================================================
This list server is Powered by iMS
'The Swiss Army Knife of Mail Servers'
--------------------------------------
To leave this list please complete the form at
http://www.CoolFusion.com/iMS.htm
List archives: http://www.mail-archive.com/infusion-email%40eoscape.com/
========================================================================
