Schedule Me

S

Striker

I have a bunch of assets (Servers) that need regular maintenance. They are
located in different locations around the country. I already have a Server
database that has server names, IP's, location, etc in it. I want to create
a few tables to help me schedule regular maintenance and reboots on these
things.
So I thought about creating a "Maintenance Window" table with "Start Times"
and "End Times" fields. Link it to the asset's IP address since that is the
Primary key in the assets table.

The problem I came across is that some of these things have maintenance
windows that are different on Monday than they are on Friday. In other word
users work late on Fridays and maintenance can't begin until later than
during the normal week. Some of these are in use 24/7 and can only be
serviced during holidays.

Give the above and that I already have an assets table, can someone guide me
to creating the other tables and fields? I'm thinking about reoccurring
appointments. For instance this server can be taken out of service every
Monday between 7PM and 6AM. I would also like to have a "Last Maintenance"
field so I can easily query for the servers that need maintenance the worst,
not sure which table this should go into.

I'm sure I'll have a lot of questions about reporting and forms as we go on
in this adventure. For now if I can get the foundation, the tables I can go
from there.

Thank You
 
S

Striker

Maybe something like this will work? How do I create a miantenance record
if the maintenance was actually performed?

TABLES

Servers MaintenanceWindows MaintenanceRecords
IP IP IP
ServerName MonBegin MaintenanceNotes
MonEnd
TueBegin
TueEnd
Notes
Completed
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top