Add a Reporting System that calculates the total Uptime percentage of my application

[rha-wtag]

Describe the feature request

My clients require a report of the amount of time my application faced a downtime.
For example: 100% Uptime in last 1 week
95% uptime in last 365 days.

Why do you personally want this feature to be implemented?

No response

How long have you been using this project?

No response

Additional information

No response

[johanjk]

The simplest workaround would be to:

• use gatus with sql backend.
• Realize there is an endpoint for uptime badges, doing nearly what you require.
• Take a look at the source code for the uptime badge generation:

  gatus/storage/store/sql/sql.go

  Lines 782 to 787 in 12b0480

  	`
  	SELECT SUM(total_executions), SUM(successful_executions), SUM(total_response_time)
  	FROM endpoint_uptimes
  	WHERE endpoint_id = $1
  	AND hour_unix_timestamp >= $2
  	AND hour_unix_timestamp <= $3

• Write your own query, interfacing with the gatus db.