Hi, The easiest way is to use the search objects option in the admin tool (on a recently synchronized search database.)
But if you haven't synchronized the search database, you can run the following SQL statements to find out. I don't know the tables corresponding to escalation actions. So, you'ld have to hunt for them. /* These were created for SQL Server 2000/Windows 2000 environment. Please map to Oracle/Unix as appropriate*/ /* Active Links with Direct SQL Actions*/ Select name from actlink , actlink_sql where actlink_sql.actlinkId = actlink.actlinkId and enable = 1 /* Active Links with Run Process Actions*/ Select name from actlink , actlink_process where actlink_process.actlinkId = actlink.actlinkId and enable = 1 /* Filters with Direct SQL Actions*/ Select name from filter , filter_sql where filter_sql.filterId = filter.filterId /* Filters with Run Process Actions*/ Select name from filter , filter_process where filter_process.filterId = filter.filterId Thanks Radhika Direct : +44 20718 20262 Extn : 20262 -----Original Message----- From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] Behalf Of Bezhenar, Dmitry Sent: 06 October, 2006 12:55 PM To: [email protected] Subject: Unix/Oracle -> Windows/SQL Server Hello List, We are now migrating our server from Solaris 9 - Oracle 9.2 environment to Windows - SQL Server one. There are 2 problems with this process - 1. "Run process" 2. "Direct SQL" Is there a way to search for every workflow element which contains these actions? In order to find out if this particular action will work on a different platform. Thank you. PS: I've tried to do it with a *.def files using "notepad" with no success. Kind Regards Dmitry Bezhenar _______________________________________________________________________________ UNSUBSCRIBE or access ARSlist Archives at http://www.wwrug.org This e-mail and any attachment is for authorised use by the intended recipient(s) only. It may contain proprietary material, confidential information and/or be subject to legal privilege. It should not be copied, disclosed to, retained or used by, any other party. If you are not an intended recipient then please promptly delete this e-mail and any attachment and all copies and inform the sender. Thank you. _______________________________________________________________________________ UNSUBSCRIBE or access ARSlist Archives at http://www.wwrug.org
