Mail Express Server stores all files that have been stripped from email message by the Mail Express Outlook Add-in or sent via any Mail Express web portal with obfuscated file names for security. However, there could be cases in which those files need to be retrieved from the server. The Mail Express "Document Mapping Tool" (DMT) is designed to assist administrators with locating and retrieving any attachments that have passed through the system.
The DMT is located on the Mail Express server and can be run directly from there. If you run the tool on a system other than the Mail Express Server and no SQL client is present on that system, you will need to download and install the following utilities:
SQL Server 2008 R2 Express installs with TCP/IP connections disabled. If you choose to run the tool on a system other than Mail Express or the database server, the database must be configured to allow queries from remote systems, with a TCP/IP listener enabled for at least one IP address, as described below:
Launch the SQL Server Configuration Manager (Start->All Programs->Microsoft SQL Server 2008->Configuration Tools->SQL Server Configuration Manager).
In the left pane, expand the SQL Server Network Configuration node, and then click the Protocols for MAILEXPRESS node.
In the right pane, double-click TCP/IP. The TCP/IP Properties dialog box appears.
Set the Enabled option to Yes.
To listen on all IP Addresses set the Listen All option to Yes or to listen on a subset of IP Addresses set the Listen All option to No and enable specific IP Addresses using the IP Addresses tab.
Click OK to close the dialog box and save your changes.
Click the SQL Server Services node, if it is not already selected.
In the right pane, right-click SQL Server (MAILEXPRESS) and click Restart.
Close the SQL Server Configuration Manager tool.
The DMT can be initiated by double-clicking on the batch file or by calling it from a command prompt (e.g. C:\>"Document Mapping Tool.bat").
The following information will be required for the DMT to communicate with the Mail Express database. All information can be found in the jdbc.properties file located in the Mail Express installation directory under the webapps\ROOT\WEB-INF\classes directory.
Database host name (referenced as "serverName" in the jdbc.properties file)
Database name
Database user name
Database password
Additionally, the DMT will request the following information:
The name of the file in which you would like the query results saved; for example, Results.txt.
The type of search you would like to run. Available options are:
[F]ile name. Exact name of file is required, including extension. For example: Specification.docx
[P]ackage ID. Package ID of the Mail Express package. This can be found as the name of the small html attachment in the email message or via the Mail Express Administration Portal in Reports or File Management. For example: 5P5qG-qfRvjDhF-NYH1ZyYKFkhML04YIxk8Usx2C
Sender [E]mail address. Case insensitive. For example: mailexpress@globalscape.com
[D]ate Range. Format is YYYY-MM-DD 24HH:mi:ss. For example 2011-06-29 15:37:22
For example, you might press D to choose the Date Range option, and then the DMT would ask you to specify the start date of the search, and then the end date of the search.
The query results appear in the results file that you specified, not in the Command window.
Below are sample screen captures of DMT us:
