sql statement to get the number of PUSH notification for a period of time

Products

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

Issue/Introduction

I want to check how many user received the PUSH notification for a period of time like a week. I knew I can check it from AdminUI report but do u know how to do it from a db query? 

 

Environment

Release : 9.0

Component : AuthMinder(Arcot WebFort)

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.