RSA Security Console Report Exporting

[HakanCosar]

Hello,

we need to get daily reports with the users On-Demand Authentication. We want to see if the users are getting the on-demand token to their e-Mail Address or via SMS to their mobile.  This is the field "Send On-Demand Tokencodes to" under On-Demand Authentication (ODA).

I can create the report using RSA Security Console and download. Is there a way to automate this task may be on the shell? I can also query the database but i don't know in which table/s to find this information. Is it possible to send e-Mail from shell?

Thanks

[jeffshurtliff]

Hi Hakan,

I have moved this thread to the https://community.rsa.com/community/products/securid?sr=search&searchId=86058c46-bb67-4824-9da9-e34491b8417c&searchIndex=0‌ page so that you can get an answer to your question.

Thanks,
Jeff

[HusseinElBaz]

Hello Hakan,

Kindly be advised that in RSA Authentication Manager 8.2 you will be able to send the reports via e-mail and you can access it from there. It is an option at the end of the page of the report configuration.

But in order to automate that from shell this will require professional services to help you with that, and you can reach them through your account manager.

So kindly check and advise us back if there is any assistance needed from our side.

Best Regards,

[HakanCosar]

Hi thanks for answering,

i can generate now a file and send it to the logger:

/opt/rsa/am/pgsql/bin/psql -h localhost -p 7050 -d db -U rsa_dba -c "select utc_log_time,authmethod_name,result_key,client_ip,server_node_ip,arg9,actor_fname,actor_lname from ims_log_audit_rt where arg9 like '%@%' and utc_log_time > current_timestamp - interval '8 hours' order by utc_log_time desc" -t -o /home/rsaadmin/tkn.csv

Thanks again