ALERT: Some images may not load properly within the Knowledge Base Article. If you see a broken image, please right-click and select 'Open image in a new tab'. We apologize for this inconvenience.

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


Article ID: 212698


Updated On:


CA Advanced Authentication - Strong Authentication (AuthMinder / WebFort)


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? 



Release : 9.0

Component : AuthMinder(Arcot WebFort)


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.