DB

[Bill]

I know little about access..have dabbled a bit but definitely a novice. What
I'd like to do is build a simple database where I can input entries that
include: Servername, downtime in minutes, date of downtime. Then at the end
of the week, I'd like to run a report that will give me all of the data with
the server names, total downtime and percentage of uptime. Does anyone have
anything like this or can possibly point me in the right direction? Pointers?
Suggestions?

Thanks

 

[John Vinson]

I know little about access..have dabbled a bit but definitely a novice. What
I'd like to do is build a simple database where I can input entries that
include: Servername, downtime in minutes, date of downtime. Then at the end
of the week, I'd like to run a report that will give me all of the data with
the server names, total downtime and percentage of uptime. Does anyone have
anything like this or can possibly point me in the right direction? Pointers?
Suggestions?

Thanks

Well, you've almost designed the database right there!

I'd see two tables: Servers and Downtime:

Servers
ServerID <perhaps the unique ServerName as the primary key>
Description

Downtimes
ServerID
TimeWentDown date/time
TimeBackUp date/time

You could create a Form based on Servers with a subform based on
Downtimes, or simply a single form based on Downtimes with a Server
combo box; enter the date and time when the machine went down and when
it recovered.

You could then easily do a Totals query using

DateDiff("s", [TimeWentDown], [TimeBackUp])

to calculate the duration of the outage; this can be summed, grouping
by ServerID, using a criterion such as

[TimeWentDown] >= DateAdd("d", -7, Date()) AND [TimeWentDown] < Date()

to retrieve all outages which occurred between midnight a week ago and
midnight last night; other criteria can easily be used instead.

John W. Vinson[MVP]
Join the online Access Chats
Tuesday 11am EDT - Thursday 3:30pm EDT
http://community.compuserve.com/msdevapps

 

[Bill]

I know little about access..have dabbled a bit but definitely a novice. What
I'd like to do is build a simple database where I can input entries that
include: Servername, downtime in minutes, date of downtime. Then at the end
of the week, I'd like to run a report that will give me all of the data with
the server names, total downtime and percentage of uptime. Does anyone have
anything like this or can possibly point me in the right direction? Pointers?
Suggestions?

Thanks

Well, you've almost designed the database right there!

I'd see two tables: Servers and Downtime:

Servers
ServerID <perhaps the unique ServerName as the primary key>
Description

Downtimes
ServerID
TimeWentDown date/time
TimeBackUp date/time

You could create a Form based on Servers with a subform based on
Downtimes, or simply a single form based on Downtimes with a Server
combo box; enter the date and time when the machine went down and when
it recovered.

You could then easily do a Totals query using

DateDiff("s", [TimeWentDown], [TimeBackUp])

to calculate the duration of the outage; this can be summed, grouping
by ServerID, using a criterion such as

[TimeWentDown] >= DateAdd("d", -7, Date()) AND [TimeWentDown] < Date()

to retrieve all outages which occurred between midnight a week ago and
midnight last night; other criteria can easily be used instead.

John W. Vinson[MVP]
Join the online Access Chats
Tuesday 11am EDT - Thursday 3:30pm EDT
http://community.compuserve.com/msdevapps

Thanks alot John, I appreciate the reponse. Good tips. I suppose I could
have posted this in a better forum as I'm looking for how to do this as
opposed to design but you gave me some good pointers and I'll see what I can
do. Thanks.