populate assignment group field from Event table to Alert table - Servicenow Event Management

[Aakanksha B]

Hello ,

How can i populate assignment group (reference field - sys_user_group) from Event table (em_event) to alert table (em_alert). Custom field created on Event table (u_assignment_group)

• Events are already assigned to group for incident creation. I need to reflect the same in Alert table when event is generated and later on processed.
• assignment group - reference field (sys_user_group) sys_id is used as binding in event table

Thank you in advance.

[Ashutosh Munot1]

Tried this and it worked:

1) Event data:

{

"source": "PostmanAssignment",

"description": "FastEthernet0",

"message_key": "ashutosht-2020",

"severity": "2",

"resource": "Postman",

"type": "Event",

"node":"",

"additional_info":"{'assignment_group':'0e9169520f7321000350bd5be1050e19'}"

}

2) 

3) Rule:

4) Alert:

Thanks,
Ashutosh

[shivambitanwar]

Hi Ashutosh,

The additional information in Alert has duplicate information now : 

assignment_group

assignment_group

Is it alright to have that? can we get rid of one of the variable  or its fine as a best practice?

[Jennifer44]

Can this be accomplished from the Description field instead of the Additional Information field? (With other information in the Description field in addition to "{'assignment_group':'0e9169520f7321000350bd5be1050e19'}")

In testing, I have been unable to parse "{'assignment_group':'0e9169520f7321000350bd5be1050e19'}" from the description field and add it as a manual attribute of assignment_group is {named expression}.

-Jennifer

[Ashutosh Munot1]

Hi Jennifer,

You can use description field and regex to get your work done. And yes please remove one assignment group attribute to avoid further issues.

Thank You,
Ashutosh

[Bhargavi21]

How to populate assignment group which is coming in additional info from payload which is not a sys id but the value .