Reporting

Why is my scheduled report only returning one row using the top command?

bgwalters
New Member

I have a very simple search saved as a Scheduled E-mail Report. When I manually run the search it works as expected. The scheduled e-mail report only contains the first entry or I've also received separate e-mails each containing a row from the report.

The search string ends with | top limit=20 field_name_here Is there something I don't realize about the top command that would affect scheduled reports?

Thank you!

0 Karma
1 Solution

aakwah
Builder

Hello,

I suspect the Alert mode parameter in Alert definition, it could be: Once per search or Once per result.
Set it to Once per search and check the behavior, you can do from Web interface or from savedsearches.conf:

alert.digest_mode = True 

Regards

View solution in original post

0 Karma

aakwah
Builder

Hello,

I suspect the Alert mode parameter in Alert definition, it could be: Once per search or Once per result.
Set it to Once per search and check the behavior, you can do from Web interface or from savedsearches.conf:

alert.digest_mode = True 

Regards

0 Karma

bgwalters
New Member

How do I check the Alert definition for a Report via the web interface (6.5.2) ? I can't seem to find anything about "Alert" for this Report....

0 Karma

aakwah
Builder

Settings -> Searches, reports, and alerts -> Click the alert under Search name column -> Alert mode

0 Karma

ruchir
Explorer

Is your Alert mode set as Once per result?
Can you share the search and other alert options you set in report?

0 Karma

cmerriman
Super Champion

try just |top 20 field_name_here

0 Karma

bgwalters
New Member

This did not help unfortunately. Same behavior.

0 Karma
Get Updates on the Splunk Community!

Extending Observability Content to Splunk Cloud

Watch Now!   In this Extending Observability Content to Splunk Cloud Tech Talk, you'll see how to leverage ...

More Control Over Your Monitoring Costs with Archived Metrics!

What if there was a way you could keep all the metrics data you need while saving on storage costs?This is now ...

New in Observability Cloud - Explicit Bucket Histograms

Splunk introduces native support for histograms as a metric data type within Observability Cloud with Explicit ...