I'm working on a query that will tell me all the servers reporting in my environment, but broken down by operating system and version. I also need to see what exactly each host is logging. So I was thinking of two separate queries:
1. index=_internal |dedup os,hostname| stats count(hostname) by os
this one doesn't show me the variations of OS. I need help with that.
2. This search would show all Windows servers and what sourcetypes they are collecting. I need to ensure they are logging security data.
I hope this makes sense. Thanks for the help guys.