Splunk Search

How to fetch data from multiple source types in a dashboard ?

rijinc
Explorer

Hi Team,

I have three sourcetypes, all the sourcetypes have two or three common fields , how to extract the data as it should fetch data from all three source type
for ex: Field "City" is common in all source types, to display it on a dashboard using dropdown, what will be the search query or suggest some way to start on this

My idea is to execute search string : input lookup file1.csv file2.csv file3.csv|stats city as City is this correct ?
or is there any convenient way to fetch it easily

Tags (1)
0 Karma

cmerriman
Super Champion

if they are lookup files, maybe something like this:

|inputlookup file1.csv|table City|append [|inputlookup file2.csv|table City]|append [|inputlookup file3.csv|table City]|stats count by City|fields - count
0 Karma
Get Updates on the Splunk Community!

Index This | I am a number, but when you add ‘G’ to me, I go away. What number am I?

March 2024 Edition Hayyy Splunk Education Enthusiasts and the Eternally Curious!  We’re back with another ...

What’s New in Splunk App for PCI Compliance 5.3.1?

The Splunk App for PCI Compliance allows customers to extend the power of their existing Splunk solution with ...

Extending Observability Content to Splunk Cloud

Register to join us !   In this Extending Observability Content to Splunk Cloud Tech Talk, you'll see how to ...