You can use these sql calls. SELECT filter.name, filter_process.command FROM filter INNER JOIN filter_process ON filter_process.filterId = filter.filterId WHERE filter_process.command Like '%Distributed%' or filter_process.command Like '%ardist%' ORDER BY filter.Name
SELECT escalation.name, filter_process.command FROM escalation INNER JOIN filter_process ON filter_process.filterId = escalation.escalationId WHERE filter_process.command Like '%Distributed%' or filter_process.command Like '%ardist%' ORDER BY escalation.Name Regards, Chad Whilding Engineer CSC 3725 Pentagon Blvd., Beavercreek, OH 45431-1706 North American Public Sector | p: +1-937.320-6342 | f:+1-937-320-???? | [email protected] | www.csc.com This is a PRIVATE message. If you are not the intended recipient, please delete without copying and kindly advise us by e-mail of the mistake in delivery. NOTE: Regardless of content, this e-mail shall not operate to bind CSC to any order or other contract unless pursuant to explicit written agreement or government initiative expressly permitting the use of e-mail for such purpose. |------------> | From: | |------------> >--------------------------------------------------------------------------------------------------------------------------------------------------| |urthebest <[email protected]> | >--------------------------------------------------------------------------------------------------------------------------------------------------| |------------> | To: | |------------> >--------------------------------------------------------------------------------------------------------------------------------------------------| |[email protected] | >--------------------------------------------------------------------------------------------------------------------------------------------------| |------------> | Date: | |------------> >--------------------------------------------------------------------------------------------------------------------------------------------------| |09/16/2010 06:35 AM | >--------------------------------------------------------------------------------------------------------------------------------------------------| |------------> | Subject: | |------------> >--------------------------------------------------------------------------------------------------------------------------------------------------| |How to find filters/escaltions with DSO action | >--------------------------------------------------------------------------------------------------------------------------------------------------| Hi Can some one help me how to search filters/escalations with DSO actions in them . its very urg -- View this message in context: http://old.nabble.com/How-to-find-filters-escaltions-with-DSO-action-tp29726776p29726776.html Sent from the ARS (Action Request System) mailing list archive at Nabble.com. _______________________________________________________________________________ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org attend wwrug10 www.wwrug.com ARSlist: "Where the Answers Are" _______________________________________________________________________________ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org attend wwrug10 www.wwrug.com ARSlist: "Where the Answers Are"
