Tuesday, July 2, 2013

Get list of toolkit which is not being used in any Process App

We are using IBM BPM 7.5.1.1 and having lost of Process Apps(100+) and Toolkits(50+)

We need to do housekeeping in order to make our Development environment fast. We need to figure out which all Process Apps or Toolkits are not used and we can safely Archive.

I have created one query which get list of all toolkits which are not used by any process app as dependency.

Below is the query.

select NAME, SHORT_NAME, LSW_PROJECT.LAST_MODIFIED from LSW_PROJECT where IS_TOOLKIT='T' and SHORT_NAME not in (select NAME from LSW_PROJECT_DEPENDENCY group by NAME) order by LSW_PROJECT.LAST_MODIFIED

We distributed the output of above query to all development teams and after their approval(basically if they do not raise any concern in 7 days) we Archive toolkits. 

No comments:

Post a Comment