How to view emails in a GFI Database

Hi all,

I am trying to find out how many incoming/outgoing emails are in a particular GFI Mail Archiver database we have but i would like to complete this at the SQL level.  The reason being that mounting and unmounting databases within GFI is time consuming.

Does anyone know how to query a database for this type of information?  I am unfamiliar with SQL queries as well so all help is greatly appreciated

We are running SQL 2005 R4 on Windows 2008 R2 Standard

Kind Regards,
BCSITSAsked:
Who is Participating?
 
Barry CunneyConnect With a Mentor Commented:
Hi BCSITS,
The following is the type of thing you will have to do in SQL(SQL Server Management Studio):

SELECT
SUM(CASE WHEN p.Direction = 1 THEN 1 ELSE 0 END) [Incoming_Count]
,SUM(CASE WHEN p.Direction = 2 THEN 1 ELSE 0 END) [Outgoing_Count] 
FROM dbo.meces_processed p
WHERE [datetime] BETWEEN '2013-12-01' AND '2013-12-31'

Open in new window


Please try this and then come back with any further questions
0
All Courses

From novice to tech pro — start learning today.