How to get Siebel Workflow Instance Monitor values from Database through SQL query

Below is the query for getting workflow instance monitor values from table:

select
wfdl.NAME as 'WF Name'
,wfdl.DEPLOY_STATUS_CD as 'Status'
,wfdl.VERSION as 'WF Version'
,wfil.END_TS as 'Instance EndDate'
,wfil.STATUS_CD as 'Instance Status'
,wfsil.STEP_NAME as 'Step Name'
,wfsil.STATUS_CD as 'Step Status'
,wfsl.NAME as 'Process Name'
,wfsl.PROP_VAL as 'Process Value'

from S_WFA_DEFN_LOG wfdl
join S_WFA_INST_LOG wfil on wfdl.ROW_ID = wfil.DEFINITION_ID  --Process Instance
join S_WFA_INSTP_LOG wfsil on wfil.ROW_ID = wfsil.INST_LOG_ID --Step Instance
join S_WFA_STPRP_LOG wfsl on wfsil.ROW_ID = wfsl.STEP_LOG_ID  --Process Properties

where
wfdl.NAME = 'Workflow name with instance monitor level 3'
--and wfil.STATUS_CD = 'COMPLETED'
--and wfsil.STEP_NAME = 'step name'
--and wfsl.NAME <> 'Error Message'
← Back to Home

Comments

Post a Comment