000033758 - What are the total number challenges presented to users since RSA Adaptive Authentication (OnPrem) went online

Document created by RSA Customer Support Employee on Sep 27, 2016Last modified by RSA Customer Support Employee on Apr 21, 2017
Version 3Show Document
  • View in full screen mode

Article Content

Article Number000033758
Applies ToRSA Product Set: Adaptive Authentication (OnPrem)
RSA Product/Service Type: Adaptive Authentication (OnPrem)
 
IssueHow do we determine answers to these questions?
1.  Total number of challenges presented to users
2.  The number of challenges failed by users
3. The number of successful challenges by users
Resolution You can use this SQL query to find the answers to the questions above. Your DBA can tweak this query if necessary to get the exact info you are looking for.
 
SELECT [USER_ID], [EVENT_TIME], [CHALLENGE_AUTH_METHOD] , [CHALLENGE_SUCCESSFUL], [IS_DEVICE_BOUND]
FROM
[RSA_CORE_AA].[dbo].[EVENT_LOG]
WHERE
[RSA_CORE_AA].[dbo].[EVENT_LOG].[POLICY_ACTION]='CHALLENGE';

Note : This is limited to 180 days by default.
 

Attachments

    Outcomes