Transfer Events (em_event) data between Servicenow instances

[Saurabh Bombale]

I'm working on an Integration where I need to transfer (copy) the events data present in em_event table from one Servicenow instance to other Servicenow instance. Can someone guide me how on to achieve this ? I don't want to use update set or export xml option. Is it possible to achieve this using REST API or any custom Servicenow spoke in flow designer ? Please provide detail steps or explanation. I want this specifically to transfer the events data only.

Any help is appreciated. 

Thank you.

[Richard Hine]

Saurabh,

Can you advise on what the use case would be for doing this?

Do you want the events transmitted to the other instance at the same time or can they be batched and sent at a later time?

Personally I would avoid doing anything with the em_event table for performance reasons; any potential solution would depend on how busy your environment is and what your objective was..

Richard

[Saurabh Bombale]

Hi Richard,

   Thanks for your reply. I want live events data to be transmitted from one instance to another. This is the use case - One instance is specifically use to generate events only and second instance is used to generate alerts once the events data is transferred and to remediate that we will be using flow designer.

So basically I want any feasible solution to do transfer of events data from one instance to another. 

[Richard Hine]

I would suggest this is a solution that will land you with technical debt and performance issues. Your use case would be one I would strongly challenge with my customers. Why do you need two instances?

Why don't you just process the events into alerts in the first instance and transmit the remediation tasks to the second instance instead?

If I recall correctly, ServiceNow advise against putting any bespoke code on the em_event table for performance reasons.

If there was a compelling reason or this was a 'must have' then I would look at using an async BR that ran on insert into em_event to call a bespoke script include to create a REST Message to send the event to the em_event table in the other instance. I would ensure the customer had signed off on the potential performance hit that this might cause.

Good luck!

Richard

[Rahul Priyadars]

Just a thought on technical aspect  ...Is there any remote possibility where Your Monitoring tool sends event to 

2 different instances of service now. After this you do what you want to do.

I am in agreement with Richard where as a consultant we must tell the details to customer what is the best practice.

Regards

RP