Splunk Search

Splunk JavaScript API getting stats in a search

najarvis
Engager

I am using the Splunk JavaScript API to create a dashboard to aggregate data. One of my searches that I want literally just sums up the total of a given field using

search index=[index] source="[path]" | stats sum("Val_in rep_cur") as Total

Even though this gives the correct number on the website, it is in the 'statistics' tab. When I run this same search in the JavaScript API, the results object is just empty. How can I get the sum of a field in the JavaScript API?

EDIT:
So it looks like if I replace stats with eventstats it will add a new field to each event. However, I am still not getting any results in the API.

My new search is

search index=[index] source="[path]" | eventstats sum("Val_in rep_cur") as Total | dedup Total | fields Total
0 Karma
1 Solution

najarvis
Engager

Somehow removing the source ended up fixing the problem. The answer I was looking for was changing stats to eventstats. I only had two backslashes in my search, but because it was in a string in JavaScript it needed 4.

source="G:\\AutoIndex\\spending\\Catalog Report - 8758 Devices.csv"

should've been

source="G:\\\\AutoIndex\\\\spending\\\\Catalog Report - 8758 Devices.csv"

View solution in original post

0 Karma

najarvis
Engager

Somehow removing the source ended up fixing the problem. The answer I was looking for was changing stats to eventstats. I only had two backslashes in my search, but because it was in a string in JavaScript it needed 4.

source="G:\\AutoIndex\\spending\\Catalog Report - 8758 Devices.csv"

should've been

source="G:\\\\AutoIndex\\\\spending\\\\Catalog Report - 8758 Devices.csv"
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, Repeat: Character substitutions with Regular Expressions

This challenge was first posted on Slack #puzzles channelFor BORE at .conf23, we had a puzzle question which ...

Splunk Community Badges!

  Hey everyone! Ready to earn some serious bragging rights in the community? Along with our existing badges ...

[Puzzles] Solve, Learn, Repeat: Matching cron expressions

This puzzle (first published here) is based on matching timestamps to cron expressions.All the timestamps ...