Forum Discussion

Rodolphe_AUBINE's avatar
Rodolphe_AUBINE
Icon for Nimbostratus rankNimbostratus
Jan 02, 2014

Embeded Mysql ASM database - how to display src_ip datas from PRX.PROXY_LOG

Hello,   The reporting tool built into the GUI ASM can not meet my specific needs analysis. Therefore, to meet these needs I perform some SQL queries directly in the internal MySQL database.   ...
management
mysql
security
storage
TMSH
Bernardo_Gui's avatar
Bernardo_Gui
Icon for Nimbostratus rankNimbostratus
Dec 04, 2014

Hello, I think that you are searching for this:

concat(conv(substring(hex(src_ip),25,2),16,10),'.',concat(conv(substring(hex(src_ip),27,2),16,10).

Or you can create a Procedure in Mysql.

In Mysql recent version there is a INET6_ATON(expr) function.

Bye!