[Event Management] Update Business Rule in Event Table

- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎03-05-2024 09:32 AM
Hello. I need to create a Business Rule in the Event [em_event] table. It should be a "update" Business Rule which will run a script after the Alert field has been populated. However, it does not work. An "Insert" Business Rule does not work: although it is executed, by the insert time the Alert field is empty, as the event has not been processed yet. But an update business rule is not executed. I verified that, forthe system, the event processing does not count as an update: after the event has been processed and an the Alert field has been populated, the sys_mod_count field (number of updates) of the event record still has the value 0.
Does anyone know a solution or workaround for it?
Thank you.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎03-05-2024 02:29 PM
Hi, do you have trigger conditions that are not met?
Have you added any debugging to validate the BR is run and does not fail as a result of syntax or assumptions regarding parameters\variables?
Perhaps you could share plain text xml of the BR record so that it can be evaluated by the community.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎03-05-2024 02:36 PM
Hi @Rafael Pinto ,
As per service now best practices - Business rules are NOT recommended on the events table for performance reasons
Did you try Event Field mapping that may help your use case? Please find the reference product document below:
If I could help you with your Query then, please hit the Thumb Icon and mark it as Correct !!
Thanks & Regards,
Sumanth Meda
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎03-05-2024 09:04 PM
Hi @Rafael Pinto ,
As per best practices, you should not write any business rule on Event table as its degrade the Performance of your instance and Event to Alerts.
You can use the Event field Mapping or while creating event rule , you can use the transform mapping of event to alerts, that will help to achive the required things.
Please appreciate the efforts of community contributors by marking appropriate response as Mark my Answer Helpful or Accept Solution this may help other community users to follow correct solution in future.
Thanks
AJ
Linkedin Profile:- https://www.linkedin.com/in/ajay-kumar-66a91385/
ServiceNow Community Rising Star 2024