<div>
<div class="content wysiwyg-content">
Hi all,<br />
<br />
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. &nbsp;The reason being that mounting and unmounting databases within GFI is time consuming.<br />
<br />
Does anyone know how to query a database for this type of information? &nbsp;I am unfamiliar with SQL queries as well so all help is greatly appreciated<br />
<br />
We are running SQL 2005 R4 on Windows 2008 R2 Standard<br />
<br />
Kind Regards,
</div>
</div>


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,

How to view emails in a GFI Database

Microsoft SQL Server is a suite of relational database management system (RDBMS) products providing multi-user database access functionality.SQL Server is available in multiple versions, typically identified by release year, and versions are subdivided into editions to distinguish between product functionality. Component services include integration (SSIS), reporting (SSRS), analysis (SSAS), data quality, master data, T-SQL and performance tuning.

Microsoft SQL Server

Software is any set of instructions that directs a computer to perform specific tasks or operations. Computer software consists of programs, libraries and related non-executable data (such as documentation). Computer software is non-tangible, contrasted with computer hardware, which is the physical component of computers. Software written in a machine language is known as "machine code". However, in practice, software is usually written in high-level programming languages than machine language. High-level languages are translated into machine language using a compiler or interpreter or a combination of the two.