How to get a count of AA Riskfort Devices associated with users in AA organization ?

Products

• CA Advanced Authentication - Strong Authentication (AuthMinder / WebFort)
• CA Advanced Authentication
• CA Advanced Authentication - Risk Authentication (RiskMinder / RiskFort)

Issue/Introduction

Provide count of distinct device associations  made by all users given a specific Advanced Authentication Organization. 

Environment

Release :ALL supported versions

Component :CA Risk Authentication

Component :CA Strong  Authentication

Cause

Cause not applicable. This is an informational article.

Note In CA Risk Authentication a User to Device association is made via the RiskEvaluate call. The details of this User to Device association are in the CA Risk Authentication table named ARRFDEVUSERASSO.

Resolution

The Risk Evaluation operation  for a enrolled/registered  User that has an association with a Device is stored in this ARRFDEVUSERASSO table.

select count(distinct USERNAME) FROM ARRFDEVUSERASSO  where ORGNAME = 'ORGANIZATION_OF_INTEREST'; 

Additional Information

None.