Splunk Search

How to add a word after a count?

jip31
Builder

Hello

I use the search below and I would like to do 2 different things
1) How to do for adding a word after the stats count (for example I would like to have "250 machines")
2) How to do for adding a word with condition after the stats count (for example I would like to have "250 machines" if number of host is >0 and "any machines" if host=0 )

| inputlookup host.csv 
| stats count by host

Thanks

Tags (2)
0 Karma
1 Solution

chrisyounger
SplunkTrust
SplunkTrust

Try this:

| inputlookup host.csv 
| stats count by host
| eval count = if(count == 0, "any machines", tostring(count) + " machines")

View solution in original post

KailA
Contributor

You can try that

| inputlookup host.csv 
| stats count by host
| eval count = if(count > 0, count." machines","Any machines")

Let me know 🙂

0 Karma

vnravikumar
Champion

Hi

try like

|stats count by host | eval count = if(count >0, count." "."machines", "any machines")
0 Karma

chrisyounger
SplunkTrust
SplunkTrust

Try this:

| inputlookup host.csv 
| stats count by host
| eval count = if(count == 0, "any machines", tostring(count) + " machines")

View solution in original post

jip31
Builder

Thanks!!!!

0 Karma
Take the 2021 Splunk Career Survey

Help us learn about how Splunk has
impacted your career by taking the 2021 Splunk Career Survey.

Earn $50 in Amazon cash!