Created By Dosvak LLC (WWW.DOSVAK.COM)

0 votes
59 views
in IBM BPM Administration by (10.3k points)

1 Answer

0 votes
by (10.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 31 views
...