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. 

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.

Environment

Release :

Component :

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.