How to parse xml.log via logstash

[gavin-orange]

Hello Guys ,
I am totally new into ES and now I want to use logstash to parse the xml.log , hope could get any help .
Here is part of xml.log which I have :

    <msg time='2019-10-25T01:50:15.913+08:00' org_id='oracle' comp_id='rdbms'
     client_id='' type='UNKNOWN' level='16'
     host_id='cnsh-ipccdb1' host_addr='10.7.1.11' module=''
     pid='20386'>
     <txt>  Current log# 4 seq# 430140 mem# 0: +DG_ORA/ora11g/onlinelog/group_4.283.995416149
     </txt>
    </msg>

How do I edit the filter ?

[gavin-orange]

I want the results as below :

time : 2019-10-25T01:50:15.913+08:00 
log: Current log# 4 seq# 430140 mem# 0: +DG_ORA/ora11g/onlinelog/group_4.283.995416149

[stephenb (Stephen Brown)]

Hi @gavin-orange
Welcome to the community.

Have you look the XML filter.. should get you there / extract the fields

Then you might need to do some renaming , converting etc.

Pay attention to the date / time formats etc

[gavin-orange]

Hi Stephen ,
I used the " multiline " in filebeat to format the xml logs .
Then in logstash :

xml {
          source => "message"
          target => "parsed"
          store_xml => true
          force_array => false
          xpath => {
            "msg time" => "timestamp"
            "txt" => "contents" }

but the outcome is not as wished .