Release Automation

 View Only
  • 1.  How to query all running processes of the same application?

    Posted Aug 23, 2015 04:48 PM

    Would like to know if there's a way to get the list of running processes of the same application name?



  • 2.  Re: How to query all running processes of the same application?

    Broadcom Employee
    Posted Aug 23, 2015 10:10 PM

    You can get the list by using the online audit report of Automation Studio.

    Also you can see the list of the specific application only by adding the filter.



  • 3.  Re: How to query all running processes of the same application?

    Posted Aug 25, 2015 12:11 AM

    I actually tried to get the list during ROC Runtime to perform some checking and logic - the automatic way. So using Studio doesnt work for me.



  • 4.  Re: How to query all running processes of the same application?
    Best Answer

    Posted Aug 25, 2015 01:34 AM

    If you have access to RA DB you can run the following query

    SELECT * FROM nolio_db55.execution_jobs where major = 'Running' and application_name= '<APPLICATION NAME>' order by id desc

    Thanks

    Jacky



  • 5.  Re: How to query all running processes of the same application?

    Posted Aug 31, 2015 03:52 AM

    Brilliant,, Thanks!



  • 6.  Re: How to query all running processes of the same application?

    Posted Sep 01, 2015 04:17 PM

    BTW, if anyone is interested in doing this via the web interface (ROC), you can get a list of the currently running processes for a particular application using the "Process Report" in the dashboard.

     

    All you should have to do is set the "View" field to "Online Processes" and then use the "Application" field "Filter By" context menu option to select the application you're interested in.  (Click the the down arrow in the Application field header to open the context menu.)