Teminated Employees and CA

[Chad_Petrie_2]

Is there a bulk way to stop monitoring and synchronizing termed employees in CA 6.0?

[Micah_Wyenn]

Hmmm,
Not that I know of. Then again, I'm not a CA 'xpert. But I haven't run in to bulk anything in CA in my travels. :)

micah

[Andrew_Tankersl]

We run CA, and I've been told many times by support that there is no way of doing anything in bulk
Right now, I have several hundred searches that need to be stopped, and I have to do it one department at a time...

[Chad_Petrie_2]

Unfortunately that is the conclusion I was coming to as well.

On a side note, here is a sql cmd that will stop all of your searches in CA.


update tblintsearches set statusid = 8 /*abandoned*/ where statusid = 2 /*searching*/

[Andrew_Tankersl]

Wow - Thanks for that!