Cirrostratuswher 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.
MVPHi 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
Cirrostratusi 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"
MVPFrom 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.
Cirrostratusthank you very much, i will try .
But if i want to search based on username, then i have to replace \G with \Char?
NimbostratusTo 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.