Alerting

How to find out a lookup is used in how many saved searches.

msplunk33
Path Finder

I have a few lookups created by users they left the organization. We need to remove this lookups since it take large amount of space. Before we remove is there any query we can find out  how many searches using this lookup.

Labels (1)
0 Karma
1 Solution

richgalloway
SplunkTrust
SplunkTrust

This is easiest to do from the CLI.  First, search all transforms.conf files to see if a lookup definition uses the lookup files.

find /opt/splunk/etc -name transforms.conf -print0 | xargs -r0 grep #lookupfilename#

Replace #lookupfilename# with the actual name of the lookup (probably a .csv file).  Repeat this for each lookup.  The output, if any, will tell you if the lookup file is used by a lookup definition.

Next, search savedsearches.conf files for the lookups and lookup files you've identified.

find /opt/splunk/etc -name savedsearches.conf -print0 | xargs -r0 grep #lookupname#

 

---
If this reply helps you, an upvote would be appreciated.

View solution in original post

richgalloway
SplunkTrust
SplunkTrust

This is easiest to do from the CLI.  First, search all transforms.conf files to see if a lookup definition uses the lookup files.

find /opt/splunk/etc -name transforms.conf -print0 | xargs -r0 grep #lookupfilename#

Replace #lookupfilename# with the actual name of the lookup (probably a .csv file).  Repeat this for each lookup.  The output, if any, will tell you if the lookup file is used by a lookup definition.

Next, search savedsearches.conf files for the lookups and lookup files you've identified.

find /opt/splunk/etc -name savedsearches.conf -print0 | xargs -r0 grep #lookupname#

 

---
If this reply helps you, an upvote would be appreciated.

View solution in original post

scelikok
SplunkTrust
SplunkTrust

Hi @msplunk33,

You can use below search by updating your lookup file name.

index=_audit action=search search_id=* *lookup_name*
If this reply helps you an upvote is appreciated.
Did you miss .conf21 Virtual?

Good news! The event's keynotes and many of its breakout sessions are now available online, and still totally FREE!