Process Recording flag

[AKloft]

Could someone please help me out?  I'm trying to build a SQL query to check which processes have recording turned on, and I cannot for the life of me figure out which attribute is tied to recording being enabled.

Thanks in advance,

Alex

[AKloft]

for those interested/curious:

SELECT                 B.ID AS "Process Name",
                              D.ID AS "Category",
                              CAST(A.MAJOR_VERSION AS VARCHAR2(8)) || '.' || CAST(A.MINOR_VERSION AS VARCHAR2(8)) AS "Version",
                              C.COMMONNAME AS "Locked By"
FROM                   TB_SC_SERVICE_CONFIGURATION A
INNER JOIN        TB_SC_SERVICE B
ON                        A.SERVICE_UUID = B.UUID
INNER JOIN        EDCPRINCIPALENTITY C
ON                        A.LOCKED_BY_USER = C.ID
INNER JOIN        TB_SC_SERVICE_CATEGORY D
ON                        B.SERVICE_CATEGORY_OID = D.OID
WHERE                A."audit" = 1;


//process

SELECT                 B.ID AS "Process Name",
                              D.ID AS "Category",
                              CAST(A.MAJOR_VERSION AS VARCHAR2(8)) || '.' || CAST(A.MINOR_VERSION AS VARCHAR2(8)) AS "Version",
                              C.COMMONNAME AS "Locked By"
FROM                   TB_SC_SERVICE_CONFIGURATION A
INNER JOIN        TB_SC_SERVICE B
ON                        A.SERVICE_UUID = B.UUID
INNER JOIN        EDCPRINCIPALENTITY C
ON                        A.LOCKED_BY_USER = C.ID
INNER JOIN        TB_SC_SERVICE_CATEGORY D
ON                        B.SERVICE_CATEGORY_OID = D.OID
WHERE                A.LOCKED_BY_USER is not null;