I've done it for Change Requests on SQL Server 2005. If you're using Oracle, just make whatever necessary modifications to this:
select t.task_id , t.rootrequestid, t.assignee_group, t.assignee, t.summary, t.notes from tms_task t left join chg_infrastructure_change c on c.request_id = t.rootrequestid where c.request_id is null and rootrequestformname = 'CHG:Infrastructure Change' -----Original Message----- From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] On Behalf Of Chris Doble Sent: Tuesday, August 21, 2007 1:38 PM To: arslist@ARSLIST.ORG Subject: orphaned tasks ** Has anybody found a search that works when looking for orphaned tasks (the task was created, but the ticket wasn't saved) in arsys7.x? Thank You, Chris Doble Mobile: 949-533-5346 __20060125_______________________This posting was submitted with HTML in it___ Private and confidential as detailed <a href="http://www.sug.com/disclaimers/default.htm#Mail">here</a>. If you cannot access hyperlink, please e-mail sender. _______________________________________________________________________________ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org ARSlist:"Where the Answers Are"