could someone please explain what stanza configuration i should include in the props.conf file to extract the size attribute from <email>
into the field emailSize.
<stream TimeScanned="1271078550">
<command class="MAIL FROM" data="<me@gmail.com> SIZE=42446" />
<email size="42521">
<header Name="attachmentname" Value="driver-install.pdf" />
</email>
thanks,
This should do the trick:
EXTRACT-emailsize = <email\s+size=["'](?<emailSize>\d)["'][> ]
Of course, if size
isn't always the first attribute in the email
element, then the regex can start to get ugly.
If you are asking how you can automatically extract key value pairs using a combination of the element name and attribute name (like emailSize
, headerName
, headerValue
, commandClass
, commandData
, ... and so on), then it's not something splunk does out of the box...
You may also find the xmlkv
command helpful. The the search source=*.xml | xmlkv
If the regexes just get too crazy one other option is to leave props.conf alone and just use the xpath command at search time:
<your search> | xpath "//email/@size" outfield=emailSize | search emailSize > 40000
This should do the trick:
EXTRACT-emailsize = <email\s+size=["'](?<emailSize>\d)["'][> ]
Of course, if size
isn't always the first attribute in the email
element, then the regex can start to get ugly.
If you are asking how you can automatically extract key value pairs using a combination of the element name and attribute name (like emailSize
, headerName
, headerValue
, commandClass
, commandData
, ... and so on), then it's not something splunk does out of the box...
You may also find the xmlkv
command helpful. The the search source=*.xml | xmlkv