Credential Management report raw query for Strong Authentication

Products

• CA Strong Authentication
• CA Advanced Authentication
• CA Advanced Authentication - Strong Authentication (AuthMinder / WebFort)

Issue/Introduction

Please provide the Credential Management report raw query.

Environment

Release : 9.1

Strong Authentication ( Webfort )

Resolution

See below for the raw query for Credential Management report of Strong Authentication.

SELECT    A.DATECREATED as WF_DATELOGGED  ,  A.RESPONSETIME as WF_RESPONSETIME  ,  A.ORGNAME as WF_ORGNAME  ,  A.INUSERID as WF_INUSERID  ,  A.USERNAME as WF_USERNAME  ,  A.ACTID as WF_ACCOUNTID  ,  A.ACTTYPE as WF_ACCOUNTTYPE  ,  A.CREDTYPE as WF_CREDTYPE  ,  A.CREDSTATUS as WF_CREDSTATUS  ,  A.VALIDITYSTARTDATE as WF_VALIDITYSTARTDATE  ,  A.VALIDITYENDDATE as WF_VALIDITYENDDATE  ,  A.STRIKECOUNT as WF_STRIKECOUNT  ,  A.USAGECOUNT as WF_USAGECOUNT  ,  A.OPERATIONID as WF_OPERATIONID  ,  A.RESPONSECODE as WF_RESPONSECODE  ,  A.REASONCODE as WF_REASONCODE  ,  A.TXNID as WF_TXNID  ,  A.PROTOCOLID as WF_PROTOCOLID  ,  A.INSTANCENAME as WF_INSTANCENAME  ,  A.CLIENTIPADDRESS as WF_CLIENTIPADDRESS  ,  A.CALLERID as WF_CALLERID  ,  A.USERAGENT as WF_USERAGENT  ,  A.REFERRER as WF_REFERRER  ,  A.CLIENTSESSIONID as WF_CLIENTSESSIONID  ,  A.IP as WF_CALLER_IP  ,  A.PROFILENAME as WF_PROFILENAME     FROM    ARWFISSUANCEAUDITLOG A  where (   (  A.ORGNAME in
        ('DEFAULTORG') AND  A.USERREFID IN
                            (
                                SELECT USERREFID FROM ARUDSUSER AUU WHERE AUU.USERID
                                 like '%%'
                                AND AUU.ORGNAME in ('DEFAULTORG')
                            ) AND  A.DATECREATED between
        to_date('06/01/2023 00:00:00', 'mm/dd/yyyy hh24:mi:ss')
        AND to_date('09/30/2023 23:59:59', 'mm/dd/yyyy hh24:mi:ss')  )  )   
        union all 
        SELECT    A.DATECREATED as WF_DATELOGGED  ,  A.RESPONSETIME as WF_RESPONSETIME  ,  A.ORGNAME as WF_ORGNAME  ,  A.INUSERID as WF_INUSERID  ,  A.USERNAME as WF_USERNAME  ,  A.ACTID as WF_ACCOUNTID  ,  A.ACTTYPE as WF_ACCOUNTTYPE  ,  A.CREDTYPE as WF_CREDTYPE  ,  A.CREDSTATUS as WF_CREDSTATUS  ,  A.VALIDITYSTARTDATE as WF_VALIDITYSTARTDATE  ,  A.VALIDITYENDDATE as WF_VALIDITYENDDATE  ,  A.STRIKECOUNT as WF_STRIKECOUNT  ,  A.USAGECOUNT as WF_USAGECOUNT  ,  A.OPERATIONID as WF_OPERATIONID  ,  A.RESPONSECODE as WF_RESPONSECODE  ,  A.REASONCODE as WF_REASONCODE  ,  A.TXNID as WF_TXNID  ,  A.PROTOCOLID as WF_PROTOCOLID  ,  A.INSTANCENAME as WF_INSTANCENAME  ,  A.CLIENTIPADDRESS as WF_CLIENTIPADDRESS  ,  A.CALLERID as WF_CALLERID  ,  A.USERAGENT as WF_USERAGENT  ,  A.REFERRER as WF_REFERRER  ,  A.CLIENTSESSIONID as WF_CLIENTSESSIONID  ,  A.IP as WF_CALLER_IP  ,  A.PROFILENAME as WF_PROFILENAME     FROM    ARWFISSUANCEAUDITLOG_AR A  where (   (  A.ORGNAME in
        ('DEFAULTORG') AND  A.USERREFID IN
                            (
                                SELECT USERREFID FROM ARUDSUSER AUU WHERE AUU.USERID
                                 like '%%'
                                AND AUU.ORGNAME in ('DEFAULTORG')
                            ) AND  A.DATECREATED between
        to_date('06/01/2023 00:00:00', 'mm/dd/yyyy hh24:mi:ss')
        AND to_date('09/30/2023 23:59:59', 'mm/dd/yyyy hh24:mi:ss')  )    );

Note:-  Please change the Orgname which consists of the users and also change the date range as per the need.