There is the authentication activity report but it is not clear how many offline days a person has, you can only find the last time offline days were requested, and it would take some time crunching the reports to make a determination.
However, in the database there is a field 'last da code time' which would be the last date of someones most recent
offline download (the day the offline days run out on the end user device).
select serial_number,last_da_code_time from am_token where last_da_code_time is not null;
Last_da_code_time is the final day a user has downloaded codes.
So if today is 8/21/2020 and the offline policy is 14 days and they just topped up days, the last_da_code_time would be 09/04/2020
Here is a query that will put userid to token serial and make a better result (example)
Hi,
There is the authentication activity report but it is not clear how many offline days a person has, you can only find the last time offline days were requested, and it would take some time crunching the reports to make a determination.
However, in the database there is a field 'last da code time' which would be the last date of someones most recent
offline download (the day the offline days run out on the end user device).
select serial_number,last_da_code_time from am_token where last_da_code_time is not null;
Last_da_code_time is the final day a user has downloaded codes.
So if today is 8/21/2020 and the offline policy is 14 days and they just topped up days, the last_da_code_time would be 09/04/2020
Here is a query that will put userid to token serial and make a better result (example)
SELECT
am_token.serial_number,
am_token.last_da_code_time,
ims_principal_data.loginuid
FROM
rsa_rep.am_token,
rsa_rep.ims_principal_data
WHERE
am_token.principal_id = ims_principal_data.id
ORDER BY last_da_code_time ASC;
[result]
serial_number | last_da_code_time | loginuid
---------------+---------------------+---------------
000132251667 | 2016-03-16 00:00:00 | joeuser
000132251677 | 2016-03-17 00:00:00 | 23003
000132251679 | 2016-09-16 00:00:00 | 23005
000116033741 | 2018-09-29 00:00:00 | murphy
000159871817 | 2019-04-20 00:00:00 | murphy
On the laptops themselves, you just need to look in the offline days storage directory and check
the names of the files.