SailPoint aggregation filter

[V-VanishreeC (V-Vanishree CK)]

Hello Everyone,

We are currently working on identifying inactive users in SailPoint and are planning to implement aggregation filters to streamline this process. We have two data sources in our tenant: HCM and ServiceNow.

For HCM users, we need to aggregate all users except those with the following conditions:
ASG_Status = ‘Inactive’ AND
end_date >= End date + CURRENT_DATE (This is to maintain a grace period where to keep an inactive users for 30 days after becoming inactive)

For ServiceNow users, we would like to aggregate all users except those who meet these conditions:
active = false
end_date >= End date + CURRENT_DATE (This is to maintain a grace period where to keep an inactive users for 30 days after becoming inactive)

We have already written a query to address the inactive condition for HCM identities but need assistance in formatting the conditions related to the end date.

Could anyone please help us with the appropriate query for each of these filters?

Thank you for your support!

[Yathish (yathish Ponnana)]

Data comparison is not possible through aggregation filters.

[MVKR7T (Krishna Mummadi)]

Hi @V-VanishreeC

1. You can check if connector (source) supports filtering
2. Use filter string: IdentityNow Account Filtering during Account Aggregation - Compass

Thanks
Krish