How To's

A comprehensive repository of information on Exchange Reporter Plus. Go through our knowledge base and get answers to your frequently asked questions, error messages and how to’s, all at one place.

FAQ
How To's
Troubleshooting
Tips and Tricks
PowerShell
 
 

Caution: DO NOT uninstall Exchange Reporter Plus at the previous machine until the new installation works fine.

Prerequisite for Migration:

For successful migration of data, the product at both locations MUST belong to the same build number. To check the build number of Exchange Reporter Plus from the existing installation, click on 'license' link at the top right corner in the product interface. If the existing build number is an older one, please click here to upgrade.

Note: Please be particular while following the steps provided in the above link for service pack upgrade.

Steps to migrate Exchange Reporter Plus to a different server:
  1. 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 an NT Service, please stop the service. (Start → Run → Type 'services.msc' → Stop "ManageEngine Exchange Reporter Plus")

  2. Open command prompt (Run as administrator) → Navigate to <installation dir.>\Exchange Reporter Plus\bin → Execute "backupDB.bat" file to create a backup of the existing DB. A folder named "Backup" will be created under <installation dir.>
  3. (eg: C:\Program Files\Manage Engine\Exchange Reporter Plus), shall contain the DB in compressed file format(eg : 101217-1054.zip).

  4. *Take a copy of Patch Folder from <installation dir\Exchange Reporter Plus>

    *Applicable ONLY IF the product in the previous server is a migrated one. (Service Pack applied)

  5. Download and Install the same build of Exchange Reporter Plus on a new server machine. Click here to download the latest '.exe' file. Contact support@exchangereporterplus.com in case if any assitance is required.
  6. Stop Exchange Reporter Plus (Click on Start → All Programs → Exchange Reporter Plus → Stop Exchange Reporter Plus) on the new server machine. Copy the compressed file format (DB) and Paste it under the <installation dir.>\bin (eg: C:\ManageEngine\Exchange Reporter Plus\bin).
  7. *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)).
  8. Open 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 DB in the new server machine.
  9. Start Exchange Reporter Plus. (Click on Start → All Programs → Exchange Reporter Plus → Start Exchange Reporter Plus)

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
  3. At the "IPv$ local connections:" session, add the following entries:

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

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

 

 

 

Request Support

Need further assistance? Fill this form, and we'll contact you rightaway.

Exchange Reporter Plus trusted by

A single pane of glass for Exchange Server Monitoring, Reporting and Auditing
×
Yes I'm Interested No, I'd rather pay more.