- Mark as New
- Bookmark Message
- Subscribe to Message
- Mute Message
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Why is my inputlookup table not working?
I wanted to ask you for some help. I am trying to create a lookup table on Splunk. I can’t make it work and I can't figure out why.
Query: | inputlookup TrainingList.csv
The following are the things I did:
- Created the TrainingList.csv file on /opt/splunk/etc/apps/MyApp/lookups
- Defined the stanza on /opt/splunk/etc/apps/MyApp/local/transforms.conf
Stanza was defined as:
[TrainingList]
filename = TrainingList.csv
- Mark as New
- Bookmark Message
- Subscribe to Message
- Mute Message
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Hi,
How are you accessing this lookup table, with query | inputlookup TrainingList.csv OR | inputlookup TrainingList?
In which app are you accessing this lookup in Splunk GUI ? For example if you are running above query in Search & Reporting app and MyApp has default sharing permission to App level only, then lookup file or lookup definition which created in MyApp will have app level permission and you will not able to search those lookup files and lookup definitions in other apps. In this case either change MyApp App permission to Global level with read access to everyone OR change lookup file & lookup definition in MyApp from App level to Global.
- Mark as New
- Bookmark Message
- Subscribe to Message
- Mute Message
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Permissions and context were ok. I deleted everything and managed to create it through the GUI and works. Thanks all for the help.
- Mark as New
- Bookmark Message
- Subscribe to Message
- Mute Message
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
hi @albin111,
did you figure out an answer to this problem?
- Mark as New
- Bookmark Message
- Subscribe to Message
- Mute Message
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Did you do this through the config files, or the GUI? If you did it through the config files, you will probably need to bounce the Search Head or do a debug refresh: https://answers.splunk.com/answers/102568/reload-transforms-conf-without-restarting-splunk.html
- Mark as New
- Bookmark Message
- Subscribe to Message
- Mute Message
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
I did it directly in the config files. I've restarted the server, I did the debug/refresh thing too. I don't know what else to do LOL.
- Mark as New
- Bookmark Message
- Subscribe to Message
- Mute Message
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Have you tried doing it through the GUI?
- Mark as New
- Bookmark Message
- Subscribe to Message
- Mute Message
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
I managed to delete the file and recreate it through the GUI. Thanks.
- Mark as New
- Bookmark Message
- Subscribe to Message
- Mute Message
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Sadly, I don't have the Datasets addon. I cannot just download it because of security reasons. If you know any short term solution, please share.
- Mark as New
- Bookmark Message
- Subscribe to Message
- Mute Message
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Nope. I'm so used to doing everything through the console that I always neglect the GUI. I will try and see.
