L
Lori
I am building a database that will calculate up time for
our departments servers. If a server has down time the
boss will enter beginning time down, and end time down and
date. I need to build a query that will calculate all
down time by month, and give the percentage of time that
the systems were up for that month. For example, the
server was down for 7 hours in the month of November.
There are 720 hours in November, so the server was up and
running for 99.1% of November.
our departments servers. If a server has down time the
boss will enter beginning time down, and end time down and
date. I need to build a query that will calculate all
down time by month, and give the percentage of time that
the systems were up for that month. For example, the
server was down for 7 hours in the month of November.
There are 720 hours in November, so the server was up and
running for 99.1% of November.