Is there a way to run a report and list the days left and who has offline days on their laptops?
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)
FROMrsa_rep.am_token,rsa_rep.ims_principal_dataWHEREam_token.principal_id = ims_principal_data.idORDER BY last_da_code_time ASC;
serial_number | last_da_code_time | loginuid---------------+---------------------+---------------000132251667 | 2016-03-16 00:00:00 | joeuser000132251677 | 2016-03-17 00:00:00 | 23003000132251679 | 2016-09-16 00:00:00 | 23005000116033741 | 2018-09-29 00:00:00 | murphy000159871817 | 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.
Retrieving data ...