Splunk Search

List Codes that are not in the lookup table

aquinojason
Path Finder

Hi,

I have a list of accounting codes in a lookup table. I use that to identify applications under that accounting code and . If the accounting code is not in the lookup table, it becomes "Others". How do I generate a report wherein the results will only list those "Others" and showing the accounting code used?

 

Thanks and Regards,

Labels (1)
0 Karma
1 Solution

ITWhisperer
SplunkTrust
SplunkTrust

| where accountingCode="Others"

View solution in original post

0 Karma

ITWhisperer
SplunkTrust
SplunkTrust

| where accountingCode="Others"

0 Karma

aquinojason
Path Finder

Hi,

Thank you very much for the response and support. I have learned a lot from your answers.

 

0 Karma
Get Updates on the Splunk Community!

Splunk Observability Cloud | Unified Identity - Now Available for Existing Splunk ...

Raise your hand if you’ve already forgotten your username or password when logging into an account. (We can’t ...

Index This | How many sides does a circle have?

February 2024 Edition Hayyy Splunk Education Enthusiasts and the Eternally Curious!  We’re back with another ...

Registration for Splunk University is Now Open!

Are you ready for an adventure in learning?   Brace yourselves because Splunk University is back, and it's ...