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: 2012-05-10 | | | Article URL http://www.symantec.com/docs/TECH67463 |
Problem
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.
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.
Attachments
|
|
| Value | 1458892 |
| 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
Thank you.