Dashboards & Visualizations
Highlighted

Create a table from only certain fixed values

New Member

Hi,

I have a search that returns hundreds of results. Each result contains a field called jobName and another field called server
I need to build a table with 2 columns from a fixed set of JobNames. However, if one of the JobName in my defined list is not found in the search result, I need to return 'Not found'

Table should look like:
JobName server
JobA Server1
JobB Server2
JobE Not found
JobX Server6

Can anyone please help on how to generate the output above?
Thanks

Labels (1)
Tags (1)
0 Karma
Highlighted

Re: Create a table from only certain fixed values

SplunkTrust
SplunkTrust

can you share a sample of your data?
try and look into the fillnull command
https://docs.splunk.com/Documentation/Splunk/8.0.3/SearchReference/Fillnull

... your search ... | fields jobName server | table jobName server | fillnull value="Not found" server

hope it helps

View solution in original post

0 Karma
Highlighted

Re: Create a table from only certain fixed values

New Member

Thanks! The fillnull function works

0 Karma