0 votes
196 views
by (16.1k 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.1k 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 129 views
0 votes
1 answer 177 views
0 votes
1 answer 123 views

582 questions

482 answers

87 comments

1.7k users

Dosvak IBM BPM /BAW Products, Download Evaluation
Process & Performance Tools Process & Performance Tools
Code Analyzer Code Analyzer
UI Toolkit UI Toolkit
Integration Monitoring Integration Monitoring
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
...