MonitorWare Knowledge Base

[acod]

Hello,

I am in the process of setting up Winsyslog v7.0.316 to store data to a MySQL 5.0 database. I need to store the %source% property as an integer in this database - specifically, I would like Winsyslog to execute this query (or some query containing this) when storing it

INSERT INTO '<Table Name>' (host) values(INET_ATON('192.168.0.1'));

if the %source% property is equal to 192.168.0.1 .

Does anyone know a way to do this either by manipulating the Fieldcontent column on the Database Logging window, or some other way?

Thanks very much,

Anne