What is/are: File Type Group Data Aggregation Option


The NSS Console is used to display information about how users are using the storage service made available to them; how much data is being created, what types of files are stored, how old is the data, what is the cost of housing this data, how is the situation changing over time, etc. One key component of this breakdown is the analysis of file types.

In NSS 9.6 SR1 and older versions, the SQL queries used to display file-type analysis information in the NSS Console were complex. The time required to execute these queries had a negative impact on the display of all information in the console interface. At NSS 9.6 SR2, a change was introduced where data is aggregated as a part of the scheduled scanning process. This allows for less complex queries to be used in data display, giving a more responsive interface. This aggregation is referred to as File Type Group Data Aggregation. This feature is only relevant to customers using the NSS Console.

The eaxct steps necessary to ensure these pre-requisites are in place are described in the 'Enable this Feature' section below. For general information, the pre-requisites are as follows.

  • It is necessary for all NSS hosts that are adding data to the NSS data database to be running NSS 9.6 SR2 or later. The process of File Type Group Data Aggregation leads to the creation of a separate table within the NSS data database ("FileGroupSummary" table). Only NSS 9.6 SR2 or later servers will maintain this table. The NSS 9.6 SR2 console supports display of data from the aggregate table, or from the old raw data tables. It does not support the combination of data from both tables. If the aggregate table exists in the database, the NSS console will always use it.
  • The NSS Core Server service and the NSSX Server service accounts must have the ability to execute aggregation procedures on the NSS data database. These accounts must have the explicit 'Execute' permission on the database or have the db_owner role.
  • The NSSX Service must be able to call the NSS Data-gathering API. To do this, the NSSX service must either be running with the same account as the NSS Core Server, or it must be running with an account that is a member of the NSSCoreAdmins local security group on all NSS servers.
  • The "UseAggregatedFTQuery" key must be present in the web.config file in the NSSConsole installation folder, and its value must be set to true.


Initial aggregation of historical file type group data is performed when the manual configration process, described below, is completed. The process is run in the background, and can take several minutes depending on the amount of historical data and the number of file types present.

On-going aggregation of data is performed as part of the normal scheduled scanning process, in the 'post-processing' phase (assuming the option has been enabled through the process described below).

Enable this Feature

Follow the steps below to enable this feature:

1. Ensure that all NSS installations that are writing to the NSS database are running 9.6 SR2 or later.

2. Check that the NSSX Service is able to call the NSS data-gathering API (and therefore configure scheduled scans):
a) Ensure that the NSS Core Service and NSSX Service are running with the same service account, or,
b) Ensure that the NSSX Service account is a member of the "NSSCoreAdmins" local security group on all NSS servers that are writing to the NSS data database.

3. Ensure that the NSS Core Service and NSSX Service accounts have the db_owner role or the explicit 'Execute' permission in the NSS database.
a) Right click on the NSS database in the MS SQL Server Management Studio and choose Properties.
b) Select Permissions page.
c) Select service account from the Users or Roles list.
d) Check that Execute Permission is granted in the Effective permissions tab, if not choose it from the Explicit tab.


When all of these pre-requisites are in place:

1. Open web.config file in the NSSConsole installation folder.
2. Locate the UseAggregatedFTQuery key and change the value="false" field to value="true"
3. If the UseAggregatedFTQuery key is not present, add it with the following: "<add key="UseAggregatedFTQuery" value="true" />"
4. Restart the NSSX Service.
5. The data aggregation process should now be triggered, this can be confirmed by checking for the presence of the "FileGroupSummary" table in the NSS data database and confirming that it is being populated.

KB Article: 3052

Updated: 11/27/2014

  • Category
    • Reference
  • Affected versions
    • 9.60.18562.1411 [9.6 SR2]

North America HQ

NORTHERN Parklife, Inc.
301Edgewater Place, Suite 100
Wakefield, MA 01880

Voice: 781.968.5424
Fax: 781.968.5301



Additional Contact Information


St. Göransgatan 66
112 33 Stockholm

Voice: +46 8 457 50 00


Northern Parklife

©2018 northern parklife

privacy statement 
terms of use