bobby_tamayo_automic

How to search for workflows/jobs by Alias ?

Discussion created by bobby_tamayo_automic on Nov 24, 2016
Latest reply on Nov 25, 2016 by bobby_tamayo_automic
 You can use the sql script below and simply replace JOBALIAS by the actual alias that you use and it will output the name of the workflow and the name of the JOBS and it alias used within the workflow.


SELECT E.EH_Name, E2.EH_Name Name, E2.EH_Alias Alias, E2.EH_ParentAct, E2.EH_AH_Idnr
FROM EH E
INNER JOIN EH E2 on E.EH_AH_Idnr=E2.EH_ParentAct
WHERE E2.EH_Alias LIKE 'JOBALIAS%';


Example result:

WRKFLW Name Alias EH_ParentAct EH_AH_Idnr
=================================================================
WRKFLWALIAS ALIAS JOBALIAS 1444737 1444738
WRKFLWALIAS ALIAS JOBALIAS 1444775 1444776
WRKFLWALIAS ALIAS2 JOBALIAS2 1444775 1444777
WRKFLWALIAS ALIAS JOBALIAS 1444806 1444807
WRKFLWALIAS ALIAS2 JOBALIAS2 1444806 1444808
WRKFLWALIAS ALIAS2 JOBALIAS3 1444806 1444809
WRKFLWALIAS ALIAS JOBALIAS 1444928 1444929
WRKFLWALIAS ALIAS2 JOBALIAS2 1444928 1444930
WRKFLWALIAS ALIAS2 JOBALIAS3 1444928 1444931

Outcomes