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

Products

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

Issue/Introduction

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

Environment

Release :

Component :

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.