Environment
Advanced Authentication 6.x
AAF
Situation
The Authenticators report generated in Dashboard of the AA Administrative Portal or in the Reporting portal doesn't contain the dates. Our management asked to generate a report with dates.
Resolution
Run the following command:
docker exec aaf_audb_1 psql -U root -d aucore_prod -P pager=off -c "SELECT repository.name,public.user.name,method_id,comment,auth_template.row_ver from auth_template full outer join public.user on (public.user.id=auth_template.owner_id) full outer join repository on (repository.id = public.user.repo_id) WHERE method_id<>'' AND method_id<>'LDAP_PASSWORD:1' ORDER BY repo_id,public.user.name"
NOTE: Advanced Authentication doesn't store the date of initial enrollment. The row_ver column contains the date of last authenticator modification. If the authenticator was not changed or re-enrolled, it contains the date of enrollment.