Aggregation Settings

On the Aggregation Settings page, configure the filter settings, delta aggregation settings, additional settings and partitioning settings.

For more information about aggregation, refer to Loading Account Data.

Note
The SailPoint Identity Governance connector for ServiceNow aggregates sysparm_fields attributes during single account aggregation.

Filter Settings

In the Aggregation Settings > Filter Settings section, configure the filter parameters.

  1. Enter an Account Filter to filter accounts during aggregation. For multiple conditions, use a ^. For example: active=true^locked_out=false.

  2. Enter a Group Filter to filter groups during aggregation. For example: active=true.

  3. Enter a Role Filter to filter roles during aggregation. For example: sys_Scope=Global.

Delta Aggregation Settings

In the Aggregation Settings > Delta Aggregation Settings section, configure the delta aggregation parameters.

  1. Select Delta Aggregation to aggregate accounts that have changed since the last execution.

  2. Select Improve Delta Aggregation to speed up the delta aggregation performance. This enables you to read only the deleted events (such as removing group/role) of the user's connection from the x_sapo_iiq_connect_user_roles_and_group_deletes table.

    3. Important

    • To improve the delta aggregation, you must upgrade to ServiceNow SailPoint Identity Governance Connector version 1.0.6 or later from the ServiceNow store.

    • For improved delta aggregation performance, configure the Deleting With Table Cleanup Policies on the x_sapo_iiq_connect_user_roles_and_group_deletes table. For more information on table cleanup policies, refer to Deleting With Table Cleanup Policies.

    • For more information, refer to Delta Aggregation.

Additional Settings

In the Aggregation Settings > Additional Settings section, you can provide settings for managing roles for group as well as inherited role.

  1. Select Manage Roles for Group to aggregate roles by group.

  2. Select Manage Inherited Role to aggregate accounts where the inherited role is a member.

  3. Enter a Page Size to specify the number of entries displayed on a page.

    • Default: 50

    • Minimum: 1

    • Maximum: 1000

    Note
    Aggregation does not stop if the records received from the API response are less than the specified page size.

Partitioning Settings

In the Aggregation Settings > Partitioning Settings section, configure the partitioning aggregation parameters.

  1. Select Enable Partitioning to improve the performance of aggregation tasks.

  2. Enter the user partitioning scheme in the User Partitions. See Partitioning Aggregation for more information.

    Note
    If Partitioning is enabled and User Partitions is not specified, the default partitioning values would be considered.

  3. Enter the Number of Partitioning Threads. The default is 8.

  4. Select Save