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"