Siebel SQLs/Error Messages > Find out details about recently Workflows recently launched
The following SELECT statement provides information about the workflow policies and workflows that have been launched during the recent period.
sqlplus>
select eg.name "WF Policy Group", el.rule_name "WF Policy", aa.default_value "Workflow Name", count(*)
from s_escl_group eg, s_escl_rule er, s_escl_action ea, s_action_defn ad, s_prog_defn pd, s_action_arg aa, s_escl_log el
where er.group_id=eg.row_id
and ea.rule_id=er.row_id
and ad.row_id=ea.action_id
and ad.program_name=pd.name
and pd.repository_id=(select row_id from s_repository where name='Siebel Repository')
and ad.row_id=aa.action_id
and aa.name='ProcessName'
and el.rule_id=er.row_id
group by eg.name, el.rule_name, aa.default_value
order by 4 desc;
|