Adding Threat Intelligence feed into Splunk ES in CSV format

JakeInfoSec — Fri, 22 Apr 2022 16:04:33 GMT

I'm currently trying to upload a malware feed into Threat Intelligence Management.

The feed itself is being pulled from the following URL: https://bazaar.abuse.ch/export/csv/recent/

The issue is that while it is in CSV format, the values themselves are also encapsulated by quotes, so they are being imported into the file_intel like the following.

To extract out the actual values since they are surrounded by quotes I put together a regular expression under "Extracting regular expression" which works on regexr and regex101, but this regular expression does not appear to be getting used as the values in the lookup still look like the above.

Here is what the csv looks like.

Is there a setting I am missing that is causing the regex to not be utilized?

Re: Adding Threat Intelligence feed into Splunk ES in CSV format

BenjaminAbben — Fri, 20 May 2022 11:36:25 GMT

maby this will work:?

@the parsing tab do the following extracting reg expr: ([^\"\,]+)

Re: Adding Threat Intelligence feed into Splunk ES in CSV format

BenjaminAbben — Fri, 20 May 2022 11:49:41 GMT

Oh wait,, after some messing around place the + 1 spot to the left like so:

\b([^\"\,]+)\b

topic Re: Adding Threat Intelligence feed into Splunk ES in CSV format in Splunk Enterprise Security

Adding Threat Intelligence feed into Splunk ES in CSV format

Re: Adding Threat Intelligence feed into Splunk ES in CSV format

Re: Adding Threat Intelligence feed into Splunk ES in CSV format