Marshal Reporting Console 2.6 Release Notes

Release 2.6.0, Last Revision: September 05, 2018

These notes are additional to the Marshal Reporting Console Installation Guide and Help.

The information in this document is current as of the date of publication. To check for any later information, please see Trustwave Knowledge Base article Q21044.

New Features
Supported SEG, ECM, and WebMarshal Versions
System Requirements
Installation Instructions
Upgrade Instructions
Release History

New Features

For more information about additional minor features and bug fixes, see the release history.

Features New in 2.6

Supports installation on Windows Server 2016.
Supported and bundled database software updated to SQL Express 2016.
Updated export formats including Excel 2013 and Word 2013.

Features New in 2.5.4

Supports installation on Windows 2012 and 2012 R2.
Bundled database software updated to SQL Express 2008 R2 with Service Pack 2 as required for use with Windows 2012.

Features New in 2.5

Supports reporting for MailMarshal Exchange 7.X.
Includes the MailMarshal SMTP Executive Summary report previously provided as an add-on.
Supports additional operating systems and SQL server versions; requires updated service packs in some cases.
No longer supports some older versions of MailMarshal SMTP and WebMarshal.

Supported Trustwave SEG, ECM, and WebMarshal Versions

Marshal Reporting Console version 2.6 supports reporting on supported versions of SEG, ECM, and WebMarshal.

Trustwave SEG 7.5.5 and above
WebMarshal 6.11.2 and above
Trustwave ECM 7.1.7 and above

Reporting on unsupported product versions is deprecated and has not been tested.

For known issues see the Upgrade Notes.

System Requirements

The following are hardware and software prerequisites for the Marshal Reporting Console installation.

When you install MRC 2.6 with the licensed version of SQL Server and SSRS, both SQL Server and SSRS must be installed on the computer where MRC is installed. MRC 2.6 checks for the presence of SQL Server.
SEG, ECM, or WebMarshal databases (the data to be reported on) can reside on any SQL Server that is supported by the SEG, ECM, or WebMarshal version.
If Reporting Console databases are installed on the same computer as the SEG, ECM, or WebMarshal databases to be reported on, the requirements for those databases must also be considered. For information about database sizing, see the User Guide for each product.

Table 1: System Requirements
Category	Requirements
Processor	Core i5 or similar performance
Disk Space	Free disk space to support databases, and additional space for temporary files during installation. 10GB free recommended. If installing standalone, SQL Express requires a minimum of 2 GB of free disk space for installation (in addition to database storage space)
Memory	6GB
Supported Operating Systems	Windows Server 2016, Server 2012 and Server 2012 R2 Windows Server 2008 SP2, 32 or 64 bit versions, and Server 2008 R2 Windows 7 Windows 10 is not* supported)*
Network Access	TCP/IP protocol Domain structure
Software	SQL Server 2016 SP2, 2016 Express SP2 SQL Server 2014 SP2, 2014 Express SP2 SQL Server 2012 SP4, 2012 Express SP4 SQL Server 2008 R2 SP2, SQL Server 2008 R2 Express Advanced Edition SP2 Mixed Mode authentication enabled for SQL. Internet Information Services (IIS) as installed with supported Operating System versions (Windows Authentication is required) .NET Framework 3.5 SP1 (SQL Express 2016 requires .NET Framework 4.6) Note: The Marshal Reporting Console installer also installs the Microsoft Report Viewer.
Supported Browsers (for client workstations)	Internet Explorer (10 or 11) Note: The MRC website will not work correctly if Internet Explorer Enhanced Security Configuration is enabled on the computer you are browsing from (Windows Server operating systems). IEESC blocks active content such as the ASP.NET code used by MRC. This behavior is by design. Adding the MRC site to "safe sites" may not resolve all issues created by IEESC. Microsoft Edge Firefox and Chrome current versions.

Installation Instructions

For help with installation, see the Installation Guide available from the Trustwave website.

When you install MRC 2.6 with the licensed version of SQL Server and SSRS, both SQL Server and SSRS must be installed on the computer where MRC is installed. MRC 2.6 checks for the presence of SQL Server.
Problems connecting to the Report Server during installation could be caused by proxy settings. See Trustwave Knowledge Base article Q12205.
For help with the message "The SQL Server 2005 Express Tools are installed. To continue, remove the SQL Server 2005 Express Tools," see Trustwave Knowledge Base article Q14064.
When installing prerequisites on Windows XP, be sure that IIS is enabled before you install the .NET framework. If you do not follow this sequence, the SQL Express Advanced or Marshal Reporting Console installation will fail. For more information, see Trustwave Knowledge Base article Q12054.

The following Knowledge Base articles may also be of interest:

Q12088: Setting up automatic logon to Web Based Reports
Q12090: Browser security settings affect Reporting Console function
Q12126: User permissions lost after deleting and re-creating Active Directory group
Q14156: "The setup has detected that no version of Marshal Reporting Console is installed"

Upgrade Instructions

Marshal Reporting Console 2.6 can be used to upgrade Marshal Reporting Console 2.5.4 and above. (To upgrade from earlier versions, first upgrade to 2.5.4.)

Upgrade Notes:

MRC 2.6 Supported SQL Server versions: The minimum version of SQL Server for the MRC configuration database is SQL 2008 R2, SP2. Before upgrading, you must migrate the database to a supported SQL Server version.
MRC 2.6 Supported Operating System versions: The minimum Operating System versions are Windows 7 or Windows Server 2008
MRC 2.6 Minimum Supported Product Database versions: If you attempt to upgrade an installation that uses a MailMarshal 6.7 database, the upgrade will fail.
- 6.7 is not a supported product version. Remove the version 6.7 database from MRC configuration or upgrade to a supported Trustwave SEG version before attempting to upgrade MRC.
MRC 2.6 Edited RDL Files: If you have modified any Report Definitions files (.RDL), they will not be updated. Fixes to the Summary Usage and Receiver Rules Overview reports will not be applied. Changes to default report expansion will not be applied.
- To ensure that new RDLs are installed, move any edited RDLs before upgrading.
MRC 2.5.3 Application Pool change:

If MRC is installed on IIS 7 and above, the installer creates a new IIS application pool "MRC Application Pool" and sets the MRC web application to use this pool. The reason for this change is to ensure correct settings and avoid conflicts with other applications. By default this application pool uses the Network Service identity. If you want to continue to use a different application pool for MRC, you must edit the settings in IIS Manager.
Before upgrading, ensure that the operating system and SQL Server are updated to the required service pack level.
The MRC upgrade installer requires several GB of free disk space for the installer package and temporary files.
You will be required to re-enter the password of the impersonation account.
Upgrading updates the existing configuration database, and updates stored procedures as necessary in configured product databases.
All existing database configurations and scheduled reports are retained.

Marshal Reporting Console can also be installed side by side with the earlier MailMarshal Reports and WebMarshal Reports applications.

Release History

The following additional items have been changed or updated in the specific build versions of Marshal Reporting Console listed.

Note: The information in this document is current as of the date of publication. To check for any later information, please see Trustwave Knowledge Base article Q21044.

2.6.0 (September 05, 2018)

MRC-1238	The bundled version of the SSRS Report Viewer is updated to 2016.
MRC-1265	Scaling and labels of the graph in the Summary Usage (Executive Summary) report were incorrect for graphs with more than one month of data. Fixed.
MRC-1323	The report executor could fail due to an issue with storing passwords longer than 32 characters. The limit is increased to 100 characters.
MRC-1324	PDF reports are now generated with all sections expanded by default.
MRC-1349	The Support Tool executable is installed with MRC.
MRC-1354	In earlier versions, the Impersonate user could not be set on Windows versions where the name of the Administrators group was localized in a language other than English. Fixed.
MRC-1355	Usernames for Windows authentication to product databases could not include the hyphen character. Fixed.
MRC-1356	Windows service path entries are quoted to mitigate a known vulnerability.
MRC-1359	The SEG, ECM, or WebMarshal "Operational User" is granted permission to run MRC reports. (Installing or upgrading report stored procedures still requires connection with sysadmin privilege).
MRC-1361	Scaling and labels of the graph in the Receiver Rules Overview report were incorrect for larger values. Fixed.
MRC-1370	The product is rebranded for Trustwave.

2.5.4.1263 (December 12, 2013)

MRC-1352

Installation on Windows 2012 and 2012 R2 is supported. The included version of SQL Express is updated to Express 2008 R2 Service Pack 2.

2.5.3.1255 (March 19, 2013)

MRC-1328	New installations of MRC create a dedicated Application Pool in IIS with appropriate settings.
MRC-1336	The WebMarshal Graph of Usage By User Per Day report had incorrect date formatting and display errors in the X axis labels. Fixed.
MRC-1337	The WebMarshal Graph of Usage By User Per Day report could return data out of order. Fixed.
MRC-1338	The rule name selection menu for WebMarshal Blocked Requests by Rule was not populated. Fixed.
MRC-1339	Reports that include rule names in the output could fail for rule names over 100 characters in length. Fixed: names up to 2000 characters are now allowed.
MRC-1340	Visual C++ 2010 libraries installed as prerequisite are updated to SP1.
MRC-1342	The product is rebranded for Trustwave.
MRC-1347	The Configuration Wizard now runs as Administrator to ensure appropriate access.

2.5.2.1214 (November 21, 2011)

MRC-1319	The report Summary by Selected Classification showed incorrect information in detail views (remote email addresses instead of local addresses). Fixed.
MRC-1320	Daily scheduled reports could be generated at the incorrect time due to timezone offset not being applied. Fixed.
MRC-1321	Weekly scheduled reports could be generated at the incorrect time due to timezone offset not being applied. Fixed.

2.5.1.1208 (April 21, 2011)

MRC-1299	On slower systems, the installer could incorrectly report that the website Virtual Directory was not created. Fixed.
MRC-1306	The installer could not use a 32-bit instance of SSRS on a system where a native 64-bit instance of SQL Server was also present. Fixed.

2.5.0.1189 (March 30, 2011)

MRC-989	Quota reports did not provide a heading for the "Active Periods" column. Fixed for new installations only.
MRC-1124	Users could not be selected for WebMarshal Reports due to a missing SQL stored procedure. Fixed.
MRC-1128	Some WebMarshal rule classes were labeled as GUID strings instead of the text names. Fixed.
MRC-1142	Some reports failed on case-sensitive SQL server installations. Fixed.
MRC-1143	The reports "Blocked Requests by Rule" and "Blocked Requests by User" failed when a large scope was selected, due to incorrect data type of an aggregate variable. Fixed.
MRC-1147	The MailMarshal SMTP Executive Summary did not limit the "delivered" category to successful deliveries. Fixed.
MRC-1148	All product database connections now support Windows Authentication.
MRC-1203	The installer now checks for and if necessary enables the IIS Static Content role feature.
MRC-1207	Scheduled reports ran in UTC time rather than server local time for time zones with positive offset. Fixed.
MRC-1227	The Graph of Top 10 Logged Classifications report could be scaled incorrectly. Fixed.
MRC-1234	The Virus Detail by Source report had minor issues with data labeling. Fixed.
MRC-1241	The Virus Summary by Domain report used incorrect time zone handling stored procedures. Fixed.
MRC-1243	The Virus Detail by Source report had minor issues with data labeling. Fixed.

2.1.0.843 (April 28, 2009)

MRC-840	When Marshal Reporting Console is installed on the same server as SQL Server Reporting Services, the configuration wizard allows you to set up required SSRS configuration if necessary.
MRC-846	The currency symbol used in some reports is now configurable.
MRC-852	When connecting to a WebMarshal database you can select SQL or Windows authentication.
MRC-862	The product has been renamed as Marshal Reporting Console.
MRC-869	The "select" list used on some report parameter pages is now implemented as a paged modal popup window to support large lists of items.
MRC-1027	Email addresses set in the "Exception Notifications Recipients" field received an email every time a report was successfully generated. Fixed: Email is only sent to these recipient if there is an error.

2.0.1.438 (August 06, 2008)

Initial Product Release

Legal Notice

All rights reserved. This document is protected by copyright and any distribution, reproduction, copying, or decompilation is strictly prohibited without the prior written consent of Trustwave. No part of this document may be reproduced in any form or by any means without the prior written authorization of Trustwave. While every precaution has been taken in the preparation of this document, Trustwave assumes no responsibility for errors or omissions. This publication and features described herein are subject to change without notice.

While the authors have used their best efforts in preparing this document, they make no representation or warranties with respect to the accuracy or completeness of the contents of this document and specifically disclaim any implied warranties of merchantability or fitness for a particular purpose. No warranty may be created or extended by sales representatives or written sales materials. The advice and strategies contained herein may not be suitable for your situation. You should consult with a professional where appropriate. Neither the author nor Trustwave shall be liable for any loss of profit or any commercial damages, including but not limited to direct, indirect, special, incidental, consequential, or other damages.

The most current version of this document may be obtained from Trustwave Knowledge Base article Q21044.

Trademarks

Trustwave and the Trustwave logo are trademarks of Trustwave. Such trademarks shall not be used, copied, or disseminated in any manner without the prior written permission of Trustwave.

About Trustwave®

Trustwave is a leading provider of compliance, Web, application, network and data security solutions delivered through the cloud, managed security services, software and appliances. For organizations faced with today's challenging data security and compliance environment, Trustwave provides a unique approach with comprehensive solutions that include its TrustKeeper® portal and other proprietary security solutions. Trustwave has helped hundreds of thousands of organizations—ranging from Fortune 500 businesses and large financial institutions to small and medium-sized retailers—manage compliance and secure their network infrastructures, data communications and critical information assets. Trustwave is headquartered in Chicago with offices worldwide. For more information, visit https://www.trustwave.com.