topic Re: Rex pattern to extract unc path from xml in Getting Data In

Rex pattern to extract unc path from xml

splunk2019tlmd — Mon, 08 Jun 2020 04:03:23 GMT

I like to extract the UNC path from a log, below a portion from the file :

;<soa:FileSystem identifier="8ec65285-11ac-45a5-9652-425b7494b0df" name="Windows" description="Windows File System" leftaligncheckboxes="false" instance="102711ce-e483-46bc-bf6c-f42ae6faf234" signature="00000000-0000-0000-0000-000000000000" scheme="file" opencapable="true" consumeopen="true" emitopen="true"><soa:Location>file://fileserver/folder/folder1/folder2/</soa:Location

I like to have this part: //fileserver/folder/folder1/folder2

I have tried different rex combination without luck, any suggestions.

Thank you

Re: Rex pattern to extract unc path from xml

memarshall63 — Fri, 17 Apr 2020 01:00:56 GMT

Maybe this will help...

| makeresults 
| eval mystring = "<soa:FileSystem identifier=\"8ec65285-11ac-45a5-9652-425b7494b0df\" name=\"Windows\" description=\"Windows File System\" leftaligncheckboxes=\"false\" instance=\"102711ce-e483-46bc-bf6c-f42ae6faf234\" signature=\"00000000-0000-0000-0000-000000000000\" scheme=\"file\" opencapable=\"true\" consumeopen=\"true\" emitopen=\"true\"><soa:Location>file://fileserver/folder/folder1/folder2/</soa:Location>"
| rex field=mystring "<soa:Location>file:(?P<filelocation>[^<]*)<\/soa:Location>"

Re: Rex pattern to extract unc path from xml

splunk2019tlmd — Fri, 17 Apr 2020 01:53:43 GMT

Thank you for answering,
If I add the exact portion it works, but this is part of a bigger log file that I extract other fields, how could I modified the |eval function for the whole search ?

Re: Rex pattern to extract unc path from xml

memarshall63 — Fri, 17 Apr 2020 02:12:45 GMT

Sorry.. I don't know what you mean. You could just look for the file: string. So something like:

| rex field=mystring "file:(?P<filelocation>[^<]*)"

this just looks for "file:" and then grabs whatever comes after it.