Posted: Mon May 23, 2005 2:04 pm Post subject: Running Process instances query
Centurion
Joined: 17 Oct 2003 Posts: 114
Hi
I am trying to see if this is possible to do by querying the Audit trail.
MQWF 3.4
Oracle DB
MQ 5.3
1) I have a full audit to DB.
2) I want to check the number of running process instances at a particular timeline.
3) I also want to check how many among these process instances were still running , lets say 2 days after the above selected timeline.
4) I know this is not possible from the WF client , since some of these processes might have been deleted from MQWF process_inst table as they might have been completed as of today.
Joined: 27 Jun 2001 Posts: 3081 Location: EmeriCon, LLC
Have a look at Chapter 8 in the Admin guide the section called "Monitoring your business processes by analyzing the audit trail using database views" might be what you are looking for. _________________ John McDonald
RETIRED
You cannot post new topics in this forum You cannot reply to topics in this forum You cannot edit your posts in this forum You cannot delete your posts in this forum You cannot vote in polls in this forum