Check Process Override Options

This SQL checks all process definitions where the parameter list, command line or working directory has been changed in the process definition override options.

You might find that the majority of the processes returned are Crystal Reports so you can amend the SQL to skip this process type if required.

select

 PRCSTYPE,

 PRCSNAME,

 DESCR,

 (

 select XLATSHORTNAME

 from PSXLATITEM XI

 where FIELDNAME = 'PARMLISTTYPE'

 and FIELDVALUE = PD.PARMLISTTYPE

 and EFFDT = (

 select max(EFFDT)

 from PSXLATITEM

 where FIELDNAME = XI.FIELDNAME

 and FIELDVALUE = XI.FIELDVALUE

 )

 and EFF_STATUS = 'A'

 ) as PARMLISTTYPE,

 PARMLIST,

 (

 select XLATSHORTNAME

 from PSXLATITEM XI

 where FIELDNAME = 'CMDLINETYPE'

 and FIELDVALUE = PD.CMDLINETYPE

 and EFFDT = (

 select max(EFFDT)

 from PSXLATITEM

 where FIELDNAME = XI.FIELDNAME

 and FIELDVALUE = XI.FIELDVALUE

 and EFFDT <= sysdate)

 and EFF_STATUS = 'A'

 ) as CMDLINETYPE,

 CMDLINE,

 (

 select XLATSHORTNAME

 from PSXLATITEM XI

 where FIELDNAME = 'WORKINGDIRTYPE'

 and FIELDVALUE = PD.WORKINGDIRTYPE

 and EFFDT = (

 select max(EFFDT)

 from PSXLATITEM

 where FIELDNAME = XI.FIELDNAME

 and FIELDVALUE = XI.FIELDVALUE

 and EFFDT <= sysdate)

 and EFF_STATUS = 'A'

 ) as WORKINGDIRTYPE,

 WORKINGDIR

from

 PS_PRCSDEFN PD

where

 (PARMLISTTYPE != '0' OR CMDLINETYPE != '0' OR WORKINGDIRTYPE != '0')

order by

 PRCSTYPE, PRCSNAME

;