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!

Quantify Your Splunk Investment Impact: Introducing Savings Metrics to Value Insights

Building on the foundation established in our initial Value Insights releases, we are introducing the Savings ...

Event Series: Telemetry Pipeline Management

Balancing Scale and Spend: Gaining Control Over High-Volume Metrics in Splunk Observability Cloud As ...

Kick the Tires Before You Commit: A Hands-On Tour of the Splunk Observability Cloud ...

Evaluating an enterprise observability platform usually goes like this: fill out a form, get a free trial with ...