Workflow for account and entitlement aggregation failuer

I need to develop a workflow that creates a ticket in ServiceNow whenever there are failures in account or entitlement aggregation. While I can successfully create tickets in ServiceNow, I’m encountering difficulties with monitoring account and entitlement aggregation. Specifically, in the ServiceNow ticket description, I require the source name where the aggregation failure occurred to be displayed in plain text format, but currently, it is presented as a hyperlink.

Hi @harishhaleon,

You can acheive that with this worflow :

Explanation :

  • As trigger you must use Account Aggregation completed wich will trigge all completed aggregation in your tenant.

  • With compare data strings you can check if aggregation status is Failure
    Here an example of account aggregation metadata :
    Triggers - SailPoint Identity Services

{
    "source":{
        "id":"4e4d982afddff4267ab12f0f1e72b5e6d",
        "name":"Corporate Active Directory",
        "type":"SOURCE"
    },
    "status":"Success",
    "started":"2020-06-29T22:01:50.474Z",
    "completed":"2020-06-29T22:02:04.090Z",
    "errors":[

    ],
    "warnings":[
        "Account skipped"
    ],
    "stats":{
        "scanned":200,
        "unchanged":190,
        "changed":6,
        "added":4,
        "removed":3
    }
}

In your Data string operator here a verification example :

In true output of your compare data string, you can use Manage ServiceNow ticket for creating your ticket.

Also it’s a good idea to send an email too.

In this Blog : Using IdentityNow Workflows to Send a List of Uncorrelated Accounts After Aggregation i do a similary use case but it was to send notification with list of uncorrelated accounts after account aggregation and i use Aggregation completed

Hi @baoussounda - Thanks for your help on this! Any ideas on Entitlement aggregation failures?

Hi @harishhaleon, i don’t found a trigger for Entitlement aggregation. I think you can link it on account aggregation. I mean do an entiltment aggregation before or after account aggregation and then trigger entittlement. If your source is configure correctly and that aggregation is done successfully, i think groupe Aggregation too will be donne successfully too.

This topic was automatically closed 60 days after the last reply. New replies are no longer allowed.