· Nov 20, 2017

SQL to analyze processes by config

Does anyone know how to return the sys.process table with the corresponding configname item for each process? Also, is there a key for the Job Type field? 

Discussion (4)2
Log in or sign up to continue

You can use the Enumerate stored procedure in the Ens.Job class to get a list of running Ensemble jobs (config items) in the current namespace. If you need to get other system level details about the process, the "job" field is the same as the process id from %SYS.ProcessQuery.

From a SQL query tool you can call it with:
call Ens.Job_Enumerate()

From my earlier comment: includes a list of Job Types and their corresponding IDs.