Knowledge Management

I need to fill missing logs in summary index

kiamco
Path Finder

so I have this query

(host=pnr-proxy-prod* OR host=master*.menlosecurity.com* OR host=pnr-webui-prod*)
NOT (source=/var/log/safeview/haproxy.log OR source =/var/log/safeview/nginx-access.log)
(level=* OR "error: " OR "ERROR: " OR "warn: " OR "[warn]" OR "WARNING: " OR "INFO:" OR "info:" OR warning: )
| dedup 1 keepempty=false _time, ms_region,
| bucket _time span=5m
| rex field=_raw " (?<=[A+Z] - )(?[a-zA-Z]+)"

| eval level=if(isnull(level) ,other_level, level)

| eval ms_level= if(isnull(level),"no-level",level)

| eval ms_region=rtrim(ms_zone, "abcdefgh")

| eval event=if(isnull(event) ,"no-event", event)

| rex field=host "^(master-|safemail-)?(.*-prod-)?(?[0-9-]+[0-9])"

| stats count(event) as count by _time ,event, ms_region, source, ms_version, ms_level
| sort 0 _time

| collect to some index

the volume for this index by the hour is ~ millions, I missing some data when I compare the results with a more specific search

so my question is how would I fill up the index with the missing data manually using the collect command , i don't have access to the CLI

would inserting this to the query help :

| dedup 1 keepempty=false _time ,event, ms_region, source, ms_version, ms_level

sorry for the noob question I am new to splunk

0 Karma

somesoni2
Revered Legend

High level answer would to be find which data is missing and then run your collect command to summary index it. But it would be tricky to find which data is missing considering very heavy amount of data you've. Ideally if you've a specific criteria for which you see data, you need to apply those criteria to both regular search and summary index search and get a diff.

0 Karma
Get Updates on the Splunk Community!

Splunk at Cisco Live 2025: Learning, Innovation, and a Little Bit of Mr. Brightside

Pack your bags (and maybe your dancing shoes)—Cisco Live is heading to San Diego, June 8–12, 2025, and Splunk ...

Splunk App Dev Community Updates – What’s New and What’s Next

Welcome to your go-to roundup of everything happening in the Splunk App Dev Community! Whether you're building ...

The Latest Cisco Integrations With Splunk Platform!

Join us for an exciting tech talk where we’ll explore the latest integrations in Cisco &#43; Splunk! We’ve ...