topic Re: Lookup table question in Splunk Search

Lookup table question

myoung54 — Wed, 06 Nov 2019 13:56:32 GMT

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.

Re: Lookup table question

marycordova — Wed, 06 Nov 2019 19:41:49 GMT

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.

Re: Lookup table question

arjunpkishore5 — Thu, 07 Nov 2019 01:00:18 GMT

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!

Re: Lookup table question

woodcock — Thu, 07 Nov 2019 03:10:07 GMT

Take a look at this Q&A:
https://answers.splunk.com/answers/329645/is-there-a-programmatic-method-to-list-and-analyze.html

Re: Lookup table question

myoung54 — Thu, 07 Nov 2019 14:01:54 GMT

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