Getting Data In

check who is ingesting data to index=main

Mohsin123
Path Finder

is there a way on how to check who is ingesting data to index=main
I want to know list of source, sourcetype,host for the data and check hosts/data belongs to which team

Tags (1)
0 Karma

woodcock
Esteemed Legend

Like this:

| tstats max(_indextime) AS _time first(source) WHERE index=main BY host sourcetype

harsmarvania57
Ultra Champion

Hi,

If you have access to license usage logs then it will be good start to checking those logs. You can use below query to check license usage of main index which will give you Host, Source, Sourcetype

index=_internal source=*license_usage.log* idx=main | stats sum(b) As Bytes by h,s,st,idx | rename h AS Host, s AS Source, st AS Sourcetype, idx AS Index | table Host,Source,Sourcetype,Index,Bytes
0 Karma

nickhills
Ultra Champion

Try this:

index=main |stats last(sourcetype) by source host
If my comment helps, please give it a thumbs up!
0 Karma
Got questions? Get answers!

Join the Splunk Community Slack to learn, troubleshoot, and make connections with fellow Splunk practitioners in real time!

Meet up IRL or virtually!

Join Splunk User Groups to connect and learn in-person by region or remotely by topic or industry.

Get Updates on the Splunk Community!

[Puzzles] Solve, Learn, Reuse: Word-play

This puzzle series (first published here) is based on analysing words.Some of the statements in your puzzle ...

Tuning Edge Processor in Hybrid Mode: What Limits Each Data Path

When you run Edge Processor in hybrid mode, alongside a Splunk heavy forwarder on the same host, two questions ...

Best Practices: Splunk auto adjust pipeline queue

When you enable autoAdjustQueue in Splunk, maxSize should be understood as the queue size Splunk starts with ...