Hotfix for Symantec Enterprise Vault Compliance Accelerator 7.5, Running the Message Stats Summary report on select departments, returns all departments

Article:TECH67463  |  Created: 2009-01-03  |  Updated: 2014-06-24  |  Article URL http://www.symantec.com/docs/TECH67463
Article Type
Technical Solution


Environment

Issue



Hotfix for Symantec Enterprise Vault Compliance Accelerator 7.5, Running the Message Stats Summary report on select departments, returns all departments  


Solution



To which versions of Symantec Enterprise Vault (tm) can this hotfix be applied?
This hotfix can only be applied to the following versions of Enterprise Vault Compliance Accelerator for:

 2007 [7.5] SP3 and SP4

What issue does this hotfix resolve?

Running the Message Stats Summary report on selective departments, returns all departments not just the selected departments.
This was due to the SQL Stored Procedure used by the Message Stats Summary report ('rpt_MessageStatsByEmployeeSummary_P') using all values from tblReportParameters, rather than the values destined for the report.

The SQL Stored Procedure now uses the supplied 'ReportID' to only select the values destined for the report.

Which files does this hotfix replace?

None

How to install this hotfix:

1. Stop the "Enterprise Vault Accelerator Manager" service.
2. Backup the Compliance Accelerator 'customer' database
3. Run the following SQL script against the Compliance Accelerator 'customer' database.
Etrack1458892.sql
4. Restart the "Enterprise Vault Accelerator Manager" service.

How to uninstall this hotfix:

1. Stop the "Enterprise Vault Accelerator Manager" service.
2. Restore the Compliance Accelerator 'customer' database
3. Restart the "Enterprise Vault Accelerator Manager" service.

 

Supplemental Materials

Value1458892
Description

Running the Message Stats Summary report on selected departments, returns all departments


Legacy ID



318524


Article URL http://www.symantec.com/docs/TECH67463


Terms of use for this information are found in Legal Notices