+2
Hello,
I’m trying to find out how to see if a parent log has any open tasks.
When our action processor server freezes and needs to be restarted there are sometimes logs left behind that did not close properly. I’m trying to find a way to identify these logs so we can close them. I thought if there was a column I could use, I tried Next Action, but if the task was re-opened it would still appear as the process was completed and I don’t want to close those.
You could try using the following. This should output a list of task type events where the event is open and the parent event is closed.
select task.incident_id "task_id",
parent.incident_id "parent_id"
from incident task
inner join inc_data task_add on task.incident_id = task_add.incident_id
inner join incident parent on task_add.u_num2 = parent.incident_id
where task.type_enum = 4
and task.status_enum = 1
and parent.status_enum = 2
+2
Thanks I’ll pass this along to the assyst Admin team.
+2
Upon further review, this is great as I had not thought about the orphaned tasks, but it’s the reverse I want.
Open Parents, where all the Tasks are closed.
Thanks
Ahhh, I misunderstood. This one isn't infallible but it might get you started.
When we implemented assyst we were advised to use an empty stage called “Complete” to trigger closure in the action processor. If your configuration is similar then this should work for you.
select ticket.incident_id "event_id"
from incident ticket
inner join inc_data tick_add on ticket.incident_id = tick_add.incident_id
inner join act_type action on tick_add.curr_stage = action.act_type_id
where ticket.status_enum = 1
and action.act_type_sc = 'COMPLETE'This will look for tickets in the ‘Complete’ stage but still showing as open. I even discovered some in our system that I should look into.
+2
Enter your username or e-mail address. We'll send you an e-mail with instructions to reset your password.