0 votes
465 views
in IBM BPM Administration by (16.6k points)

1 Answer

0 votes
by (16.6k points)
 
Best answer
This query will give you a listing of the toolkits with their usage counts

SELECT DISTINCT LP1."NAME" TOOLKIT_NAME, count(distinct LP.project_ID)

FROM LSW_PROJECT LP1, BPMDB.LSW_SNAPSHOT SNAP1, BPMDB.LSW_BRANCH BRANCH1, LSW_PROJECT_DEPENDENCY LPD, LSW_PO_VERSIONS LPV, LSW_BRANCH BRANCH, LSW_PROJECT LP

WHERE "BRANCH1".PROJECT_ID = SNAP1.PROJECT_ID

AND LP1.PROJECT_ID = SNAP1.PROJECT_ID

AND SNAP1.SNAPSHOT_ID = LPD.TARGET_SNAPSHOT_ID(+)

AND LPD.VERSION_ID = LPV.PO_VERSION_ID(+)

AND LPV.BRANCH_ID = BRANCH.BRANCH_ID(+)

AND "BRANCH".PROJECT_ID = LP.PROJECT_ID(+)

AND LP1.IS_TOOLKIT = 'T'

AND ((SNAP1.SNAPSHOT_ID = "BRANCH1".TIP_SNAPSHOT_ID AND SNAP1."NAME" is NULL) OR SNAP1.NAME is not null)

GROUP BY LP1."NAME"

order by LP1."NAME"

Related questions

0 votes
0 answers 167 views
0 votes
1 answer 118 views
–1 vote
1 answer 216 views
0 votes
0 answers 100 views

616 questions

493 answers

92 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
...