Getting the list of SIGOPTION NAMES and APPLICATION NAMES which use specific CONDITION

select APP as "Application", OPTIONNAME as "Signature Option", GROUPNAME as "Security Groups"
from CTRLGROUP where CTRLGROUPID in
(
  select CTRLGROUPID from CTRLCONDITION where
   CONDITIONNUM in (select CONDITIONNUM from CONDITION where
    CLASSNAME = 'com.ibm.tivoli.maximo.script.ScriptCustomCondition')
);

In this example, we are looking for any application and sig.option name which use condition, which use automation script with Condition Launch Point.


FYI: Condition UI Table list:

select * from CTRLGROUP;
select * from CTRLCONDITION;
select * from CTRLCONDPROP;