Application Utilization Report

#1

The Applications screen shows a utilization count. Is it possible to find out in which processes the applications are being used?

#2

Hi Jason,

Currently this feature is not present directly on WorkflowGen.

You can execute a SQL Query such as the following, to get all process by application :

SELECT DISTINCT WFAPPLICATION.NAME as 'Application name', WFPROCESS.NAME as 'Process name', 
WFPROCESS.VERSION as 'Process version', WFPROCESS.ID_PROCESS_STATUS as 'Process status'
FROM WFPROCESS
INNER JOIN WFACTIVITY ON WFACTIVITY.ID_PROCESS = WFPROCESS.ID_PROCESS
INNER JOIN WFAPPLICATION ON WFACTIVITY.ID_APPLICATION = WFAPPLICATION.ID_APPLICATION

Regards,
Quentin