Getting Data In

Why is Splunk rest api result not returning aggregated field?

santoshbwn
New Member
search index=abc dp_"response"| stats perc95(api_time_taken) as abc by api

 

This is the search query I am using while invoking through splunk rest API.

In the result, I am not getting the abc field, only the API values are listed . Is there anything specific I need to do to include perc95,avg or max values in the result.

 

From UI, it works completely fine where it shows the abc column with the 95 percentile value

If someone can guide me, it would be really helpful.

 

Thanks,

Santosh

Thank,

Santosh

0 Karma

kilimche
Explorer

Hi, @santoshbwn any update on your issue?

0 Karma

kilimche
Explorer

Hi, any update on your issue, Im facing similar problem when reading from SPLUNK Rest APi via ADF using 

| eval compliant=if(Days<60, "Yes", "No")]
| chart count(host) by system compliant | addtotals | eval No=round((100*No/Total),2) | eval Yes=round((100*Yes/Total),2) | fields – Total Yes No

 

I see the correct result via UI but only the summary in the ADF result

0 Karma
Get Updates on the Splunk Community!

Observe and Secure All Apps with Splunk

  Join Us for Our Next Tech Talk: Observe and Secure All Apps with SplunkAs organizations continue to innovate ...

Splunk Decoded: Business Transactions vs Business IQ

It’s the morning of Black Friday, and your e-commerce site is handling 10x normal traffic. Orders are flowing, ...

Fastest way to demo Observability

I’ve been having a lot of fun learning about Kubernetes and Observability. I set myself an interesting ...