Knowledge Base

Note: If your Exchange Reporter Plus installation is connected to a Microsoft SQL database, please make a note of the native client version used in the old server. Install the same native client version in the new Microsoft SQL server.

1. To check the native client version on the old server, navigate to Start → Add or remove programs.
2. Use the search bar to look for the term "Microsoft SQL Server".
3. The version of the native client installed on the old server will be displayed.

Use the links present in the table below to download the respective native client version and install them in the new server.

SQL server version	Native client
2008 R2	Download
2012	Download

1. Stop Exchange Reporter Plus on the old server

1. Click Start → All Programs → Exchange Reporter Plus → Stop Exchange Reporter Plus.
2. In case you have installed Exchange Reporter Plus as an NT Service, please stop the service. (Start → Run → Type 'services.msc' → Stop ManageEngine Exchange Reporter Plus).

2. Stop services in Resource Monitor on the old server

1. Open Resource Monitor and make sure the following services are stopped under Exchange Reporter Plus:
   • Postgres service
   • Redis service
   • Elasticsearch wrapper

3. Copy and paste the Exchange Reporter Plus installation folder

1. Check if you can directly copy and paste the installation folder of Exchange Reporter Plus from the old server onto the new server.
2. If it cannot be done, compress the entire installation folder of Exchange Reporter Plus from the old server and then extract it onto the new server.

4. Run the essential batch files in the install directory

1. Run Command Prompt with administrator rights.
2. Navigate to <install dir\bin> and run both initPgsql.bat and setPermission.bat on the new server.

5. Start Exchange Reporter Plus on the new server

1. Install it as a service using InstallService.exe under the bin folder.
2. This will bring up the following user interface. Please provide the credentials of a user who has administrative privileges on the local machine where the product is installed.



3. Once the Exchange Reporter Plus service is installed you can start the product as a Windows service.

Post-requisites:

1. If custom logos and notification templates were configured, please verify if they still work. If they do not work, reconfigure them by adding them to the product.
2. Change the default storage path for all scheduled reports.
3. Change the archive location, if necessary.

Caution: Please take a COPY of pgsql from ' \ManageEngine\Exchange Reporter Plus' to avoid accidental data loss.</installation>

Steps to Configure Database:

1. Copy pgsql folder to the destination locaiton.
2. Edit pg_hba.conf located at <installation directory>\ManageEngine\Exchange Reporter Plus\pgsql\data\pg_hba.conf

At the "IPv$ local connections:" session, add the following entries:

host all all <IP of the machine in which the ERP is installed> trust

3. Open pgsql\data\postgresql.conf Search for #listen_address='localhost' and replace it with listen_address='<IP address to listen>'
4. Open Exchange Reporter Plus home folder and navigate to bin (C:\ManageEngine\ExchangeReporterPlus\bin\setcommonenv.bat)

Search for set DB_HOME=%SERVER_HOME%\pgsql and replace it with admin share path of pgsql folder.

Eg: If the pgsql is copied to C:\DbBackup\pgsql, the admin share path would be \\<ip of pgsql machine>\c$\DbBackup\pgsql

Note:The remote pgsql installation will work only if the admin share is accessible from the machine where Exchange Reporter Plus is installed.

In an attempt to handle reported issues with better care, we need to find the root cause by accessing your logs.

Steps to upload the logs :

1. Compress the logs folder located at <installation dir.> (e.g. C:\ManageEngine\Exchange Reporter Plus\logs).
2. Click here to upload the log files.
3. Select Exchange Reporter Plus from the product drop down list.
4. Provide your the required details. Please briefly describe the issue in the 'reason' field along with your 'contact number' for better assistance.
5. Attach the log files using "Add Files" button and click on "Upload" button to upload logs.

To backup Exchange Reporter Plus database, follow the below mentioned steps.

• Stop Exchange Reporter Plus (Click on Start → All Programs → Exchange Reporter Plus → Stop Exchange Reporter Plus).

Note : In case you have installed Exchange Reporter Plus as a NT Service, stop the service (Start → Run → type services.msc → Stop "ManageEngine Exchange Reporter Plus" ).

• Open the command prompt (Run as administrator) → Navigate to <installation dir.>\Exchange Reporter Plus\bin → Execute “backupDB.bat” file to take a backup of your existing database.

A folder named “Backup” will be created under <installation dir.> (eg: C:\Program Files\Manage Engine\Exchange Reporter Plus), which will contain the database in compressed file format(eg : 101217-1054.zip).

Backup/restore of database is applicable to same build number of Exchange Reporter Plus. You can get the current build number under the "License" link.

• *Take a copy of Patch Folder present in <installation dir>\Exchange Reporter Plus folder (*Applicable only if the Exchange Reporter Plus in old server is a migrated one(Service Pack applied)).
• Download and install the same build number of Exchange Reporter Plus on a new server machine.

https://www.manageengine.com/products/exchange-reports/download.html

• Stop Exchange Reporter Plus (Click on Start → All Programs → Exchange Reporter Plus → Stop Exchange Reporter Plus) on the new server machine and copy and paste the compressed file format (database) under the <installation dir.>\bin (eg: C:\ManageEngine\Exchange Reporter Plus\bin).
• Paste the Patch Folder under the <installation dir\Exchange Reporter Plus> (as mentioned in step 3) (*Applicable only if the Exchange Reporter Plus in old server is a migrated one(Service Pack applied)).
• Open the command prompt (Run as administrator) → Navigate to <installation dir.>\Exchange Reporter Plus\bin → Run the batch file "restoreDB.bat" from command prompt with the compressed file format (eg: restoreDB.bat 101217-1054.zip) to restore the database in new server machine.

You can connect to the Exchange Reporter Plus database using a web browser. Type in the below text in the address bar and get access to your database.

http://ServerName:8181/exchange/runQuery.do

The gathered data is stored in the PGSQL database located on the Exchange Reporter Plus installation directory. During the automatic cleanup process, only the "Hourly Based" data for reports "Organization Traffic", "Server Traffic", "Custom Recipients Traffic", "Distribution List Traffic" and "Mailbox Traffic" will be cleaned up automatically after 35 Days. All other data will not get deleted.

To access Exchange Reporter Plus, double click on the desktop shortcut icon of Exchange Reporter Plus.

The product can also be started from

Start → Programs → Exchange Reporter Plus → Start Exchange Reporter Plus

Alternatively, you can open a Web browser and type http://<hostname>:<port number> in the address bar. Hostname refers to the DNS name of the machine where Exchange Reporter Plus is running and the "port number" is the port at which Exchange Reporter Plus is running. The default port number is "8181".

For Exchange Reporter Plus to be started as a Windows Service, stop the console (Click on Start--> All Programs --> Exchange Reporter Plus --> Stop Exchange Reporter Plus) and then install "Exchange Reporter Plus Service" (Click on Start → All Programs → Exchange Reporter Plus → Service → Install "Exchange Reporter Plus Service").

When you install "Exchange Reporter Plus Service", it will invoke a User Interface. Please provide the credentials of a user who has the administrative privileges on the local machine where the product is installed.

Once the "Exchange Reporter Plus Service" is installed, you can start the product as "Windows service". When Exchange Reporter Plus is started in Windows XP / Windows 2003 machines with firewall enabled, Windows may pop up security alerts asking whether to block or unblock Java(TM) Platform SE binary program. Unblock this program to start Exchange Reporter Plus.

OWA logs provide the much needed information for the Exchange reports. Hence it is important to check if the logging is enabled or not.

To check if OWA logging is enabled:

For IIS 6.0

• Open IIS manager by clicking Start → Control Panel → Administrative Tools → Internet Information Services (IIS) Manager.
• Expand server → Websites → Default Web Site. Right click to select Properties.
• Check if ‘Enable Logging’ is enabled.

For IIS 7.0

• Open IIS manager by clicking Start → Control Panel → Administrative Tools → Internet Information Services (IIS) Manager.
• Expand server → Sites → Default Web Site. In the home pane, double click on Logging.
• In the Actions pane, check if disable is displayed indicating that logging has been enabled.

To check if MTL logging in enabled:

• For Exchange Server 2003, open the Exchange System Manager and right click against the server to open ‘Properties. From the Properties dialog and under the ‘General’ tab, check if message tracking is enabled.
• For Exchange Server 2007 and 2010, open the Exchange Management Console. Click on the ‘Hub Transport’; right click against the server and click on 'Properties'. Under ‘Log Settings’ tab, check if message tracking logging is enabled.