Forum Discussion
Rodolphe_AUBINE
Nimbostratus
NimbostratusEmbeded 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.
...
Bernardo_GuiNimbostratus
NimbostratusHello, 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!