Knowledge Management

fileds command used in summary index not showin correct data ?

rakesh_498115
Motivator

Hi..

i have a main search which is given the count of id 's and writin to a summary index -summary

my summary index generator search
index="main" |sistats count by UniqueID,UniqueName

index="main" | stats count by UniqueID,UniqueName

index="summary" | fields UniqueID,UniqueName | stats count by UniqueID,UniqueName

both are showin different values..is this because of using fields in summary indexed data..
pls help..

Tags (1)
0 Karma
1 Solution

Jason
Motivator

When you summary index, you are only storing the basic statistics necessary to re-create the original summary table. So if your original search ends in sistats count by UniqueID,UniqueName, your search to pull data out of the summary should contain stats count by UniqueID,UniqueName - then do your fields, or other commands after that.

(If you think about it, if your original table gave the result "field1=a, count=3", the summary would store this as one event. Doing a "stats count by field1" directly on the summary index would return a value of "field1=a, count=1" because there is only one row in the summary index.)

View solution in original post

Jason
Motivator

When you summary index, you are only storing the basic statistics necessary to re-create the original summary table. So if your original search ends in sistats count by UniqueID,UniqueName, your search to pull data out of the summary should contain stats count by UniqueID,UniqueName - then do your fields, or other commands after that.

(If you think about it, if your original table gave the result "field1=a, count=3", the summary would store this as one event. Doing a "stats count by field1" directly on the summary index would return a value of "field1=a, count=1" because there is only one row in the summary index.)

Jason
Motivator

If it solves your problem, please mark it as the accepted answer and up vote

0 Karma

rakesh_498115
Motivator

thanx 4 the reply jason

0 Karma
Get Updates on the Splunk Community!

Detecting Remote Code Executions With the Splunk Threat Research Team

REGISTER NOWRemote code execution (RCE) vulnerabilities pose a significant risk to organizations. If ...

Observability | Use Synthetic Monitoring for Website Metadata Verification

If you are on Splunk Observability Cloud, you may already have Synthetic Monitoringin your observability ...

More Ways To Control Your Costs With Archived Metrics | Register for Tech Talk

Tuesday, May 14, 2024  |  11AM PT / 2PM ET Register to Attend Join us for this Tech Talk and learn how to ...