Info
Content

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
;
No Comments
Back to top