You must trim the FSA Reporting database's history tables regularly to keep them at a manageable size, while retaining recent and trend-related information. Enterprise Vault provides a trimming utility for this purpose. The utility removes data beyond a specified age, but it retains the data for the trend reports.
The trimming utility is named FSAReporting_TrimData.bat. It is located in the FSAReports subfolder of the Enterprise Vault program folder, typically:
C:\Program Files\Enterprise Vault\FSAReports
For security reasons only the FSA Reporting user can execute the utility. The FSA Reporting user is the Windows user account that you specified for FSA Reporting to use when you ran the FSA Reporting Configuration wizard.
To trim the FSA Reporting database history tables
By default, the trimming utility trims the FSA Reporting data that is related to all file servers for which Enterprise Vault holds FSA Reporting data. To specify a list of file servers on which the utility is to act, place an XML file in the same folder as the trimming utility. The XML file must contain a single line in the following format:
<FileServerList><FileServer Name=''Site\Domain\FileServer''/></FileServerList>
The file server name must use the format ''Site\Domain\FileServer'', even if the file server is specified in the Administration Console using an IP address. You must enclose the file server name in two pairs of single quotes as shown, not double quotes. The FSAReports folder contains an example XML file with a line in the required format.
The following example specifies two file servers for which to trim FSA Reporting data. Remember, the text must be contained on a single line:
<FileServerList><FileServer Name=''EVSite\MyDomain\Fileserver1''/><FileServer Name=''EVSite\MyDomain\Fileserver2''/></FileServerList>
Open a command prompt window and change directory to the folder that contains the trimming utility.
Enter the following command to run the trimming utility:
FSAReporting_TrimData.bat "SQL_Server" trim_period "server_list"
SQL_Server is the name of the SQL Server where the EnterpriseVaultFSAReporting database is located. Include the SQL Server instance name if appropriate, for example SQLServer1\instance1.
trim_period is the period in days for which you want to retain data. Data older than the specified number of days is deleted.
server_list is the name of the XML file that specifies the list of servers. If you do not use an XML file, either specify ALL or omit the server_list variable, since the utility uses a value of ALL by default.
Note that the parameters SQL_Server and server_list must be enclosed in double quotes.
For example, the following command retains the last 30 days of data for all file servers, for a database that is located on SQLServer1\instance1:
FSAReporting_TrimData.bat "SQLServer1\instance1" 30 "ALL"
The following command retains the last 10 days of data for the file servers that are listed in the file fileserverlist.xml, and for a database that is located on SQLServer1:
FSAReporting_TrimData.bat "SQLServer1" 10 "fileserverlist.xml"
The utility logs its output to EV_FSAReporting_TrimOldData.log in the utility's folder. Examine this log file to check the results of running the utility.