Forum Discussion
THE_BLUE
Cirrostratus
CirrostratusASM LOGS
wher asm logs stored (event logs)? i want access the file using winSCP !
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.
- Daniel_Wolf
MVP
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 databaseKR
Daniel 
THE_BLUEi 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
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?
SeanMenardNimbostratus
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.