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"
