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
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.
CustomerDBReport
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
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
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.
VSDBReport
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.
Comments
0 comments
Article is closed for comments.