Automic Workload Automation

  • Private Community

  • 1.  I need to search for all WF with alias?

    Posted Jul 29, 2017 12:13 PM
    I need to search for all WF that have an alias to make sure that all alias linked to the right WF. 
    Does any one have a suggestion?



  • 2.  I need to search for all WF with alias?

    Posted Jul 31, 2017 02:55 AM
    Hello Mohammed_Alfassi_7915

    The information you are looking for may be found in the OH and JPP tables.
    Here is a simple query that will list all workflows that have an alias:

    SELECT OH_Name, JPP_Alias
    FROM OH, JPP
    WHERE OH_Idnr = JPP_OH_Idnr
    AND JPP_ALIAS IS NOT NULL
    AND OH_Client= <MyClient>
    AND OH_DeleteFlag='0';
    [EDIT]
    This was already discussed in this topic : https://community.automic.com/discussion/7975/how-to-search-for-workflows-jobs-by-alias

    No need to do a SQL query, it can be done by using a search for use of the alias.

    Best regards,
    Antoine