0 votes
455 views
by (16.6k points)
Recently aototracking is turned off by default but since we migrate existing legacy applications there is a good change that lot of BPDs may have autotracking turned on unintentionally, how can we find out such BPDs for entire environment with SQL query

1 Answer

0 votes
by (16.6k points)
selected by
 
Best answer
You can retrieve the list with the following SQL for oracle and IBM BPM 8.6 (may work for earlier versions also)

select distinct LPV.LAST_MODIFIED as LastModifiedTime, LB."NAME" as BPDName , LP."NAME" as ApplicationName, LS."NAME" as SnapshotName, LBA.NAME as BranchName, LUX.USER_NAME as LastModifiedUser
from  LSW_PO_VERSIONS LPV, LSW_BPD LB, LSW_SNAPSHOT LS, LSW_PROJECT LP, LSW_BRANCH LBA, LSW_USR_XREF LUX
where LB.VERSION_ID = LPV.PO_VERSION_ID
and LPV.BRANCH_ID = LS.BRANCH_ID
and LS.PROJECT_ID = LP.PROJECT_ID
and LS.BRANCH_ID = LBA.BRANCH_ID
and LUX.USER_ID = LPV.LAST_MODIFIED_BY_USER_ID
and dbms_lob.instr(LB."DATA", utl_raw.cast_to_raw ('<autoTrackingEnabled>true</autoTrackingEnabled>')) <> 0

Related questions

0 votes
1 answer 242 views
0 votes
1 answer 358 views

613 questions

493 answers

91 comments

2.0k users

Welcome to BPM Tips Q&A, Community wiki/forum where you can ask questions and receive answers from other IBM BPM experts and members of the community. Users with 2000 points will automatically be promoted to expert level.
Created by Dosvak LLC
Our Youtube Channel
...