Adv Auth OTP history/log question

Products

• CA Advanced Authentication - Strong Authentication (AuthMinder / WebFort)
• CA Strong Authentication
• CA Rapid App Security
• CA Risk Authentication
• CA Advanced Authentication

Issue/Introduction

I am generating a history log of the OTP issuance by querying the DB as advised by Broadcom since there is not API. I need to know what is the OPERATIONID (2100, 2103, 2106) stand for?

How do we know the OTP issued/verification failed/success etc.?
How do CREDSTATUS & USAGECOUNT relate?
Can we get the SQL script of the Reporting tool so we can create a similar report ?

Environment

Release :

Component : AuthMinder(Arcot WebFort)

Resolution

All the information is placed at this location ( This is specific to Tomcat and look for same place if any other app server is used) 

C:\Program Files\Apache Software Foundation\Tomcat 9.0\webapps\arcotadmin\WEB-INF\classes\reports\oracle\webfort

And file webfort-authactivity-oracle-reportquery.xml, this is file which makes it more readable when you look data in Admin console.