How to find out when a case was closed without directly accessing the Audit Trail table.
book
Article ID: KB0088658
calendar_today
Updated On:
Products
Versions
TIBCO iProcess Engine (Oracle)
-
Not Applicable
-
Description
Resolution: Description: ============ There may be a requirement to generate a list of closed cases in order to establish which cases may be purged from the TIBCO iProcess Engine database. Large systems can have an AUDIT_TRAIL table that contains hundreds of millions of rows. Avoiding accessing to the AUDIT_TRAIL table would be prefered.
Environment: ========== o All supported TIBCO iProcess Engines
Resolution: ========= The TIBCO iProcess Engine contains the utility "plist" that allows the listing of various tables within the database to display information in a user friendly format.
To list cases of a procedure use the command:
SWDIR/util/plist -c Proc_name
where:
SWDIR = the installation directory of the TIBCO iProcess Engine Proc_name = the procedure name
The command will list the cases for the specified procedure. For example:
# /swserver/util/plist -c TEST03 CNum CID Sts Case Description Starter yyyy/ddd hh:mm --------------------------------------------------------------------------- 222 222 LIVE test01 swadmin@nod105ch 322 322 LIVE test 02 swadmin@nod105ch 372 372 LIVE test 03 swadmin@nod105ch 474 474 DEAD Case Close 01 swadmin@nod105ch 2009/127 11:50 574 574 DEAD Case Close 02 swadmin@nod105ch 2009/127 11:53 674 674 LIVE Case Close 03 swadmin@nod105ch 724 724 LIVE Close Case 04 swadmin@nod105ch 774 774 DEAD Close Case 05 swadmin@nod105ch 2009/127 12:13
This shows all cases where active cases are listed as "LIVE" in the Sts column and closed cases are listed as "DEAD" in the Sts column.
The date is in a format that requires conversion. The date is effectively the day number of the year. The cases above were closed on day 127 of 2009 which equates to 5th July 2009.
The time is the time the case was closed.
Depending on how procedures have been defined consider using, plist -C proc_name, as this will include sub procedure information.
Issue/Introduction
How to find out when a case was closed without directly accessing the Audit Trail table.