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?
Comments
%syPidtab.inc includes a list of Job Types and their corresponding IDs.
By "configname", are you referring to Ensemble production items or something else?
Ensemble production items. I want to know the relationship between processes and production items.
I'd be interested to hear why you want to know this.
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: %syPidtab.inc includes a list of Job Types and their corresponding IDs.