Automic Workload Automation

 View Only
  • 1.  Query to pull the list of UC4 jobs failed

    Posted May 28, 2020 03:38 AM
    We would like to pull the list of UC4 JOBS which got FAILED, RUNNING, COMPLETED etc.

    Could you pls help us to get the Query.


  • 2.  RE: Query to pull the list of UC4 jobs failed

    Posted May 28, 2020 04:24 AM
    Edited by Carsten Schmitz May 28, 2020 04:25 AM
    Hi.

    A Google search unearthed the answer to your question already exists in here, and in various other community threads:

    https://community.broadcom.com/communities/community-home/digestviewer/viewthread?MID=793990​

    Adapt as required.

    Hth,


    ------------------------------
    # signature.sh --verbose=[true|false]
    # no configurables beyond this point, only signature

    Using the slide show widget for posting individual images is wrong. Please use the "insert image" button in the editor.

    Did you know? I will NOT respond to PM asking for help unless there's an actual reason to keep the discussion off of the public forums!

    "Efficient Solutions Monthly Magazine" says: These contain very good advise on asking good questions. No, you do not need StackExchange for Automic, but asking questions the right way never hurts:

    http://www.catb.org/~esr/faqs/smart-questions.html

    https://www.chiark.greenend.org.uk/~sgtatham/bugs.html
    ------------------------------



  • 3.  RE: Query to pull the list of UC4 jobs failed

    Posted May 28, 2020 11:53 PM
    Thanks Carsten.

    Could you pls help to pull blocked jobs which are in Active status.

    Thanks


  • 4.  RE: Query to pull the list of UC4 jobs failed

    Posted Jun 03, 2020 08:26 AM
    Hi,

    ah_status = 1550​ is the active status. I can not help you from top of my head with the "blocked" condition.

    Please understand that I can not deliver to you a finished solution beyond that, as I do not work for Broadcom Support. If required for obtaining a finished solution, there is consultancy available from a Broadcom partner a this link:

    https://www.broadcom.com/support/ca/services-support/ca-services

    Best regards!



  • 5.  RE: Query to pull the list of UC4 jobs failed

    Posted Jun 03, 2020 08:57 AM
    Thank you Sir.

    Thanks a lot for your Support.


  • 6.  RE: Query to pull the list of UC4 jobs failed
    Best Answer

    Broadcom Employee
    Posted Jun 04, 2020 02:55 AM
    Hi Kishore,
    the advanced search feature of the v12.3 AWI allows you to run and export such query.
    Please check also the Analytics Dashboard features to present the results to your management.

    I do not know why do need such query. The v12.3 advanced search and Analytics feature has a lot to offer.

    ------------------------------
    Sr. Solution Architect
    Broadcom
    ------------------------------



  • 7.  RE: Query to pull the list of UC4 jobs failed

    Posted Jun 04, 2020 03:45 AM
    Hi Kay

    Thanks for your reply.

    We're using V12.0.1. Is that feature avaiable in this.

    If yes, Could you pls help us to access the steps.

    Thanks


  • 8.  RE: Query to pull the list of UC4 jobs failed

    Broadcom Employee
    Posted Jun 05, 2020 01:58 AM
    HI Kishore,
    unfortunately v12.0 does not include many of the features the new search engine and AWI is not powerful as well.

    I am recommending to use v12.3 because it allows to export the search result into the csv format.

    ------------------------------
    Sr. Solution Architect
    Broadcom
    ------------------------------