Splunk query using azure KQL concat

heskez — Mon, 17 Jun 2024 15:26:32 GMT

Hi there,

I am trying to get some data from MS Defender into a Splunk query.

My original KQL query in azure contains | JOIN KIND INNER. to concat DeviceProcess and DeviceRegistry tables.

The Splunk app I am using:

Splunk https://splunkbase.splunk.com/app/5518

So basically I'd like to do concatenation between DeviceProcess and DeviceRegistry events in advanced hunting query | advhunt in splunk SPL. Is there a suitable Splunk query for this kind of purpose?

Re: Splunk query using azure KQL concat

KendallW — Tue, 18 Jun 2024 03:45:04 GMT

Hi @heskez try using the join command:

<left-dataset> | join left=L right=R 
where L.pid = R.pid <right-dataset>

https://docs.splunk.com/Documentation/SCS/current/SearchReference/JoinCommandOverview

topic Re: Splunk query using azure KQL concat in Splunk Search

Splunk query using azure KQL concat

Re: Splunk query using azure KQL concat