Create report showing total servers and what sourcetypes they are collecting, including operating system and version

Path Finder

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.

0 Karma

Ultra Champion
  1. you have this report in the DMC (MC) under forwarders
  2. look for ways to verify your windows hosts send the correct data, many answers here about this subject hope it helps
0 Karma
Get Updates on the Splunk Community!

.conf24 | Day 0

Hello Splunk Community! My name is Chris, and I'm based in Canberra, Australia's capital, and I travelled for ...

Enhance Security Visibility with Splunk Enterprise Security 7.1 through Threat ...

(view in My Videos)Struggling with alert fatigue, lack of context, and prioritization around security ...

Troubleshooting the OpenTelemetry Collector

  In this tech talk, you’ll learn how to troubleshoot the OpenTelemetry collector - from checking the ...