Splunk Search

Lookup table question

myoung54
Explorer

Hello all,

I searched around for quite a while and I couldn't find an answer to this, so I figured I'd just ask. My organization has dozens upon dozens of lookup tables, and I was wondering if there was a way to see what specific lookup tables a given dashboard is using?

Being that my organization has so many lookup tables, it can be hard to know which one needs editing because you can't tell what's in use and what's a duplicate.

0 Karma
1 Solution

arjunpkishore5
Motivator

The rest endpoint /data/ui/views provides all dashboard definitions. Assuming that SPL is in the dashboard and not within a saved search, you can use this.

| rest servicesNS/-/-/data/ui/views 
| rename eai:acl.app as app, eai:data as data 
| rex field="data" max_match=0 "\|\s*(input|output)?lookup\s*(?<lookup_file>\S+)" 
| search lookup_file=* 
| table app, title, lookup_file 
| mvexpand lookup_file

Some cleanup might be required on the file names, but this should get you started.

Hope this helps. Please mark as answer if this is what you were looking for.

Cheers!

View solution in original post

0 Karma

woodcock
Esteemed Legend
0 Karma

arjunpkishore5
Motivator

The rest endpoint /data/ui/views provides all dashboard definitions. Assuming that SPL is in the dashboard and not within a saved search, you can use this.

| rest servicesNS/-/-/data/ui/views 
| rename eai:acl.app as app, eai:data as data 
| rex field="data" max_match=0 "\|\s*(input|output)?lookup\s*(?<lookup_file>\S+)" 
| search lookup_file=* 
| table app, title, lookup_file 
| mvexpand lookup_file

Some cleanup might be required on the file names, but this should get you started.

Hope this helps. Please mark as answer if this is what you were looking for.

Cheers!

0 Karma

myoung54
Explorer

This is exactly what I was looking for, thank you!!

0 Karma

marycordova
SplunkTrust
SplunkTrust

Is this the kind of dashboard panel you can open with the magnifying glass to view the SPL? The lookup tables might be discernible there.

@marycordova
0 Karma
Career Survey
First 500 qualified respondents will receive a $20 gift card! Tell us about your professional Splunk journey.

Can’t make it to .conf25? Join us online!

Get Updates on the Splunk Community!

Take Action Automatically on Splunk Alerts with Red Hat Ansible Automation Platform

 Are you ready to revolutionize your IT operations? As digital transformation accelerates, the demand for ...

Calling All Security Pros: Ready to Race Through Boston?

Hey Splunkers, .conf25 is heading to Boston and we’re kicking things off with something bold, competitive, and ...

Beyond Detection: How Splunk and Cisco Integrated Security Platforms Transform ...

Financial services organizations face an impossible equation: maintain 99.9% uptime for mission-critical ...