1 Reply Latest reply on Aug 12, 2009 8:40 AM by AKloft

    Process Recording flag

    AKloft Level 2

      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

        • 1. Re: Process Recording flag
          AKloft Level 2

          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;