×

Are you a member of the Splunk Community?

Sign in or Register with your Splunk account to get your questions answered, access valuable resources and connect with experts!
cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Show  only  | Search instead for 
Did you mean: 
Ask a Question
sunny_87
New Member
Member since: ‎02-07-2023
‎02-08-2023
Community Statistics
Posts 3
Solutions 0
Karma Given 0
Karma Received 0
Member Since ‎02-07-2023
Activity Feed
View All

Re: Calculate Availablity of a API

by in Splunk Enterprise
‎02-08-2023 01:30 AM
‎02-08-2023 01:30 AM
Thanks @richgalloway How do I proceed and get that single number percentage based on assumption of status codes. This is the status code values looks like for last 24 hours - Values Count %   200 64,260 99.272%   400 471 0.728% ... View more

Re: Calculate Availablity of a API

by in Splunk Enterprise
‎02-07-2023 09:49 AM
‎02-07-2023 09:49 AM
Hi @richgalloway Thank you for the detailed response. That makes total sense and that's why I wanted to ask that question. I was thinking to do something like this - Calculate success rate and failure rate and let's say success rate for last 15 minutes comes as 99% and failed 1% can we say that the service/API was UP for 99% of time. I know it's not exactly the uptime because the service may be UP but failing for some or other reason like network issues. Can we calculate something like this? Based on the success percentage, can we determine it's uptime. It's NOT exact calculation but at least will give something. We can also include average response time in the calculation. what's your view? ... View more

How to calculate availability of a API?

by in Splunk Enterprise
‎02-07-2023 06:13 AM
‎02-07-2023 06:13 AM
Hello Splunkees, I have a requirement where I need to calculate the availability or uptime percentage of some Critical APIs. We ingest those API logs in Splunk and it tells us about the throughput, latency and HTTP status codes. Is there a way to calculate the availability of any API using these metrics? I mean something like calculating the success and failure rate and then based on that come up with a number to say how much available my API is. Does anyone have any basic query which can calculate that?  I have created something like below to calculate the success and failure rates -   index=myapp_prod sourcetype="service_log" MyCriticalAPI Status=200 | timechart span=15m count as SuccessRequest | appendcols [ search index=myapp_prod sourcetype="service_log" MyCriticalAPI NOT Status=200 | timechart span=15m count as FailedRequest] | eval Total = SuccessRequest + FailedRequest | eval successRate = round(((SuccessRequest/Total) * 100),2) | eval failureRate = round(((FailedRequest/Total) * 100),2)     ... View more
Contact Me
Online Status
Offline
Date Last Visited
‎02-08-2023 02:29 PM