SQL statement to get the number of PUSH notification for a period of time in Advanced Authentication

Products

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

Issue/Introduction

To check how many users received the PUSH notification over a specific period, such as a week, it’s possible to query the database directly.

Environment

Release : 9.1.x

Component : AuthMinder(Arcot WebFort) Strong Authentication

Resolution

You should be able to find the data from the ARUDSUSERDEVICES table. You can check the DATEMODIFIED column for the last week and you should get the results.

You can also have a look at the ARWFAUTHAUDITLOG table and look for column PUSHAUTHDEVICEID for the last 7 days.