SQL Query to find active tasks

Discussion created by Duong_Nguyen-Nhat_2335 on Dec 13, 2016
Latest reply on Dec 21, 2016 by Christian_Boeck_57
This has been asked recently


Hello. I'm looking for a way to query all active tasks to find their status. I couldn't find a function that does this. I was hoping that using ucybdb rt and querying the status code i'm looking for, but this doesn't return a result. I suspect this is only querying jobs that have already finished. Maybe using SQLI? any resources that would point me in the right direction would be great. Even just a reference for the schema would be awesome. 


So you will need to find all the status of all active task in the activities windows as in the following:

select EH_STATUS,EH_NAME from EH

you can also specify the client, start time as your need. More information about the DB schema as in the following link:


About the status of job, please check the following link:


For morecomplex SQL queries, I would suggest you post it in our community:https://community.automic.com/discussion/

So another AE expert can help you as well.