--
-- Version : 5.7.4
--
-- File    : xwrunning.sql
-- Purpose : this file contains the needed SQL commands to 
--           retreive running jobs
-- Usage   : mysql < xwrunning.sql
--


select apps.name,works.status,tasks.status,hosts.name,hosts.pilotjob from works,tasks,apps,hosts where works.isdeleted="false" and apps.isdeleted="false" and tasks.isdeleted="false" and hosts.isdeleted="false" and works.uid=tasks.uid and works.appuid=apps.uid and tasks.hostuid=hosts.uid and works.status="RUNNING";

--
-- End Of File
--
