AnsweredAssumed Answered

RSA Security Console Report Exporting

Question asked by xsitjalvxkhdcamnffblifngzww28nr15wodmghtvju= on Sep 1, 2016
Latest reply on Sep 2, 2016 by xsitjalvxkhdcamnffblifngzww28nr15wodmghtvju=

Like • Show 0 Likes0
Comment • 3

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

No one else has this question

Outcomes

Jeff Shurtliff

Sep 1, 2016 9:32 AM

Hi Hakan,

I have moved this thread to the RSA SecurID Access page so that you can get an answer to your question.

Thanks,
Jeff

Actions

Hussein El Baz

Sep 2, 2016 5:28 AM

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,

Actions

xsitjalvxkhdcamnffblifngzww28nr15wodmghtvju= Sep 2, 2016 9:00 AM

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

Actions

3 Replies

Jeff Shurtliff Sep 1, 2016 9:32 AM
Mark Correct
Correct Answer
Hi Hakan,

I have moved this thread to the RSA SecurID Access page so that you can get an answer to your question.

Thanks,
Jeff
Like • Show 0 Likes0
Actions
Hussein El Baz Sep 2, 2016 5:28 AM
Mark Correct
Correct Answer
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,
Like • Show 0 Likes0
Actions
xsitjalvxkhdcamnffblifngzww28nr15wodmghtvju= Sep 2, 2016 9:00 AM
Mark Correct
Correct Answer
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
Like • Show 0 Likes0
Actions

RSA Security Console Report Exporting

Outcomes

Related Content

Recommended Content