Export Data Report on historical availability

[Paul Yuro]

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. 

[Daniel Eads]

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