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,295,642
Community Members
 
Community Events
165
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
Community showcase
Published in Statuspage

New feature: Slack notifications for Statuspage

We're excited to announce the release of a long-requested feature on Statuspage. Now visitors to your status page can subscribe to get notified in Slack when you report an incident or maintenance. Th...

3,055 views 8 20
Read article

Community Events

Connect with like-minded Atlassian users at free events near you!

Find an event

Connect with like-minded Atlassian users at free events near you!

Unfortunately there are no Community Events near you at the moment.

Host an event

You're one step closer to meeting fellow Atlassian users at your local event. Learn more about Community Events

Events near you