Splunk Search

List process count and 0 when didn't found

leonardomassard
Explorer

I'm tring to do a search for some process for a server but I would like for those that are not running the result comes with 0, becouse in splunk the process when not running they don't bring any information:

exemplo:
index=os sourcetype=ps host IN (wmwl5000 , wmwl5001, wmwl5002)
| search process="launch.sh" OR process="WebLogic.sh"
| stats count(process) by host

What I wish to see is like this:

wmwl5000 launch.sh 1
wmwl5000 weblogic.sh 0
wmwl5001 launch.sh 1
wmwl5001 weblogic.sh 1

Cheers

Tags (1)
0 Karma

kamlesh_vaghela
SplunkTrust
SplunkTrust

@leonardomassardi

Have you tried this?

index=os sourcetype=ps host IN (wmwl5000 , wmwl5001, wmwl5002)
| search process="launch.sh" OR process="WebLogic.sh"
| stats count(process) by host,process 
0 Karma
Get Updates on the Splunk Community!

New Year, New Changes for Splunk Certifications

As we embrace a new year, we’re making a small but important update to the Splunk Certification ...

Stay Connected: Your Guide to January Tech Talks, Office Hours, and Webinars!

What are Community Office Hours? Community Office Hours is an interactive 60-minute Zoom series where ...

[Puzzles] Solve, Learn, Repeat: Reprocessing XML into Fixed-Length Events

This challenge was first posted on Slack #puzzles channelFor a previous puzzle, I needed a set of fixed-length ...