I'm trying to craft a search to count the use of operating systems in our organization. I don't want the duplicates.
The search I have right now isn't getting me the desired results.
index="LOGSIWANT" | stats count by OSVERSION | sort - count
This counts how many times the OS is in the logs, but doesn't account for 1 count per Host, It just counts it all.
I want to do this without counting everything. Host is the field that contains the computers name so how would I use this to parse my data down to 1 occurrence per host for a true count of what OS is most popular in our organization?
I've got several other searches that need this logic, but This example should be enough.
I'm headed out for the day and will answer this in the morning.
Thanks much ahead of time for the help Splunk Ninja Masters!
How about this?
index="LOGSIWANT" | dedup host | stats count by OSVERSION | sort - count
How about this?
index="LOGSIWANT" | dedup host | stats count by OSVERSION | sort - count