Automic Workload Automation

  • Private Community

  • 1.  How to search for workflows/jobs by Alias ?

    Posted Nov 24, 2016 05:31 PM
     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


  • 2.  How to search for workflows/jobs by Alias ?

    Posted Nov 24, 2016 11:59 PM
    You can also do a search for use on the alias name in the gui.


  • 3.  How to search for workflows/jobs by Alias ?

    Posted Nov 25, 2016 02:38 AM
    and you forgot the and EH_client = xy clause ....

    the Description of the fields in the column header would also be great, the common user has no idea of the meaning of EH_AH_Idnr or EH_Alias etc.




  • 4.  How to search for workflows/jobs by Alias ?

    Posted Nov 25, 2016 03:25 AM
    Thank you FrankMuffke for this great suggestion. This can be e.g. done like that:

    SELECT E.EH_Client As "Client"
      , E2.EH_Name AS "Name"
      , E2.EH_Alias As "Alias"
      , E2.EH_AH_Idnr As "RunId"
      , E.EH_Name As "Name of Activator"
      , E2.EH_ParentAct As "RunID of Activator"
    FROM EH E
    INNER JOIN EH E2 on E.EH_AH_Idnr=E2.EH_ParentAct
    WHERE E2.EH_Alias LIKE '%ALIAS%'
    AND E.EH_Client = 22;

    The result looks like:

    2yirxq9n80kc.pnghttps://us.v-cdn.net/5019921/uploads/editor/z4/2yirxq9n80kc.png" width="710">




  • 5.  How to search for workflows/jobs by Alias ?

    Posted Nov 25, 2016 03:52 AM
    Always welcome ClausJambrich602320  :-)


  • 6.  How to search for workflows/jobs by Alias ?

    Posted Nov 25, 2016 09:57 AM
    Thank you all for your suggestions! I will try to rework on the script.