Deployment Guide › iConsole Standard Searches, Reports and Policies › Dashboard Data Aggregation › Aggregation Parameters › Root Policy Node

Root Policy Node

SQL Server: @root_policy_node_list='<n>[,<n>]'

Oracle: root_policy_node_list=>'<n>[,<n>]'

This parameter specifies a list of integer ClassUID values (in decimal) for policy classifications, as listed in the Wgn3Classification and Wgn3ClassificationNode database tables. In general terms, it defines which incidents are included in the aggregation, based on the type of policy associated with each incident.

Under normal circumstances, you do not need to include this parameter. You only need to include it if you want the data aggregation to focus exclusively on incidents associated with specific policies.

All policies in the subtree of any specified ClassUID node will be included in the aggregation. By default, this parameter is set to 3000000 and 4000000. These ClassUID values represent the root nodes for predefined and custom policies respectively. But if required, you can include this parameter and explicitly set it to different ClassUID values. For example, if you want to aggregate incidents captured by Compliance policies only (ClassUID 3020000), set this parameter to:

@root_policy_node_list='3020000'

root_policy_node_list='3020000'

Alternatively, to aggregate incidents associated only with Personally Identifiable Information (ClassUID 3010300) or Personal Health Information (ClassUID 3010400) policies, then set this parameter to:

@root_policy_node_list='3010400,3010300'

root_policy_node_list='3010400,3010300'

If you specify a custom root policy node but then subsequently want to revert back to the default ClassUID values, you must explicitly set this parameter to 3000000 and 400000; simply omitting this parameter from the aggregation job will not reinstate the default root policy nodes.

Note: Details of all ClassUID values for policy classifications are listed in the Database Schema; see the 'Policy classification nodes' section under the description of the Wgn3ClassificationNode database table. The Database Schema is available on request from CA Technical Support.