02-08-2013 09:08 AM
Can anyone give me the Oracle query that will move certain users that have a request in the TSEVENTDAT table from one workgroup server to another?
MOVE from edforworkgroupid = '2' where edloginid = 'ralph' to edforworkgroupid = '1';
(I want to move every record in the tseventdat table where edloginid is ralph to edworkgroupid = '1')
Thanks in advance!
Solved! Go to Solution.
02-08-2013 12:22 PM
First turn off the event server, then run this query:
update tseventdat set edForWorkgroupID = 2 where edLoginId = 'ralph' AND edForWorkgoupId = 1
Then turn on the event server.
Note that not all events are processed by the first available server. So reassigning some events won't help (like audit logging, DCI).