Solved

How to view emails in a GFI Database

Posted on 2014-01-06
1
290 Views
Last Modified: 2014-01-12
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,
0
Comment
Question by:BCSITS
1 Comment
 
LVL 17

Accepted Solution

by:
Barry Cunney earned 500 total points
ID: 39765444
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

Featured Post

VMware Disaster Recovery and Data Protection

In this expert guide, you’ll learn about the components of a Modern Data Center. You will use cases for the value-added capabilities of Veeam®, including combining backup and replication for VMware disaster recovery and using replication for data center migration.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Let’s list some of the technologies that enable smooth teleworking. 
In our personal lives, we have well-designed consumer apps to delight us and make even the most complex transactions simple. Many enterprise applications, however, are a bit behind the times. For an enterprise app to be successful in today's tech wo…
Via a live example, show how to extract insert data into a SQL Server database table using the Import/Export option and Bulk Insert.
This videos aims to give the viewer a basic demonstration of how a user can query current session information by using the SYS_CONTEXT function

856 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question