Splunk Search

Lookup from multiple table

basics
Explorer

Hello,

my goal is to find and combine data from multiple source.

Here:

  • employee_lookup: the table for all employee database
  • product_lookup: the table for all the product 

now my goal is to find, how many company wide product each department uses and group by DepartmentName, ProductName, and Count.

The department name is on the  "employee_lookup" table along with employee name, department name. So when any employee clicks on a product, it is counted as a product use and logs the data into Splunk.

my Splunk query is as follows:

 

data = "global"
|  lookup  product_lookup productID OUTPUT ProductName
|  lookup employee_lookup userID OUTPUT DepartmentName
|  table ProductName, DepartmentName, UserID

that query does not work...

 

My goal is to find the total count of product usages by Department. 

The resulting table should be like:

 

DepartmentName,     Product,     count
--------------------------------------------------
Dept_5,     Product1234,     2000
Dept_5,     Product333,     1434
Dept_5,     Product633,     600
Dept_2,   Product333,     2500
Dept_2,   Product215,     2500
Dept_2,   Product415,     1200
....

so basically group by department, product, count 

any suggestions and recommendation would be very helpful. Thank you!

Labels (7)
0 Karma

basics
Explorer

I had a typo and it works now.

However, couple more questions because I cannot do:

  • Group by DepartmentName, ProductName, Count

how do I do that?

 

0 Karma

to4kawa
Ultra Champion

your query

| stats count by DepartmentName, ProductName


0 Karma

to4kawa
Ultra Champion

If your log has both productID and userID field, your query will run.
If there aren't these, you should provide more details.

0 Karma
Got questions? Get answers!

Join the Splunk Community Slack to learn, troubleshoot, and make connections with fellow Splunk practitioners in real time!

Meet up IRL or virtually!

Join Splunk User Groups to connect and learn in-person by region or remotely by topic or industry.

Get Updates on the Splunk Community!

Accelerate Splunk App Development with AI

  Learn how to automate the repetitive parts of your build cycle.   Watch On-Demand   Replay the Accelerate ...

Splunk Agent Observability: Measuring AI Value with Splunk Tokenomics on AWS

The AI landscape is moving faster than ever, and our latest 2026 State of Observability report provides the ...

Enterprise Security Watch Party: What’s New in 8.8 - Recap

Splunk Community HQ hosted a Splunk Enterprise Security Watch Party: What’s New In ES 8.8 last Thursday. I had ...