ASM LOGS

[THE_BLUE]

wher asm logs stored (event logs)? i want access the file using winSCP !

[Daniel_Wolf]

Hi @THE_BLUE,

ASM event logs are stored in /var/log/asm.
ASM request logs are stored in a MySQL database. Check this article how you can access the data in the database from the CLI.
K06821426: Viewing BIG-IP ASM request logs from MySQL database 

KR
Daniel

[THE_BLUE]

i go through the article  there is a command :

mysql -uasm -p`perl -MF5::Cfg -e 'print F5::Cfg::get_mysql_password()'` -e "select * from PRX.REQUEST_LOG where support_id = <support_ID>\G"

so i have to write the support id inside <> as below?

mysql -uasm -p`perl -MF5::Cfg -e 'print F5::Cfg::get_mysql_password()'` -e "select * from PRX.REQUEST_LOG where support_id = <15287133167450849374>\G"

[Daniel_Wolf · Accepted solution]

From my notes, this is a valid query

mysql -uasm -p`perl -MF5::Cfg -e 'print F5::Cfg::get_mysql_password()'` -e "select * from PRX.REQUEST_LOG where support_id = 2259937930602610699\G"

No pointed brackets <> required.

[THE_BLUE]

thank you very much, i will try .

But if i want to search based on username, then i have to replace \G with \Char?

[SeanMenard]

To access Oracle ASM logs via WinSCP, you'll need SSH access to your server. You can commonly find ASM logs in the `$ORACLE_BASE/diag/asm/+asm/asm/trace` directory.