Server Uptime/Downtime Calculation

Hi

New to the site and new to excel so hope someone can help, we have a number of internal office servers (Active Directory – Exchange – SharePoint “free” etc etc usual stuff) and I need to create an uptime/downtime calculator in excel with the facility to record the information on a daily, monthly and yearly bases but not sure how to go about this.

I would like a way to record on a daily bases what the uptime/downtime has been for each server and then to record the same for that month in a percentage…



For example in a 24hr period for each month of the year:
For that day Active Directory Server was UP for 24hrs. (100% uptime) – (0% downtime)
X by the number of days in the month i.e.
Over the month Active Directory has been UP for. (XX% uptime) – (XX% downtime)

Exchange Server was DOWN for 1hrs. (95.833% uptime) – (x% downtime)
X by the number of days in the month i.e.
Over the month Exchange has been UP for. (XX% uptime) – (XX% downtime)

SharePoint Server was DOWN for 1hrs. (95.833% uptime) – (x% downtime)
X by the number of days in the month i.e.
Over the month SharePoint has been UP for. (XX% uptime) – (XX% downtime)



Appreciate any help anyone can give me.

Hi,

I have created a template by going through the description you have provided. Please check if this suits your requirement (workbook uploaded).

Regards,
Chandra



Please click on ‘* Add Reputation’ button on the left side bottom of my post if I was helpful in resolving the issue.

Pl see attached file.

Pl see attached file.

Hi kvsrinivasamurthy

Thank you so much for all your help. From the calculation you have done for me I have now managed to create what I need for Server/System/Network Uptime and Downtime in % KPI's. Therefore I wanted to share what we've managed to do.

All that needs to be done to use the % Server/Network KPI calculator is:
1) Change Heading Name (i.e. Exchange) to what you want.
2) Add the date for each day of a failure.
3) Add the Downtime (Start) in the format of 24 hrs (15:00).
4) Add the Downtime (End) in the format of 24 hrs (15:15).
5) Add/Copy the TABs at the bottom for each month you need and re-name.

This will calculate the % for each day and the total for the month, if I have missed anything please feel free to amend and share.

Once again, thanks for the help.

Rovert

Dear kvsrinivasamurthy,
Can you kindly convert the recording of downtime to Seconds instead of per hours?

Thanks