Dashboards & Visualizations

Why are there no line breaks in the XML Microsoft Windows Exchange Managment log files in Splunk Cloud?

nthornbury
Explorer

I am forwarding in the XML versions of the Exchange Management logs from my Exchange servers. The XML log entries come into Splunk Cloud just fine but have no line breaks, like this when I do a search on the index:

1410x8000000000000080934MSExchange ManagementXXX.XXX.XXX.XXXSet-Mailbox-Identity "Xxxxx Xxxxxx" -EmailAddresses ("SMTP:xxxx.xxxx@xxxx.com","X400:C=US;A= ;P=XXX XXX;O=XXXXXX  - HQ;S=XXXXXX;G=XXXXX;")xxxx.xxxxx.com/XXXX OU/XXXX XXXXS-1-5-21-103706718-2002142400-1307212239-2863S-1-5-21-103706718-2002142400-1307212239-2863Local-ECP-Unknown27180w3wp#MSExchangeECPAppPool9900:00:00.4843728View Entire Forest: 'True', Configuration Domain Controller: 'xxxxx.xxxxx.xxxx', Preferred Global Catalog: 'xxxx.xxxx.xxxx', PreferredDomainControllers: '{xxx.xxx.xxx }'Fal  se0 objects execution has been proxied to remote server.0ActivityId: 064ebca7-2f3d-4967-a4e5-fb26fc403404ServicePlan:;IsAdmin:True;en-US

I have a props.conf for this data but obviously, it's not working properly. Here is the stanza for the props.conf, so any suggestions for getting this data to break properly and be more readable when search would be greatly appreciated. Thank you.

[xml:data]
KV_MODE = xml
SHOULD_LINEMERGE=false
NO_BINARY_CHECK=true
CHARSET=UTF-8
disabled=false
LINE_BREAKER=([\r\n\s]+)\
TRUNCATE = 100000
0 Karma

xpac
SplunkTrust
SplunkTrust

Be aware that because the LINE_BREAKER contains \s, your data might actually get broken on every space, tab...

0 Karma

adonio
Ultra Champion

highly recommend to use the relevant TAs for windows and exchange as those have all the right configurations pre-built
download direct from splunkbase
https://splunkbase.splunk.com/app/3225/#/overview
read here about collecting exchange data:
http://docs.splunk.com/Documentation/MSExchange/latest/Add-Ons/About

hope it helps

0 Karma
Get Updates on the Splunk Community!

Stay Connected: Your Guide to May Tech Talks, Office Hours, and Webinars!

Take a look below to explore our upcoming Community Office Hours, Tech Talks, and Webinars this month. This ...

They're back! Join the SplunkTrust and MVP at .conf24

With our highly anticipated annual conference, .conf, comes the fez-wearers you can trust! The SplunkTrust, as ...

Enterprise Security Content Update (ESCU) | New Releases

Last month, the Splunk Threat Research Team had two releases of new security content via the Enterprise ...