Splunk Search

How to lookup and match fields across sources?

krisalexroberts
New Member

Hello,

I have two sources:

1: Device, SiteName, Long, Lat
2: Device, Clients (Number of current clients)

I wish to generate a heat map based on number of users in locations, but cannot figure out how to create a search with one concise table, such as:

Device, SiteName, Clients, Long, Lat

0 Karma
1 Solution

richgalloway
SplunkTrust
SplunkTrust

This should get you headed in the right direction.

(index=foo source=one) OR (index=bar source=two) | stats list(SiteName) as SiteName, list(Long) as Long, list(Lat) as Lat, list(Clients) as Clients by Device
---
If this reply helps you, Karma would be appreciated.

View solution in original post

0 Karma

richgalloway
SplunkTrust
SplunkTrust

This should get you headed in the right direction.

(index=foo source=one) OR (index=bar source=two) | stats list(SiteName) as SiteName, list(Long) as Long, list(Lat) as Lat, list(Clients) as Clients by Device
---
If this reply helps you, Karma would be appreciated.
0 Karma
Get Updates on the Splunk Community!

SOC4Kafka - New Kafka Connector Powered by OpenTelemetry

The new SOC4Kafka connector, built on OpenTelemetry, enables the collection of Kafka messages and forwards ...

Your Voice Matters! Help Us Shape the New Splunk Lantern Experience

Splunk Lantern is a Splunk customer success center that provides advice from Splunk experts on valuable data ...

Building Momentum: Splunk Developer Program at .conf25

At Splunk, developers are at the heart of innovation. That’s why this year at .conf25, we officially launched ...