Modifying the FSA Reporting data collection parameters

You can change the values of some of the parameters that determine what data the Enterprise Vault File Collector service collects for FSAReporting. You can determine the following:

Whether the File Collector service collects data for the Duplicate Files reports.
The selectable options for the inactivity period in the three "Inactive Files" reports.
The parameters that the Largest Files per Volume report uses.

To change any of these parameter values you must edit a parameter value in the SQL Server Properties table of the EnterpriseVaultFSAReporting database.

Note:

Take care if you decide to edit the database table. The File Collector service does not work if the database is corrupted.

Table: Editable parameters in the Properties table of the 'EnterpriseVaultFSAReporting' database lists the details for the parameters for Enterprise Vault 8.0 SP3 and later, whose values you can change.

Note that the supplied value for some of these parameters changed at Enterprise Vault 8.0 SP3, to improve the efficiency of FSA Reporting. On upgrade to Enterprise Vault 8.0 SP3 or later from Enterprise Vault 8.0 SP2 or earlier, Enterprise Vault does as follows:

If you have changed the value, Enterprise Vault retains your value.
Otherwise, Enterprise Vault applies the new supplied value, as shown in the table.

Table: Editable parameters in the Properties table of the 'EnterpriseVaultFSAReporting' database

Parameter

Description

Supplied value (units)

CheckDuplicates

A Boolean value that determines whether the File Collector service collects data for the duplicate files reports:

Duplicate Files on a Server
Duplicate Files Summary
Top Duplicate Files per Volume

The File Collector service does not collect data for these reports by default. The collection of this data causes a slight performance degradation in the File Collector service.

Set this parameter to True if you want to collect data for the duplicate files reports.

False

DAYSOLD

A list of the periods in days for which the File Collector service collects data for the three "Inactive Files" reports. The list defines the options for the Interval input parameter when you run the report.

The list can contain a maximum of 10 comma-separated values, in ascending order.

90,180,365,730 (days)

MBLARGE

A size in megabytes that defines the minimum file size that Enterprise Vault includes in the Largest Files per Volume report.

To set no minimum size, enter a value of 0.

1024 (MB)

TopFiles

The number of files to list in the Largest Files per Volume report.

To change the value, enter a number in the range 0 to 100. If you set a value of 0, FSA Reporting does not collect any data for the report.

Note:

The report lists fewer files than the TopFiles value if there are fewer than that number of files in the volume with a size of MBLARGE or larger.

10 (files)

To modify the FSA Reporting data collection parameters

Start Enterprise Manager for Microsoft SQL Server 2000, or SQL Server Management Studio for SQL Server 2005 or 2008.
Expand the container for the EnterpriseVaultFSAReporting database.
For SQL Server 2000 or SQL Server 2005, right-click the Properties table and select Open Table.

For SQL Server 2008, right-click the Properties table and select Edit top n rows.
Change the values of the modifiable parameters as required.
Save any changes, and exit from Enterprise Manager or SQL Server Management Studio.
If you changed any of the parameter values, restart the Enterprise Vault File Collector service on all NTFS file servers. For NetApp and Celerra file servers you must restart the Enterprise Vault Admin service on the Enterprise Vault server whose File System Archiving task processes the file server.