0 votes
886 views
in IBM BPM Administration by (16.3k points)

1 Answer

0 votes
by (16.3k 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 398 views
0 votes
1 answer 654 views
–1 vote
1 answer 671 views
0 votes
0 answers 310 views

635 questions

495 answers

98 comments

2.9k users

Join BPM Community Discord Channel

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