database log severity. | Log collection solutions

#1 pissanello 6 years ago

Hello There,

I'm working on customer poc that to collect database log and convert it to syslog to send another monitoring tool.

the om_file working as expect, but there are only send on info severity. it there any way that I can process that db log format and make it have severity in syslog ?

thank you , Kriengsak

Permalink

#2 adm Nxlog ✓ 6 years ago (Last updated 6 years ago )

#1 pissanello

Hello There, I'm working on customer poc that to collect database log and convert it to syslog to send another monitoring tool. the om_file working as expect, but there are only send on info severity. it there any way that I can process that db log format and make it have severity in syslog ? thank you , Kriengsak

You can override it with the following:

<Exec>
        if $raw_event =~ /ERROR/ $SyslogSeverityValue = 3;
        else $SyslogSeverityValue = 6;
        to_syslog_bsd();
</Exec>

See the Fields used by xm_syslog in the user guide.