Mass update Event Rule - How can I see where data is stored?

Henrik Jutterst
Tera Guru

I'm looking for a way to mass update a field on an Event Rule via Background Script.

The problem is that I can't find where this data is stored, and since I can't right click on the field name to Watch the filed, I don't know where the data is stored.

In the list of all Event Rules, I exported one event rule to XML and viewed it, but I still can't see the field with its data. So this must be stored elsewhere. ("Everything in ServiceNow is a record in a table")

The URL when I'm modifying an Event Rule gives no hint:
https://<instance>.service-now.com/now/nav/ui/classic/params/target/%24em_event_rule_designer.do%3Fsys_id%3D7248994e87a5ad10c37fcbf90cbb35a1

I looked for a table called "em_event_rule_designer", but I can't find that.

I don't want to manually go through all ~200 rules, and would really like to find out how I can find this information.


Anyone here with that kind of knowledge?

 

HenrikJutterst_1-1697182822926.png

 

Anyone?

1 ACCEPTED SOLUTION

Henrik Jutterst
Tera Guru

Found the same question and solution here:
https://www.servicenow.com/community/itom-forum/event-management-rules-changes-to-rules-using-xml-ex...

Unfortunately there's not a simple solution to this. At least not when just looking into it.

View solution in original post

2 REPLIES 2

Sorry, but this sounds exactly like an answer from ChatGPT, and based on your name this confirms my theory even more.

No, this data is not stored in that table.
There's actually no table with that name. Please don't waste time.

Anyone else that care to give it a try?

Henrik Jutterst
Tera Guru

Found the same question and solution here:
https://www.servicenow.com/community/itom-forum/event-management-rules-changes-to-rules-using-xml-ex...

Unfortunately there's not a simple solution to this. At least not when just looking into it.