Create
cancel
Showing results for 
Search instead for 
Did you mean: 
Sign up Log in
Celebration

Earn badges and make progress

You're on your way to the next level! Join the Kudos program to earn points and save your progress.

Deleted user Avatar
Deleted user

Level 1: Seed

25 / 150 points

Next: Root

Avatar

1 badge earned

Collect

Participate in fun challenges

Challenges come and go, but your rewards stay with you. Do more to earn more!

Challenges
Coins

Gift kudos to your peers

What goes around comes around! Share the love by gifting kudos to your peers.

Recognition
Ribbon

Rise up in the ranks

Keep earning points to reach the top of the leaderboard. It resets every quarter so you always have a chance!

Leaderboard

Come for the products,
stay for the community

The Atlassian Community can help you and your team get more value out of Atlassian products and practices.

Atlassian Community about banner
4,459,779
Community Members
 
Community Events
176
Community Groups

Export Data Report on historical availability

We are looking to incorporate the history availability tracked within Statuspage.io components where we have set this feature on: 

Display uptime

Display the historical status of this component on my status page
Is there some way to produce an export or a report that could be combined using the historical data. 
We want to produce a quarterly uptime report based upon certain components over a 1 year period.  Ideally exported to excel in order to combine. 

1 answer

1 vote
Daniel Eads Atlassian Team Aug 30, 2021

Hi Paul, welcome to the Community!

Currently there aren't graphical/in-app options for exporting historical uptime data. The subscriber lists are the only data available for export from the web interface.

However, the API provides access to all the component and incident data. The Get a list of incidents endpoint should provide all the info necessary for a report like this. The fields you might want to look at from the reply:

  • created_at
  • resolved_at
  • components
  • status ("resolved" will be the end status for realtime incidents, while "completed" is the end-state for scheduled maintenance)

From that data, you could filter per-component and decide if scheduled events will be part of the downtime calculation. You can get the difference between the created and resolved timestamps to determine the downtime for the incident, and then compare that against the total time in the period you're tracking (quarter, year). I would imagine that something like a python script would be easier to write and schedule for this than an excel macro, but the results of a script could be exported to CSV to manipulate in Excel or create graphs from.

To my knowledge, there are not scripts like this that folks have created and published for others to use. If you do create such a script, it would be interesting to publish on Community for others to benefit from and help improve.

Cheers,
Daniel

Suggest an answer

Log in or Sign up to answer
TAGS

Atlassian Community Events