Enterprise Vault, Compliance Accelerator and Discovery Accelerator Environment Reports

Problem

This article contains the Environment Report data-gathering scripts. These scripts should be used under the guidance of technical support.

Solution

It may not be required to run all scripts; please run the required scripts as guided by technical support. Extract the applicable script(s) from the attachment below, run the script(s) per the instructions below and upload the results for review.

Note: These scripts can take from minutes to hours to run. They perform no data manipulation - their only purpose is to gather data. They do have a slight overhead, but are safe to run in a production environment.

ConfigurationDBReport (CA or DA Configuration Database Report)

Run the ConfigurationDBReport utility on the SQL Server that houses the CA/DA databases against the appropriate Configuration database. This utility will capture information about the database - no data will be changed.
- Save the ConfigurationDBReport_Vxxx.sql file on the SQL Server hosting the Accelerator databases.
- Open SQL Server Management Studio (SSMS), select the Configuration database and start a new Query.
- Change the output format to Results To File under Query | Results To | Results To File.
- Copy/Paste the contents of the file into a new query window, or open the file from SSMS.
- Execute the query and save to a .RPT file as prompted.
- Upload the (zipped) .rpt file for analysis.

CustodianManagerDBReport (Custodian Manager Database Report)

Run the CustodianManagerDBReport utility on the SQL Server that houses the CA/DA databases against the appropriate CustodianManager database. This utility will capture information about the database - no data will be changed.
- Save the CustodianManagerDBReport_Vxxx.sql file on the SQL Server hosting the Accelerator databases.
- Open SQL Server Management Studio (SSMS), select the CustodianManager database and start a new Query.
- Change the output format to Results To File under Query | Results To | Results To File.
- Copy/Paste the contents of the file into a new query window, or open the file from SSMS.
- Execute the query and save to a .RPT file as prompted.
- Repeat for any more Customer databases as needed.
- Upload the (zipped) .rpt file for analysis.

CustomerDBReport (CA/VAS or DA Customer Database Report)

Run the CustomerDBReport utility on the SQL Server that houses the CA/DA databases against the appropriate Customer database(s). This utility will capture information about the database - no data will be changed.
- Save the CustomerDBReport_Vxxx.sql file on the SQL Server hosting the Accelerator databases.
- Open SQL Server Management Studio (SSMS), select the Customer database and start a new Query.
- Change the output format to Results To File under Query | Results To | Results To File.
- Copy/Paste the contents of the file into a new query window, or open the file from SSMS.
- Execute the query and save to a .RPT file as prompted.
- Repeat for any more Customer databases as needed.
- Upload the (zipped) .rpt file for analysis.

EVDDBReport (EnterpriseVaultDirectory Database Report)

Run the EVDBReport utility on the SQL Server that houses the EV databases against the EnterpriseVaultDirectory database. This utility will capture information about the database - no data will be changed.
- Save the EVDDBReport_Vxxx.sql file on the SQL Server hosting the EV databases.
- Open SQL Server Management Studio (SSMS), select the EnterpriseVaultDirectory database and start a new Query.
- Change the output format to Results To File under Query | Results To | Results To File.
- Copy/Paste the contents of the file into a new query window, or open the file from SSMS.
- Execute the query and save to a .RPT file as prompted.
- Upload the (zipped) .rpt file for analysis.

RegistryReport (Server or Workstation Registry Report)

Run the RegistryReport batch file on each EV/CA/DA/SQL Server. This batch file will capture the Enterprise Vault specific information from the Registry and write the information to a text file on the desktop with the server name.
- Rename the RegistryReport_Vxxx.bat.txt file to RegistryReport_Vxxx.bat.
- On each EV, CA, DA and SQL Server in the environment, browse to the batch file location via an elevated command prompt, type the name of the batch file and press enter to execute it. To open an elevated command prompt, use one of the following:
-- Right-click the Windows menu taskbar icon at the bottom left of the desktop | Select 'Command Prompt (Admin)'.
-- Open the Start Menu or Start Screen | Type: cmd | Right-click on 'Command Prompt' | Select 'Run as administrator'.
-- Open the Start Menu or Start Screen | Type: cmd | Hold the Shift and Ctrl keys then hit Enter.
- Please gather all the results text files and upload them in zipped format. Please indicate each servers' role: EV, CA, DA, SQL.

SQLReport (SQL Server Report)

Run the SQLReport utility on the SQL Server that houses the EV databases. This utility will capture information about the SQL server - no data will be changed.
- Save the SQLReport_Vxxx.sql file on the SQL Server hosting the EV databases.
- Open SQL Server Management Studio (SSMS), select the Master database under System Databases and start a new Query.
- Change the output format to Results To File under Query | Results To | Results To File.
- Copy/Paste the contents of the file into a new query window, or open the file from SSMS.
- Execute the query and save to a .RPT file as prompted.
- Upload the (zipped) .rpt file for analysis.

VSDBReport (Vault Store Database Report)

Run the VSDBReport utility on the SQL Server that houses the EV Vault Store databases. This utility will capture information about the database - no data will be changed.
- Save the VSDBReport_Vxxx.sql file on the SQL Server hosting the EV databases.
- Open SQL Server Management Studio (SSMS), select the Vault Store database and start a new Query.
- Change the output format to Results To File under Query | Results To | Results To File.
- Copy/Paste the contents of the file into a new query window, or open the file from SSMS.
- Execute the query and save to a .RPT file as prompted.
- Repeat for any more Vault Store databases as needed.
- Upload the (zipped) .rpt file for analysis.

VSGFPDBReport (Vault Store Group Fingerprint Database Report)

Run the VSGFPDBReport utility on the SQL Server that houses the EV Vault Store Group Fingerprint databases. This utility will capture information about the database - no data will be changed.
- Save the VSGFPDBReport_Vxxx.sql file on the SQL Server hosting the EV databases.
- Open SQL Server Management Studio (SSMS), select the Vault Store Group Fingerprint database and start a new Query.
- Change the output format to Results To File under Query | Results To | Results To File.
- Copy/Paste the contents of the file into a new query window, or open the file from SSMS.
- Execute the query and save to a .RPT file as prompted.
- Repeat for any more Vault Store databases as needed.
- Upload the (zipped) .rpt file for analysis.