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

book

Article ID: 212698

calendar_today

Updated On:

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.